function getTodayTotalSupply() { $dbmain = new DBmain(); $res = $dbmain->selectData("today_supply", array("approved_kgs"), " "); $total = 0; if (count($res) > 0) { foreach ($res as $r) { $total = $total + $r['approved_kgs']; } return $total; } }
function getBasicSupData($supcode) { $dbmain = new DBmain(); $condition = "WHERE supplier_code='" . $supcode . "'"; $res = $dbmain->selectData("suppliers", array("f_name", "l_name", "address_1", "address_2", "address_3", "nic_no"), $condition); if (count($res) == 1) { foreach ($res as $r) { //print_r($r); return $r; } } }
function factoryTotalSupplyOf12Months() { $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 < 13; $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 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; } else { $resarr[$i - 1] = 0; } } return $resarr; }
function approxTeaRatesOfLast6Months() { $dbmain = new DBmain(); $formateddate = date("Y-m-d"); $resarr = array(); $curyear = substr($formateddate, 0, 4); $curmonth = substr($formateddate, 5, 7); $curmonth = $curmonth * 1 + 1; $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 date BETWEEN '" . $startday . "' AND '" . $enddate . "'"; $res = $dbmain->selectData("settings", array("approxi_tea_rate"), $condition); $total = 0; if (count($res) > 0) { foreach ($res as $r) { $total = $total + $r['approxi_tea_rate']; } $resarr[$i - 1] = $total; } else { $resarr[$i - 1] = 0; } } return $resarr; }
function teaRateofMonth($formateddate) { $dbmain = new DBmain(); $startday = substr($formateddate, 0, 7) . "-01"; $enddate = substr($formateddate, 0, 7) . "-31"; $condition = " WHERE date BETWEEN '" . $startday . "' AND '" . $enddate . "'"; $res = $dbmain->selectData("settings", array("approxi_tea_rate", "fixed_tea_rate"), $condition); if (count($res) == 1) { foreach ($res as $r) { $approx = $r['approxi_tea_rate']; $real = $r['fixed_tea_rate']; if ($real != NULL || $real != 0) { return $real; } else { return $approx; } } } elseif (count($res) > 1) { $approx = ""; $real = ""; foreach ($res as $r) { $approx = $r['approxi_tea_rate']; $real = $r['fixed_tea_rate']; } return $real; } else { return 0; } }