<?php
session_start();
require_once 'classes/class.user.php';
$user_home = new USER();
require_once 'DB/dbupdates.php';
$dbupdates = new DBupdates();
if (!$user_home->is_logged_in()) {
$user_home->redirect('index.php');
}
$stmt = $user_home->runQuery("SELECT * FROM users WHERE id=:uid");
$stmt->execute(array(":uid" => $_SESSION['userSession']));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$code = "";
$supname = "";
$supnic = "";
$apptearate = "";
$suppkgs = "";
$totincome = "";
$paid = "";
$remainbalance = "";
$formateddate = date('Y-m-d');
if (isset($_POST['search'])) {
$code = $_POST['code'];
if ($dbupdates->checkSupplierExist($code) == true) {
$supname = $dbupdates->getSupplierName($code);
$supnic = $dbupdates->getMyNIC($code);
$apptearate = $dbupdates->thisMonthTeaRate();
$kgs1 = $dbupdates->getTodayMySupply($code);
$kgs2 = $dbupdates->myTotalSupplyOfaMonth($code, $formateddate);
$pay1 = $dbupdates->thisMonthPayForMe($code);
function myIncomeOf6Months($supcode)
{
//to get total supply for perticular supplier in LAST 6 months
$dbmain = new DBmain();
$formateddate = date("Y-m-d");
$resarr = array();
$curyear = substr($formateddate, 0, 4);
$curmonth = substr($formateddate, 5, 7);
$lstrunningmonth = substr($formateddate, 5, 7);
for ($i = 1; $i < 7; $i++) {
$lstrunningmonth = $curmonth - $i;
$m = $curmonth - $i;
if ($lstrunningmonth == "0") {
$curyear = $curyear - 1;
$m = 12 + ($curmonth - $i);
}
if ($lstrunningmonth < 0) {
$m = 12 + ($curmonth - $i);
}
if (strlen($m) == 1) {
$m = "0" . $m;
}
$startday = $curyear . "-" . $m . "-01";
$enddate = $curyear . "-" . $m . "-31";
$condition = " WHERE supplier_code='" . $supcode . "' AND date BETWEEN '" . $startday . "' AND '" . $enddate . "'";
$res = $dbmain->selectData("daily_supply", array("approved_kgs"), $condition);
$total = 0;
if (count($res) > 0) {
foreach ($res as $r) {
$total = $total + $r['approved_kgs'];
}
$resarr[$i - 1] = $total * DBupdates::teaRateofMonth($startday);
} else {
$resarr[$i - 1] = 0;
}
}
return $resarr;
}
<?php
session_start();
require_once 'classes/class.user.php';
$user_home = new USER();
require_once 'DB/dbupdates.php';
$dbupdates = new DBupdates();
if (!$user_home->is_logged_in()) {
$user_home->redirect('index.php');
}
$stmt = $user_home->runQuery("SELECT * FROM users WHERE id=:uid");
$stmt->execute(array(":uid" => $_SESSION['userSession']));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html>
<title>Daily Update</title>
<?php
include "include/head.php";
?>
<script type="text/javascript" src="plugins/alert/dist/jquery-1.11.3.min.js"></script>
<script type="text/javascript" src="plugins/alert/dist/sweetalert.min.js"></script>
<script type="text/javascript" src="plugins/alert/dist/sweetalert-dev.js"></script>
<script type="text/javascript">
// $(function(){
// swal("Sweet Alert hureeeeee!");
// });
</script>
<?php
