echo "পাওনা তারিখ : {$date} <br>";
$cPaid = 0;
$cOwe = $factoryEntry["amount"];
foreach ($checkLogs as $checkLog) {
// $dateObj = $factoryEntry;
// $amount = $factoryEntry["amount"];
$timestamp = $checkLog["date"];
$timestampArr = explode(' ', $timestamp);
$dateObj = $timestampArr[0];
$dateData = explode('-', $dateObj);
//print_r($dateData);
$date = "{$dateData['2']} / {$dateData['1']} / {$dateData['0']}";
$cPaid = $cPaid + $checkLog["paid"];
echo "তারিখ :{$date}; জমা:{$checkLog['paid']}<br>";
}
$datePending = parseDateFromTime($factoryEntry["pending_date"]);
echo "মোট পাওনা : {$cOwe} <br>";
echo "পাওনা তারিখ : {$datePending} <br>";
echo "পরিশধিত: {$cPaid} <br>";
$checkDue = $cOwe - $cPaid;
echo "বাকি: {$checkDue} <br>";
if ($checkDue == 0) {
db("update company_check set payment_clear ='yes' where table_index = '{$index}' ");
}
}
}
} else {
echo $msg;
}
}
function parseDateFromTime($timestamp)
<th>পরিশোধিত</th>
</tr>
<?php
$rows = dbEach("select * from company_check where (pending_date between '{$todayStart}' and '{$todayEnd}') order by pending_date asc");
foreach ($rows as $row) {
$date = parseDateFromTime($row["pending_date"]);
$issueDate = parseDateFromTime($row["issue_date"]);
echo "<tr>\n <td>{$issueDate}</td>\n <td>{$date}</td>\n <td><a href=\"check_paid.php?factoryName={$row['factory_name']}\">{$row['factory_name']}</a></td>\n <td>{$row['amount']}</td>\n <td>{$row['payment_clear']}</td>\n </tr>";
}
echo "-----------------";
?>
</table>
<table class="table table-condensed table-striped table-bordered table-hover">
<tr>
<th>ইস্যু তারিখ</th>
<th>তারিখ</th>
<th>কারখানা</th>
<th>মোট পরিমান</th>
<th>পরিশোধিত</th>
</tr>
<?php
$upcomingRows = dbEach("select * from company_check where pending_date > '{$todayEnd}' order by pending_date asc");
foreach ($upcomingRows as $row) {
$date = parseDateFromTime($row["pending_date"]);
$issueDate = parseDateFromTime($row["issue_date"]);
echo "<tr>\n <td>{$issueDate}</td>\n <td>{$date}</td>\n <td><a href=\"check_paid.php?factoryName={$row['factory_name']}\">{$row['factory_name']}</a></td>\n <td>{$row['amount']}</td>\n <td>{$row['payment_clear']}</td>\n </tr>";
}
?>
</table>
<?php
include "bikri_khata_end.php";
<th>মোট পরিমান</th>
<th>পরিশোধিত</th>
</tr>
<?php
$rows = dbEach("select * from company_check where (pending_date between '{$todayStart}' and '{$todayEnd}') order by pending_date asc");
foreach ($rows as $row) {
$date = parseDateFromTime($row["pending_date"]);
echo "<tr>\n <td>{$date}</td>\n <td><a href=\"check_paid.php?factoryName={$row['factory_name']}\">{$row['factory_name']}</a></td>\n <td>{$row['amount']}</td>\n <td>{$row['payment_clear']}</td>\n </tr>";
}
?>
</table>
<?php
echo "-----------------";
?>
<table class="table table-condensed table-striped table-bordered table-hover">
<tr>
<th>তারিখ</th>
<th>কারখানা</th>
<th>মোট পরিমান</th>
<th>পরিশোধিত</th>
</tr>
<?php
$upcomingRows = dbEach("select * from company_check where pending_date > '{$todayEnd}' order by pending_date asc");
foreach ($upcomingRows as $row) {
$date = parseDateFromTime($row["pending_date"]);
echo "<tr>\n <td>{$date}</td>\n <td><a href=\"check_paid.php?factoryName={$row['factory_name']}\">{$row['factory_name']}</a></td>\n <td>{$row['amount']}</td>\n <td>{$row['payment_clear']}</td>\n </tr>";
}
?>
</table>
<?php
include "bikri_khata_end.php";
