public function fromDateToDate($start_date, $stop_date, $week_day = array())
{
$mysql = new mysql_class();
$days = array(1 => "دوشنبه", 2 => "سهشنبه", 3 => "چهارشنبه", 4 => "پنجشنبه", 5 => "جمعه", 6 => "شنبه", 7 => "یکشنبه");
if (strtotime($stop_date) >= strtotime($start_date)) {
$tmp = $start_date;
while (strtotime($stop_date) >= strtotime($tmp)) {
$ok = FALSE;
$this_day = strtotime($tmp);
$dayOfW = date("N", $this_day);
for ($i = 0; $i < count($week_day); $i++) {
if ($dayOfW == $week_day[$i]) {
$ok = TRUE;
}
}
if ($ok) {
$mysql->ex_sql("select `id` from `parvaz_det` where `parvaz_id` = '" . $this->id . "' and `tarikh`='{$tmp}' and `saat`='" . $this->saat_def . "' and `en`='1' ", $q);
if (!isset($q[0])) {
$mysql->ex_sqlx("insert into `parvaz_det` (`parvaz_id`, `tarikh`, `saat`,`saat_kh`, `zarfiat`, `ghimat`, `typ`, `zakhire`, `poor_def`,`mablagh_kharid`,`customer_id`) values ('" . $this->id . "','{$tmp}','" . $this->saat_def . "','" . $this->saat_kh_def . "','" . $this->zarfiat_def . "','" . $this->ghimat_def . "','" . $this->typ_def . "','" . $this->zarfiat_def . "','" . $this->poor_def . "','" . $this->mablgh_kharid_def . "','" . $this->customer_id_det . "')");
if ($this->is_shenavar) {
$mysql->ex_sql("SELECT `id` FROM `parvaz_det` WHERE `parvaz_id`='" . $this->id . "' and `tarikh`='{$tmp}' and `saat`='" . $this->saat_def . "' and `saat_kh`='" . $this->saat_kh_def . "' and `zarfiat`='" . $this->zarfiat_def . "' and `ghimat`='" . $this->ghimat_def . "' and `typ`='" . $this->typ_def . "' and `zakhire`='" . $this->zarfiat_def . "' and `poor_def`='" . $this->poor_def . "' and `mablagh_kharid`='" . $this->mablgh_kharid_def . "' and `customer_id`='" . $this->customer_id_det . "'", $qu);
if (isset($qu)) {
$r = $qu[0];
$parvaz_det = new parvaz_det_class($r['id']);
$parvaz_det->kharidParvaz($this->zarfiat_def);
}
}
}
}
$tmp = strtotime($tmp . " + 1 day");
$tmp = date("Y-m-d", $tmp);
}
}
}
}
function hamed_pdate($str)
{
$out = jdate('Y/n/j', strtotime($str));
return enToPerNums($out);
}
$parvaz_det_id = isset($_REQUEST["parvaz_det_id"]) ? (int) $_REQUEST["parvaz_det_id"] : -1;
$parvaz = new parvaz_det_class($parvaz_det_id);
$par = new parvaz_class($parvaz->parvaz_id);
$zarfiat = isset($_REQUEST["zarfiat"]) ? (int) $_REQUEST["zarfiat"] : $parvaz->zarfiat;
$out = '';
if (isset($_REQUEST["zarfiat"])) {
$mysql = new mysql_class();
//die($parvaz->zarfiat." ".$parvaz->getZarfiat().' '.$zarfiat);
if ($zarfiat > $parvaz->zarfiat) {
$parvaz->kharidParvaz($zarfiat - $parvaz->zarfiat);
} else {
if ($zarfiat < $parvaz->zarfiat) {
$parvaz->mablagh_kharid = -1 * $parvaz->mablagh_kharid;
$parvaz->kharidParvaz($zarfiat < $parvaz->zarfiat);
}
}
if ($parvaz->zarfiat - $parvaz->getZarfiat() <= $zarfiat) {
$out = $mysql->ex_sqlx("update `parvaz_det` set `zarfiat` = {$zarfiat} where `id` = {$parvaz_det_id}");
$arg["toz"] = ' تغییر ظرفیت پرواز شماره ' . $parvaz->shomare . ' تاریخ ' . jdate("d / m / Y", strtotime($parvaz->tarikh)) . ' از مقدار ' . $parvaz->zarfiat . ' به مقدار ' . $zarfiat;
$arg["user_id"] = $_SESSION[$conf->app . "_user_id"];
$arg["host"] = $_SERVER["REMOTE_ADDR"];
$arg["page_address"] = $_SERVER["SCRIPT_NAME"];
$arg["typ"] = 1;
log_class::add($arg);
} else {
$par_zakh = loadCustomerZakhire($p_id);
$par_no = $rec_res[0]['typ'] != '' ? $rec_res[0]['typ'] : 0;
}
$com_typ = "<select class='parav' id='typ' ><option value='-1'></option>";
$com_typ .= "<option value='0' " . ($par_no == 0 ? "selected='selected'" : '') . " >عمومی</option>";
$com_typ .= "<option value='1' " . ($par_no == 1 ? "selected='selected'" : '') . " >خصوصی</option>";
$com_typ .= "</select>";
} else {
$parvaz_det_id = -1;
}
if (isset($_REQUEST['mablagh_kharid'])) {
$mablagh_kharid = $_REQUEST['mablagh_kharid'];
$lastvalue = $parvaz_det->mablagh_kharid;
if ($lastvalue != $mablagh_kharid) {
$parvaz_det->mablagh_kharid = $mablagh_kharid - $lastvalue;
$parvaz_det->kharidParvaz($parvaz_det->zarfiat, 'بابت تغییر قیمت خرید پرواز از ' . $lastvalue . ' به ' . $mablagh_kharid);
}
$customer_id = (int) $_REQUEST['customer_id'];
if ($parvaz_det->customer_id != $customer_id) {
$par = $parvaz_det;
$par->mablagh_kharid = -1 * $par->mablagh_kharid;
$cust1 = new customer_class($par->customer_id);
$cust1 = $par->customer_id > 0 ? $cust1->name : 'مدیریت';
$cust2 = new customer_class($customer_id);
$cust2 = $customer_id > 0 ? $cust2->name : 'مدیریت';
$par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2);
$par->mablagh_kharid = -1 * $par->mablagh_kharid;
$par->customer_id = $customer_id;
$par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2);
}
$can_esterdad = $_REQUEST['can_esterdad'];
function edit_item($id, $field, $value)
{
$lastvalue = "";
$mysql = new mysql_class();
$mysql->ex_sql("select `{$field}` from `parvaz_det` where `id`='{$id}'", $q);
if (isset($q[0])) {
$lastvalue = $q[0][$field];
}
$arg["toz"] = "اصلاح فیلد {$field} از id {$id} به مقدار {$value} از مقدار {$lastvalue}";
$arg["user_id"] = $_SESSION[$conf->app . "_user_id"];
$arg["host"] = $_SERVER["REMOTE_ADDR"];
$arg["page_address"] = $_SERVER["SCRIPT_NAME"];
$arg["typ"] = 2;
log_class::add($arg);
switch ($field) {
case 'mablagh_kharid':
$par = new parvaz_det_class((int) $id);
$par->mablagh_kharid = $value - $lastvalue;
$par->kharidParvaz($par->zarfiat, 'بابت تغییر قیمت خرید پرواز از ' . $lastvalue . ' به ' . $value);
break;
case 'customer_id':
$par = new parvaz_det_class((int) $id);
$par->mablagh_kharid = -1 * $par->mablagh_kharid;
$cust1 = new customer_class($par->customer_id);
$cust1 = $par->customer_id > 0 ? $cust1->name : 'مدیریت';
$cust2 = new customer_class($value);
$cust2 = $value > 0 ? $cust2->name : 'مدیریت';
$par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2);
$par->mablagh_kharid = -1 * $par->mablagh_kharid;
$par->customer_id = $value;
$par->kharidParvaz($par->zarfiat, 'بابت تغییر فروشنده از ' . $cust1 . ' به ' . $cust2);
break;
case 'j_id':
if ($lastvalue == 0 && $value == 1) {
$GLOBALS['extraScript'] = "openjid('{$id}');";
}
break;
}
$mysql->ex_sqlx("update `parvaz_det` set `{$field}`='{$value}' where `id`='{$id}'");
}