query($sqlStmt);
if (DB::isError($result)) die ("$PHP_SELF: " . $result->getMessage());
$stkIdArray = array();
$stkAdIdArray = array();
$stkHsnoArray = array();
while ($row = $result->fetch_assoc()):
if ($row["ad_id"] != "0") :
$stkIdArray[] = $row["stk_id"];
$stkAddressArray[] = $row["ad_id"] . "-" . $row["stk_hsno"];
endif;
endwhile;
$result->free();
$stkIdArrayLen = count($stkIdArray);
// Initialize date-ranges to the current date
// $fromDateRange = getDateTime("3") . " 00:00:00";
$fromDateRange = getDateTime("date_plus_offset", array(0,-3,0), "Y-m-d") . " 00:00:00";
$toDateRange = getDateTime("3") . " 23:59:59";
if (count($stkAddressArray) > 0) :
$jobListOut = getStockJobs("jb.jb_ordertime >= '" . $fromDateRange . "' AND jb.jb_ordertime <= '" . $toDateRange . "' AND CONCAT(ad.ad_id,'-',tr.tr_hsno) IN ('" . implode("','", $stkAddressArray) . "')", $f_sort);
endif;
endif;
?>
<?php echo $pageTitel ?>