<script type="text/javascript" src="../js/calendar.js"></script>
<script type="text/javascript" src="../js/calendar-setup.js"></script>
<script type="text/javascript" src="../js/lang/calendar-fa.js"></script>
<title>
سامانه مدیریت آژانس مسافرتی
</title>
</head>
<body>
<div align="center">
<br/>
<form id="filter" method="get">
انتخاب حساب :
<select id="customer_id" name="customer_id" class="inp1" style="width:auto;">
<?php
if ($typ == 2 && $_SESSION[conf::app . "_typ"] == 0) {
echo $grid->columnListToCombo(loadCustomers());
} else {
echo $grid->columnListToCombo(array($customer->name => $customer_id), $customer_id);
}
?>
<?php
if ($typ == 2 && $_SESSION[conf::app . "_typ"] == 0) {
?>
<option value="-2"<?php
echo $customer_id == -2 ? " selected=\"selected\"" : "";
?>
>
همه
</option>
<?php
}
$grid->columnHeaders[0] = null;
$grid->columnHeaders[1] = null;
$grid->columnHeaders[2] = null;
$grid->columnHeaders[3] = null;
$grid->columnHeaders[4] = null;
$grid->columnHeaders[5] = null;
$grid->columnHeaders[6] = null;
$grid->columnHeaders[7] = "فروشنده";
$grid->columnHeaders[8] = null;
$grid->columnHeaders[9] = null;
$grid->columnHeaders[10] = null;
$grid->columnHeaders[11] = null;
$grid->columnHeaders[12] = null;
$grid->columnHeaders[13] = "مبلغ";
$grid->columnHeaders[14] = null;
$grid->columnLists[7] = loadCustomers($moshtari);
/* $grid->columnFunctions[5] = "loadTozihat";
$grid->columnFunctions[8] = "loadBed";
$grid->columnFunctions[9] = "loadBes";
$grid->columnFunctions[10] = "loadMande";
$grid->columnFunctions[4] = "hamed_pdate";
$grid->columnCallBackFunctions[4] = "hamed_pdateBack";
$grid->columnAccesses[1] = 0;
$grid->whereClause = " `typ`<>0 and `tarikh` >= '$saztarikh 00:00:00' and `tarikh` <='$statarikh 23:59:59'";
*/
$grid->footer = "<td class=\"showgrid_row_odd\"></td><td class=\"showgrid_row_odd\" align='left' ></td><td class=\"showgrid_row_odd\" id='jam_mablagh' align='center'>جمع:</td><td class=\"showgrid_row_odd\" id='jam_m' align='center' ></td><td id=\"jam_p\" align=\"center\" class=\"showgrid_row_odd\"></td>";
$grid->canAdd = FALSE;
$grid->canEdit = FALSE;
$grid->canDelete = FALSE;
$grid->intial();
$grid->executeQuery();
$grid->columnHeaders[1] = "مشتری(آژانس)";
//$grid->columnFilters[1] = TRUE;
$grid->columnHeaders[2] = null;
$grid->columnHeaders[3] = "مبلغ";
$grid->columnHeaders[4] = "تاریخ";
$grid->columnHeaders[5] = "توضیحات";
$grid->columnHeaders[6] = 'شماره سند';
$grid->columnHeaders[7] = null;
$grid->columnHeaders[8] = null;
$grid->columnAccesses[4] = 0;
$grid->columnAccesses[6] = 0;
$grid->columnJavaScript[3] = " onkeyup=\"monize(this);\" ";
$grid->addFeild('id', 9);
$grid->columnHeaders[9] = "وضعیت پرداختی";
$grid->columnFunctions[9] = "loadVaziat";
$grid->columnLists[1] = loadCustomers($customer_id);
$grid->columnFunctions[3] = "monize";
$grid->columnFunctions[4] = "hamed_pdate";
$grid->columnCallBackFunctions[4] = "hamed_pdateBack";
$grid->columnAccesses[1] = 0;
$grid->columnFunctions[5] = "loadTozihat";
$grid->columnAccesses[5] = 0;
$grid->addFeild('id', 6);
$grid->columnHeaders[6] = "استردادی";
$grid->columnFunctions[6] = "loadEster";
$grid->addFunction = "add_item";
$grid->deleteFunction = "delete_item";
// $grid->editFunction = "edit_item";
$ww = " `typ`<>-1 ";
if (isset($_REQUEST["customer_id"]) || (int) $_SESSION[conf::app . "_customer_typ"] != 2) {
$ww .= " and `customer_id` = {$customer_id} ";
}
$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] = "مشتری";
$grid->columnLists[0] = loadCustomers();
$grid->columnHeaders[2] = "بستانکار";
$grid->columnHeaders[1] = "بدهکار";
$grid->columnHeaders[3] = "مانده";
$grid->columnFunctions[2] = "loadBestankar";
$grid->columnFunctions[1] = "loadBedehkar";
$grid->columnFunctions[3] = "loadMandeh";
/*
$grid->footer="<td colspan='3' class=\"showgrid_row_odd\" align='left' >جمع:</td><td class=\"showgrid_row_odd\" id='jam_bed1' align='center' ></td><td class=\"showgrid_row_odd\" id='jam_bes1' align='center' ></td><td id=\"tafazol\" align=\"center\" class=\"showgrid_row_odd\"></td>";
*/
break;
}
$grid->canAdd = FALSE;
$grid->canEdit = FALSE;
$grid->canDelete = FALSE;
$grid->intial();
if (!isset($_REQUEST["customer_id"])) {
$customer_id = (int) $_SESSION[$conf->app . "_customer_id"];
$typ = 0;
}
if (isset($_REQUEST["changetyp"])) {
$changetyp = (int) $_REQUEST["changetyp"];
$typ = (int) $_REQUEST["typ"];
$mysql->ex_sqlx("update `customer_daryaft` set `typ`={$typ} where `id` ={$changetyp}");
}
$GLOBALS["typ"] = $typ;
$gname = 'grid_customer_daryaft';
$input = array($gname => array('table' => 'customer_daryaft', 'div' => 'main_div_customer_daryaft'));
$xgrid = new xgrid($input);
$xgrid->column[$gname][0]['name'] = '';
$xgrid->column[$gname][1]['name'] = 'مشتری(آژانس)';
$xgrid->column[$gname][1]['clist'] = loadCustomers($customer_id);
$xgrid->column[$gname][1]['access'] = 'a';
$xgrid->column[$gname][2]['name'] = '';
$xgrid->column[$gname][3]['name'] = 'مبلغ';
$xgrid->column[$gname][3]['cfunction'] = array('monize');
$xgrid->column[$gname][4]['name'] = 'تاریخ';
$xgrid->column[$gname][4]['cfunction'] = array('hamed_pdate', 'hamed_pdateBack');
$xgrid->column[$gname][4]['access'] = 'a';
$xgrid->column[$gname][5]['name'] = 'توضیحات';
$xgrid->column[$gname][5]['cfunction'] = array('loadTozihat');
$xgrid->column[$gname][5]['access'] = 'a';
$xgrid->column[$gname][6]['name'] = 'شماره سند';
$xgrid->column[$gname][6]['access'] = 'a';
$xgrid->column[$gname][7]['name'] = 'مبلغ';
$xgrid->column[$gname][8]['name'] = '';
$xgrid->column[$gname][] = array('name' => 'وضعیت پرداختی', 'fieldname' => 'id', 'css' => '', 'typ' => 'int', 'access' => 'a', 'cfunction' => array('loadVaziat'));
