диплом (1190840), страница 7
Текст из файла (страница 7)
}
}
$pay_sum = $pay_sum - $pay_money_sum;
$sumdeal = round($pay_sum * 0.9,2);
$sity = strToHexByRtf($city);
$FIO = strToHexByRtf($FIO);
$name_UK = strToHexByRtf($name_UK);
$FIO_uk = strToHexByRtf($FIO_uk);
$address_UK = strToHexByRtf($address_UK);
$street = strToHexByRtf($street);
$num_room = strToHexByRtf($num_room);
$dateprev = strToHexByRtf($dateprev);
$datesub = strToHexByRtf($datesub);
$sData = file_get_contents('rtf/cess.rtf');
$sData = str_replace('SITY', $sity, $sData);
$sData = str_replace('DATEMY', date('Y'), $sData);
$sData = str_replace('DATEM', date('m'), $sData);
$sData = str_replace('DATEN', date('d'), $sData);
$sData = str_replace('NAMEUSER', $FIO, $sData);
$sData = str_replace('NAMEUK', $name_UK, $sData);
$sData = str_replace('NAMEDIR', $FIO_uk, $sData);
$sData = str_replace('ADDRESSUK', $address_UK, $sData);
$sData = str_replace('INN', $inn, $sData);
$sData = str_replace('KS', $ks, $sData);
$sData = str_replace('BIK', $bik, $sData);
$sData = str_replace('OGRN', $ogrn, $sData);
$sData = str_replace('KPP', $kpp, $sData);
$sData = str_replace('NUMST', $numst, $sData);
$sData = str_replace('STREET', $street, $sData);
$sData = str_replace('NUMAP', $num_room, $sData);
$sData = str_replace('NUMHO', $case, $sData);
$sData = str_replace('PHONE', $tel, $sData);
$sData = str_replace('SUMM', $pay_sum, $sData);
$sData = str_replace('SUMDEAL', $sumdeal, $sData);
$sData = str_replace('DATEPREV', $dateprev, $sData);
$sData = str_replace('DATESUB', $datesub, $sData);
$sData = str_replace('DATEUPR', "$dateUK[2].$dateUK[1].$dateUK[0]", $sData);
$sData = str_replace('NONE', $name_col[1], $sData);
$sData = str_replace('NTWO', $name_col[2], $sData);
$sData = str_replace('NTHR', $name_col[3], $sData);
$sData = str_replace('NFOUR', $name_col[4], $sData);
$sData = str_replace('NFIVE', $name_col[5], $sData);
$sData = str_replace('NSIX', $name_col[6], $sData);
$sData = str_replace('NSEVEN', $name_col[7], $sData);
$sData = str_replace('SONE', $pay_col[1], $sData);
$sData = str_replace('STWO', $pay_col[2], $sData);
$sData = str_replace('STHR', $pay_col[3], $sData);
$sData = str_replace('SFOUR', $pay_col[4], $sData);
$sData = str_replace('SFIVE', $pay_col[5], $sData);
$sData = str_replace('SSIX', $pay_col[6], $sData);
$sData = str_replace('SSEVEN', $pay_col[7], $sData);
$sData = str_replace('RSBANK', $ckore, $sData);
file_put_contents("rtf/cess_$accaunt.rtf", $sData);
}
function notcess ($idroom)
{
if (isset($_COOKIE["user_uk"])) $idUK = $_COOKIE["user_uk"];
elseif (isset($_SESSION["user_uk"])) $idUK = $_SESSION["user_uk"];
$room=mysql_query("SELECT * FROM `room` WHERE idroom = '$idroom'");
while ($row2=mysql_fetch_array($room))
{
$accaunt=$row2['accaunt'];
$idobject=$row2['object_idobject'];
$idroom=$row2['idroom'];
$FIO=$row2['contractor'];
$num_room = $row2['name'];
}
$object=mysql_query("SELECT * FROM `object` WHERE idobject = '$idobject'");
while ($row1=mysql_fetch_array($object))
{
$dateUK = $row1['dateUK'];
$dateUK = explode("-", $dateUK);
}
$object=mysql_query("SELECT * FROM `data` WHERE object_idobject = '$idobject'");
while ($row1=mysql_fetch_array($object))
{
$city=$row1['city'];
$street=$row1['street'];
$numst=$row1['number'];
$case=$row1['case'];
}
$UK = mysql_query("SELECT * FROM `uk` WHERE idUK = '$idUK'");
while ($row1=mysql_fetch_array($UK))
{
$name_UK = $row1['name_uk'];
$FIO_uk = $row1['FIO'];
$address_UK = $row1['address'];
$inn = $row1['inn'];
$ckore = $row1['ckore'];
$kpp = $row1['kpp'];
$ks = $row1['ks'];
$ogrn = $row1['ogrn'];
$bik = $row1['bik'];
$tel = $row1['tel'];
}
$money = mysql_query("SELECT * FROM `pay` WHERE accaunt = '$accaunt'");
while ($row1=mysql_fetch_array($money))
{
$pay_money = $row1['sum'];
$pay_money_sum = $pay_money_sum + $pay_money;
}
$pay_col = array('');
$pay_sum = 0;
$rect_header = mysql_query("SELECT * FROM `rect_header` WHERE accaunt = '$accaunt'");
while ($row1=mysql_fetch_array($rect_header))
{
$idrect = $row1['idrect'];
$col = 0;
$name_col = array('');
if ($pay_sum>0 AND $pay_sum<$pay_money_sum)
{
$pay_money_sum = $pay_money_sum - $pay_sum;
$pay_sum = 0;
$pay_col = array('');
$month = $month_arry["$row1[month]"];
$year = $row1['year'];
$dateprev = "$month $year";
}
else
{
$month = $month_arry["$row1[month]"];
$year = $row1['year'];
$datesub = "$month $year";
}
$rect_body = mysql_query("SELECT * FROM `rect_body` WHERE rect_header_idrect = '$idrect'");
while ($row2=mysql_fetch_array($rect_body))
{
$pay = $row2['sum']; //присваиваем переменные
$pay_sum = $pay_sum + $pay;
$col =$col + 1;
if (!$pay_col[$col])
array_push($pay_col,$row2['sum']);
else
$pay_col[$col] = $pay_col[$col] + $row2['sum'];
array_push($name_col,$row2['name_services']);
$name_col[$col] = strToHexByRtf($name_col[$col]);
}
for ($col1=1; $col1<8; $col1++)
{
if ($pay_col[$col1])
$pay_col[$col1] = round($pay_col[$col1]*($pay_sum - $pay_money_sum)/$pay_sum,2);
}
}
$pay_sum = $pay_sum - $pay_money_sum;
$sumdeal = round($pay_sum * 0.9,2);
$sity = strToHexByRtf($city); //
$FIO = strToHexByRtf($FIO); //
$name_UK = strToHexByRtf($name_UK); //
$street = strToHexByRtf($street); //
$num_room = strToHexByRtf($num_room);//
$sData = file_get_contents('rtf/notcess.rtf');
$sData = str_replace('NAMEUSER', $FIO, $sData);
$sData = str_replace('SITY', $sity, $sData);
$sData = str_replace('DATECESS', date('d.m.Y'), $sData);
$sData = str_replace('NAMEUK', $name_UK, $sData);
$sData = str_replace('NUMST', $numst, $sData);
$sData = str_replace('STREET', $street, $sData);
$sData = str_replace('NUMAP', $num_room, $sData);
$sData = str_replace('SUMM', $pay_sum, $sData);
$sData = str_replace('NUMHO', $case, $sData);
file_put_contents("rtf/notcess_$accaunt.rtf", $sData);
}
?>
















