<?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