";
$query = "select
id,
data_create,
manager,
count,
firma,
address,
color,
resume,
tema,
vproject,
service
FROM resume where id='$work';";
$result = mysql_query($query, $link);
while ($row = mysql_fetch_array($result)){
$y_hdata = substr($row['data_create'], 0, 4);
$m_hdata = substr($row['data_create'], 4, 2);
$d_hdata = substr($row['data_create'], 6, 2);
if($m_hdata == "01"){
$mon_hdata = 'января';
}
if($m_hdata == "02"){
$mon_hdata = 'февраля';
}
if($m_hdata == "03"){
$mon_hdata = 'марта';
}
if($m_hdata == "04"){
$mon_hdata = 'апреля';
}
if($m_hdata == "05"){
$mon_hdata = 'мая';
}
if($m_hdata == "06"){
$mon_hdata = 'июня';
}
if($m_hdata == "07"){
$mon_hdata = 'июля';
}
if($m_hdata == "08"){
$mon_hdata = 'августа';
}
if($m_hdata == "09"){
$mon_hdata = 'сентября';
}
if($m_hdata == "10"){
$mon_hdata = 'октября';
}
if($m_hdata == "11"){
$mon_hdata = 'ноября';
}
if($m_hdata == "12"){
$mon_hdata = 'декабря';
}
$hdate = "$d_hdata $mon_hdata $y_hdata г.";
echo "
|
|
";
}
}
echo "
|
Платеж
|
План. сумма
|
План. дата
|
Факт. сумма
|
Факт. дата
|
Сумма мат.
|
Работы
|
Срок
|
Редактировать
|
";
$query = "select
id,
id_counter,
platej_name,
plan_sum,
plan_date,
fact_sum,
fact_date,
mat_sum,
work_sum,
srok,
collapse,
manager
FROM counter where id='$work' order by data_create asc;";
$result = mysql_query($query, $link);
$string = '';
while ($row = mysql_fetch_array($result)){
echo "
|
|
|
";
if (($row['fact_sum'] === '0.00') and ($now >= $row['plan_date']))
{
echo "
|
";
} else {
echo "
|
|
";
}
$y_p = substr($row['plan_date'], 0, 4);
$m_p = substr($row['plan_date'], 4, 2);
$d_p = substr($row['plan_date'], 6, 2);
echo "
$y_p.$m_p.$d_p
|
|
|
|
";
$y_f = substr($row['fact_date'], 0, 4);
$m_f = substr($row['fact_date'], 4, 2);
$d_f = substr($row['fact_date'], 6, 2);
echo "
$y_f.$m_f.$d_f
|
|
|
";
if (($row['fact_sum'] !== '0.00') and ($row['mat_sum'] !== '0.00'))
{
$fact_work = $row['fact_sum'] - $row['mat_sum'];
echo "
|
";
} else {
echo "
|
";
}
$fact_date = strtotime("".$row['collapse']."");
$date_now = strtotime("now");
$date_result = ($date_now - $fact_date) / 86400;
$dt = $date_result;
list($date_result) = explode(".", $dt);
$srok = "".$row['srok']."";
$date_collapse = $srok - $date_result;
$y_c = substr($row['collapse'], 0, 4);
$m_c = substr($row['collapse'], 4, 2);
$d_c = substr($row['collapse'], 6, 2);
if ($date_collapse <= '-1')
{
echo"
|
$y_c.$m_c.$d_c [".$row['srok']."]
|
|
$date_collapse
|
|
";
} else {
echo"
|
$y_c.$m_c.$d_c [".$row['srok']."]
|
|
$date_collapse
|
|
";
}
echo "
|
";
if(($data['ch_work'] === 'Y') or ($data['adm'] === 'Y'))
{
echo "
редакт.
";
}
echo "
|
|
";
$strng .= $row['platej_name']."\t".$row['plan_sum']."\t".$y_p." ".$m_p." ".$d_p."\t".$row['fact_sum']."\t".$y_f." ".$m_f." ".$d_f."\t".$row['mat_sum']."\t".$row['work_sum']."\t".$y_s." ".$m_s." ".$d_s."\n";
}
$f=fopen("/home/dracula/tt/buh.xls", "a+");
fwrite($f,$strng);
fclose($f);
$head2 = "\n"."\t"."План. сумма общ."."\t"."\t"."Факт. сумма общ."."\t"."\t"."\t"."\t"."Долг"."\n";
$f=fopen("/home/dracula/tt/buh.xls", "a+");
fwrite($f,$head2);
fclose($f);
echo "
|
|
План. сумма общ.
|
|
Факт. сумма общ.
|
|
|
|
|
Долг
|
";
$query = "
select
sum(plan_sum) as sum_plan_sum,
sum(fact_sum) as sum_fact_sum
from counter where id='$work';";
$result = mysql_query($query, $link);
// $string = '';
while ($row = mysql_fetch_array($result)){
echo "
|
|
|
|
|
|
";
$dolg = $row['sum_plan_sum'] - $row['sum_fact_sum'];
//@$sum_plan_sum = $row['sum_plan_sum'];
//@$sum_fact_sum = $row['sum_fact_sum'];
//@$dolg = $dolg;
echo"
|
";
$strng = "\t".$row['sum_plan_sum']."\t"."\t".$row['sum_fact_sum']."\t"."\t"."\t"."\t".$dolg."\n";
}
$f=fopen("/home/dracula/tt/buh.xls", "a+");
fwrite($f,$strng);
fclose($f);
/*
$query = "delete from sum";
$result = mysql_query($query, $link);
$query = "insert into sum
(
sum_plan_sum,
sum_fact_sum,
dolg
) values (
'$sum_plan_sum',
'$sum_fact_sum',
'$dolg'
); ";
$result = mysql_query($query, $link);
*/
echo "
|
|
Запись платежа
|
Поиск
|
Поиск общий
|
";
if ($data['cr_payment'] === 'Y')
{
echo "
";
}
echo "
";
if ($data['sh_work'] === 'Y')
{
include('calendar_fin.php');
}
echo "
|
";
unset($dolg);
unset($row['sum_plan_sum']);
unset($row['sum_fact_sum']);
}
?> |