$grid->columnFunctions[11] = "loadMande";
$grid->columnFunctions[4] = "hamed_pdate";
$grid->columnCallBackFunctions[4] = "hamed_pdateBack";
$grid->columnAccesses[1] = 0;
$grid->whereClause = '1=0';
if (isset($_REQUEST["saztarikh"])) {
$grid->whereClause = " `typ`=-1 and `tarikh` >= '{$saztarikh} 00:00:00' and `tarikh` <='{$statarikh} 23:59:59'";
}
if (isset($_REQUEST["customer_id"]) && (int) $_REQUEST["customer_id"] != -2) {
$grid->whereClause .= " and `customer_id` = '" . (int) $_REQUEST["customer_id"] . "' ";
}
$grid->whereClause .= " order by `tarikh`";
$grid->pageCount = 30;
if ($max_tedad == 1) {
$mysql->ex_sql('select `id` from `customer_daryaft` where' . $grid->whereClause, $tedad);
$grid->pageCount = $mysql->num_rows($tedad);
}
$grid->footer = "<td class=\"showgrid_row_odd\" align=\"left\" colspan=\"7\" >مانده از قبل:</td><td id=\"mande_ghabl\" class=\"showgrid_row_odd\" align=\"center\">" . perToEnNums(loadMandeh($mande_ghabl_value)) . "</td>";
$grid->footer .= "</tr><tr><td class=\"showgrid_row_even\"><input name=\"txttedad\"type=\"hidden\" value=\"1\"/>";
$grid->footer .= "<input class=\"inp1\" type=\"button\" name=\"tedad\" value=\"مشاهده همه\" onclick='document.getElementById(\"set_max_tedad\").value=1;document.getElementById(\"filter\").submit();' /></td><td colspan='4' class=\"showgrid_row_even\" align='left' >جمع:</td><td class=\"showgrid_row_even\" id='jam_bed1' align='center' ></td><td class=\"showgrid_row_even\" id='jam_bes1' align='center' ></td><td id=\"tafazol\" align=\"center\" class=\"showgrid_row_even\" ></td>";
$grid->footer .= "</tr><tr><td class=\"showgrid_row_odd\" align=\"left\" colspan=\"7\" >مانده کل:</td><td id=\"mande_kol\" class=\"showgrid_row_odd\" align=\"center\"></td>";
break;
case 1:
$saztarikh = "{$saztarikh} 00:00:00";
$statarikh = "{$statarikh} 23:59:59";
$grid->query = "SELECT `customer_id` as `cid`,(select -1*SUM(`mablagh`) from `customer_daryaft` where `customer_id` = `cid` and `typ`=-1 and `tarikh` >= '{$saztarikh}' and `tarikh` <= '{$statarikh}' ) as `bede`,(select SUM(`mablagh`) from `customer_daryaft` where `customer_id` = `cid` and `typ`=1 and `tarikh` >= '{$saztarikh}' and `tarikh` <= '{$statarikh}' ) as `best`,SUM(`mablagh`*`typ`) as `mande` FROM `customer_daryaft` where `tarikh` >= '{$saztarikh}' and `tarikh` <= '{$statarikh}' group by `customer_id`";
$grid->loadQueryField = TRUE;
for ($i = 0; $i < count($grid->columnHeaders); $i++) {
$grid->columnHeaders[$i] = null;
}
$grid->columnHeaders[0] = "مشتری";
