private function save_to_DataBase() { //نوشتن آرايه paymnet_items در فايل ob_start(); $pure_pay = 0; //متغيري جهت نگهداري خالص پرداختي reset($this->payment_items); foreach ($this->payment_items as $pay_row) { if ($pay_row['pay_value'] == 0 && $pay_row['get_value'] == 0 && (!empty($pay_row['diff_pay_value']) && $pay_row['diff_pay_value'] == 0) && (!empty($pay_row['diff_get_value']) && $pay_row['diff_get_value'] == 0) && $pay_row['salary_item_type_id'] != SIT_PROFESSOR_RETIRED && $pay_row['salary_item_type_id'] != SIT_STAFF_RETIRED) { continue; } if (empty($pay_row['pay_value'])) { $pay_row['pay_value'] = 0; } if (empty($pay_row['get_value'])) { $pay_row['get_value'] = 0; } if (empty($pay_row['param1'])) { $pay_row['param1'] = 0; } if (empty($pay_row['param2'])) { $pay_row['param2'] = 0; } if (empty($pay_row['param3'])) { $pay_row['param3'] = 0; } if (empty($pay_row['param4'])) { $pay_row['param4'] = 0; } if (empty($pay_row['param5'])) { $pay_row['param5'] = 0; } if (empty($pay_row['param6'])) { $pay_row['param6'] = 0; } if (empty($pay_row['param7'])) { $pay_row['param7'] = 0; } if (empty($pay_row['param8'])) { $pay_row['param8'] = 0; } if (empty($pay_row['param9'])) { $pay_row['param9'] = 0; } if (empty($pay_row['diff_param1'])) { $pay_row['diff_param1'] = 0; } if (empty($pay_row['diff_param2'])) { $pay_row['diff_param2'] = 0; } if (empty($pay_row['diff_param3'])) { $pay_row['diff_param3'] = 0; } if (empty($pay_row['diff_param4'])) { $pay_row['diff_param4'] = 0; } if (empty($pay_row['diff_param5'])) { $pay_row['diff_param5'] = 0; } if (empty($pay_row['diff_param6'])) { $pay_row['diff_param6'] = 0; } if (empty($pay_row['diff_param7'])) { $pay_row['diff_param7'] = 0; } if (empty($pay_row['diff_param8'])) { $pay_row['diff_param8'] = 0; } if (empty($pay_row['diff_param9'])) { $pay_row['diff_param9'] = 0; } if (empty($pay_row['diff_get_value'])) { $pay_row['diff_get_value'] = 0; } if (empty($pay_row['diff_pay_value'])) { $pay_row['diff_pay_value'] = 0; } if (!isset($pay_row['diff_value_coef'])) { $pay_row['diff_value_coef'] = 1; } echo '(' . $pay_row['diff_get_value'] . ',' . $pay_row['diff_pay_value'] . ',' . $pay_row['pay_year'] . ',' . $pay_row['pay_month'] . ',' . $pay_row['staff_id'] . ',' . $pay_row['salary_item_type_id'] . ',' . $pay_row['pay_value'] . ',' . $pay_row['get_value'] . ',' . $pay_row['param1'] . ',' . $pay_row['param2'] . ',' . $pay_row['param3'] . ',' . $pay_row['param4'] . ',' . $pay_row['param5'] . ',' . $pay_row['param6'] . ',' . $pay_row['param7'] . ',' . $pay_row['param8'] . ',' . $pay_row['param9'] . ',' . $pay_row['diff_param1'] . ',' . $pay_row['diff_param2'] . ',' . $pay_row['diff_param3'] . ',' . $pay_row['diff_param4'] . ',' . $pay_row['diff_param5'] . ',' . $pay_row['diff_param6'] . ',' . $pay_row['diff_param7'] . ',' . $pay_row['diff_param8'] . ',' . $pay_row['diff_param9'] . ',' . $pay_row['cost_center_id'] . ',' . $pay_row['payment_type'] . ',' . $pay_row['diff_value_coef'] . '),'; echo chr(10); $pure_pay += $pay_row['pay_value'] + $pay_row['diff_pay_value'] * $pay_row['diff_value_coef'] - $pay_row['get_value'] - $pay_row['diff_get_value'] * $pay_row['diff_value_coef']; } /*خطا : حقوق فرد منفي شده است لذا ساير قسمتها براي او انجام نمي شود*/ if ($pure_pay < 0 && !$this->backpay) { // ماه آخر بود if (!$this->__CALC_NEGATIVE_FICHE) { $this->log('FAIL', 'حقوق اين شخص به مبلغ ' . CurrencyModulesclass::toCurrency($pure_pay * -1, 'CURRENCY') . ' منفي شده است.'); ob_clean(); return; } else { $this->log('FAIL', 'حقوق اين شخص به مبلغ ' . CurrencyModulesclass::toCurrency($pure_pay * -1, 'CURRENCY') . ' منفي شده است.(فيش اين فرد از بخش چاپ فيش در دسترس است، لطفا پس از انجام كنترلهاي لازم فيشهاي منفي را ابطال كنيد)'); } } $file_line = str_replace(',,', ',\\N,', ob_get_clean()); //براي اصلاح مقادير null $file_line = str_replace(',,', ',\\N,', $file_line); //براي اصلاح مقادير null $pdo = parent::getPdoObject(); $pdo->beginTransaction(); //if($this->backpay) //در صورتي که محاسبه backpay صورت مي گيرد نيازي به نوشتن ساير فايلها نيست // return ; if (!$this->backpay) { //نوشتن آرايه staff_writs در فايل payment_writs reset($this->staff_writs); //$writ_row = ''; foreach ($this->staff_writs[$this->cur_staff_id] as $writ) { parent::runquery(" insert into hrmstotal.payment_writs (writ_id,writ_ver,staff_id,pay_year,pay_month,payment_type) values \n\t\t\t\t\t\t\t(" . $writ['writ_id'] . "," . $writ['writ_ver'] . "," . $this->cur_staff_id . "," . $this->__YEAR . "," . $this->last_month . "," . NORMAL . ")", array(), $pdo); /* echo parent::GetLatestQueryString() ; die();*/ if (parent::AffectedRows() == 0) { $this->log('FAIL', 'خطا در افزودن اطلاعات به جدول احکام مورد استفاده در ماه جاری '); $pdo->rollBack(); ob_clean(); return; } /*$writ_row .= $writ['writ_id'] . ',' . $writ['writ_ver'] . ',' . $this->cur_staff_id . ',' . $this->__YEAR . ',' . $this->last_month . ',' . NORMAL . ',' . $this->__MSG.chr(10);*/ } //fwrite($this->payment_writs_file_h,$writ_row); //نوشتن payment در فايل $payment_row = $this->cur_staff_id . ',' . $this->__YEAR . ',' . $this->__MONTH . ',' . $writ['writ_id'] . ',' . $writ['writ_ver'] . ",'" . $this->month_start . "','" . $this->month_end . "'," . NORMAL . ',' . $this->__MSG . ',' . $this->staffRow['bank_id'] . ',' . $this->staffRow['account_no'] . ',' . PAYMENT_STATE_NORMAL . ",'" . DateModules::NowDateTime() . "'"; $file_line2 = str_replace(',,', ',\\N,', $payment_row); //براي اصلاح مقادير null $file_line2 = str_replace(',,', ',\\N,', $file_line2); //براي اصلاح مقادير null parent::runquery(" insert into payments (staff_id,pay_year,pay_month,writ_id,writ_ver,start_date,end_date,payment_type,message,\n\t\t\t\t\t\t bank_id,account_no,state ,calc_date ) value (" . $file_line2 . ") ", array(), $pdo); //echo parent::GetLatestQueryString() ; die(); if (parent::AffectedRows() == 0) { $this->log('FAIL', 'خطا در افزودن اطلاعات به جدول پرداختها '); $pdo->rollBack(); ob_clean(); return; } } //fwrite($this->payment_file_h,$file_line); //if($this->backpay) // $tblName = "back_payment_items" ; //else $tblName = "corrective_payment_items"; $file_line = substr($file_line, 0, strlen($file_line) - 2); parent::runquery("insert into " . $tblName . " (diff_get_value, diff_pay_value, pay_year, pay_month, staff_id,\n salary_item_type_id, pay_value, get_value, param1, param2, param3,param4, param5, param6, param7, param8, param9,\n diff_param1,diff_param2,diff_param3,diff_param4,diff_param5,diff_param6,diff_param7,diff_param8,diff_param9,\n cost_center_id, payment_type, diff_value_coef ) values " . $file_line . " ", array(), $pdo); //echo parent::GetLatestQueryString() ; die() ; if (parent::AffectedRows() == 0) { $this->log('FAIL', 'خطا در افزودن اطلاعات به جدول اقلام حقوقی'); $pdo->rollBack(); ob_clean(); return; } $this->log('SUCCESS', $pure_pay); $pdo->commit(); return true; }
function InsertData() { $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('utf-8'); $data->setRowColOffset(0); $data->read($_FILES["attach"]["tmp_name"]); $FileType = $_POST["FileType"]; $obj = new manage_pay_get_lists(); $MissionObj = new manage_mission_list_items(); $PGIObj = new manage_pay_get_list_items(); $log_obj = new manage_group_pay_get_log(); $success_count = 0; $unsuccess_count = 0; $costId = ""; if ($FileType == EXTRA_WORK_LIST) { for ($i = 1; $i < $data->sheets[0]['numRows']; $i++) { //for ($j = 0; $j < $data->sheets[0]['numCols']; $j++) //$data->sheets[0]['cells'][$i][$j]; if (!isset($data->sheets[0]['cells'][$i][0]) && !isset($data->sheets[0]['cells'][$i][1])) { break; } $query = " select p.pfname , p.plname , s.person_type from staff s inner join persons p on s.personid = p.personid\n\t\t\t\t\twhere staff_id =" . $data->sheets[0]['cells'][$i][1]; $result = PdoDataAccess::runquery($query); if ($costId != $data->sheets[0]['cells'][$i][0]) { $obj->list_id = null; $obj->cost_center_id = $data->sheets[0]['cells'][$i][0]; $obj->list_date = DateModules::Now(); $obj->doc_state = 1; $obj->list_type = EXTRA_WORK_LIST; if ($obj->AddList() === false) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][1], $result[0]["pfname"] . " " . $result[0]["plname"], " کد مرکز هزینه نامعتبر است."); $unsuccess_count++; continue; } $costId = $obj->cost_center_id; } if (count($result) > 0) { $pt = $result[0]["person_type"]; if ($pt == 3) { $salaryItemId = 152; } elseif ($pt == 2) { $salaryItemId = 39; } elseif ($pt == 5) { $salaryItemId = 639; } $PGIObj->staff_id = $data->sheets[0]['cells'][$i][1]; $PGIObj->salary_item_type_id = $salaryItemId; $PGIObj->approved_amount = $data->sheets[0]['cells'][$i][2]; $PGIObj->comments = $data->sheets[0]['cells'][$i][3]; $PGIObj->list_id = $obj->GetLastID("pay_get_lists", "list_id", " list_type = 1 and cost_center_id =" . $obj->cost_center_id); $PGIObj->list_row_no = $PGIObj->GetLastID("pay_get_list_items", "list_row_no", " list_id =" . $PGIObj->list_id) + 1; if ($PGIObj->Add() == false) { $log_obj->make_unsuccess_rows($PGIObj->staff_id); $unsuccess_count++; } } else { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][1], " ", "شماره شناسایی نامعتبر است."); $unsuccess_count++; } } $log_obj->finalize(); $st = preg_replace('/\\r\\n/', "", $log_obj->make_result()); echo "{success:true,data:'" . $st . "'}"; die; } elseif ($FileType == MISSION_LIST) { for ($i = 1; $i < $data->sheets[0]['numRows']; $i++) { //for ($j = 0; $j < $data->sheets[0]['numCols']; $j++) //$data->sheets[0]['cells'][$i][$j]; $query = " select p.pfname , p.plname , s.person_type from staff s inner join persons p on s.personid = p.personid\n\t\t\t\t\twhere staff_id =" . $data->sheets[0]['cells'][$i][1]; $result = PdoDataAccess::runquery($query); if ($costId != $data->sheets[0]['cells'][$i][0]) { $obj->list_id = null; $obj->cost_center_id = $data->sheets[0]['cells'][$i][0]; $obj->list_date = DateModules::Now(); $obj->doc_state = 1; $obj->list_type = MISSION_LIST; if ($obj->AddList() === false) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][1], $result[0]["pfname"] . " " . $result[0]["plname"], " کد مرکز هزینه نامعتبر است."); $unsuccess_count++; continue; } $costId = $obj->cost_center_id; } if (count($result) > 0) { $pt = $result[0]["person_type"]; if ($pt == 1) { $salaryItemId = 42; } elseif ($pt == 2) { $salaryItemId = 43; } elseif ($pt == 3) { $salaryItemId = 10315; } elseif ($pt == 5) { $salaryItemId = 643; } $MissionObj->staff_id = $data->sheets[0]['cells'][$i][1]; $MissionObj->doc_no = $data->sheets[0]['cells'][$i][2]; $MissionObj->doc_date = DateModules::shamsi_to_miladi($data->sheets[0]['cells'][$i][3]); $MissionObj->from_date = DateModules::shamsi_to_miladi($data->sheets[0]['cells'][$i][4]); $MissionObj->to_date = DateModules::shamsi_to_miladi($data->sheets[0]['cells'][$i][5]); $MissionObj->duration = $data->sheets[0]['cells'][$i][6]; $MissionObj->travel_cost = isset($data->sheets[0]['cells'][$i][7]) ? $data->sheets[0]['cells'][$i][7] : ""; $MissionObj->destination = $data->sheets[0]['cells'][$i][8]; $MissionObj->using_facilities = isset($data->sheets[0]['cells'][$i][9]) ? $data->sheets[0]['cells'][$i][9] : ""; // $MissionObj->report_summary = (isset($data->sheets[0]['cells'][$i][11])) ? $data->sheets[0]['cells'][$i][11] : "" ; $MissionObj->comments = isset($data->sheets[0]['cells'][$i][12]) ? $data->sheets[0]['cells'][$i][12] : ""; $MissionObj->region_coef = isset($data->sheets[0]['cells'][$i][10]) ? $data->sheets[0]['cells'][$i][10] : ""; $MissionObj->salary_item_type_id = $salaryItemId; $MissionObj->list_id = $obj->GetLastID("pay_get_lists", "list_id", " list_type = 9 and cost_center_id =" . $obj->cost_center_id); $MissionObj->list_row_no = $MissionObj->GetLastID("mission_list_items", "list_row_no", " list_id =" . $MissionObj->list_id) + 1; if ($MissionObj->Add() == false) { $log_obj->make_unsuccess_rows($MissionObj->staff_id, $result[0]["pfname"] . " " . $result[0]["plname"], "اطلاعات مربوط به این فرد معتبر نمی باشد."); $unsuccess_count++; } } else { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][1], " ", "شماره شناسایی نامعتبر است."); $unsuccess_count++; } } $log_obj->finalize(); $st = preg_replace('/\\r\\n/', "", $log_obj->make_result()); echo "{success:true,data:'" . $st . "'}"; die; } elseif ($FileType == 11) { //.... محاسبه باقیمانده وامها .......... $Arr = preg_split('/[\\/]/', DateModules::shNow()); $LYear = $Arr[0]; $LMonth = $Arr[1]; manage_subtracts::GetRemainder("", "", "", true, $LMonth, $LYear); //...................................... $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $DB = ""; //echo $data->sheets[0]['numRows'].'----' ; die() ; for ($i = 1; $i < $data->sheets[0]['numRows']; $i++) { $subObj = new manage_subtracts(); $subFlowObj = new manage_subtract_flows(); if (!isset($data->sheets[0]['cells'][$i][1])) { $log_obj->make_unsuccess_rows('-', '-', 'ردیف ' . ($i + 1) . ' معتبر نمی باشد.'); $unsuccess_count++; continue; } // آیا این قلم وجود دارد ؟...................................... $qry = " select salary_item_type_id , available_for\n\t\t\t\t\t\t\tfrom salary_item_types where salary_item_type_id=" . $data->sheets[0]['cells'][$i][1]; $resItem = PdoDataAccess::runquery($qry); //.............................................................. if (isset($resItem[0]['salary_item_type_id']) && $resItem[0]['salary_item_type_id'] > 0) { if (empty($data->sheets[0]['cells'][$i][0])) { $log_obj->make_unsuccess_rows('-', $data->sheets[0]['cells'][$i][1], 'لطفا شماره شناسایی ردیف ' . ($i + 1) . ' را وارد نمایید.'); $unsuccess_count++; continue; } // قلم مربوط به وام نبوده است ............................... if ($data->sheets[0]['cells'][$i][2] == 1 && $resItem[0]['available_for'] != 1) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], " قلم مربوط به وام نمی باشد. "); $unsuccess_count++; continue; } if ($data->sheets[0]['cells'][$i][2] == 2 && !($resItem[0]['available_for'] == 4 || $resItem[0]['available_for'] == 5)) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], " قلم مربوط به کسور نمی باشد. "); $unsuccess_count++; continue; } if ($data->sheets[0]['cells'][$i][2] == 1 && !empty($data->sheets[0]['cells'][$i][6]) && $data->sheets[0]['cells'][$i][6] != 0 && !empty($data->sheets[0]['cells'][$i][5]) && $data->sheets[0]['cells'][$i][5] != 0 && $data->sheets[0]['cells'][$i][6] > $data->sheets[0]['cells'][$i][5]) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], 'قسط وام مورد نظر از مبلغ اوليه آن بزرگتر است.'); $unsuccess_count++; continue; } if (!empty($data->sheets[0]['cells'][$i][8]) && DateModules::GetDateFormat($data->sheets[0]['cells'][$i][7]) > DateModules::GetDateFormat($data->sheets[0]['cells'][$i][8])) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], 'تاريخ پايان بايد بزرگتر و يا مساوي تاريخ شروع باشد.'); $unsuccess_count++; continue; } if (empty($data->sheets[0]['cells'][$i][3])) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], 'نوع وام/کسور مشخص نشده است.'); $unsuccess_count++; continue; } if (!empty($data->sheets[0]['cells'][$i][4])) { $qry = "select bank_id from banks where branch_code=" . $data->sheets[0]['cells'][$i][4]; $resbank = PdoDataAccess::runquery($qry); if (count($resbank) == 0) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], 'کد بانک معتبر نمی باشد.'); $unsuccess_count++; continue; } } $qry = " select staff_id,PersonID from staff where staff_id =" . $data->sheets[0]['cells'][$i][0]; $resStaff = PdoDataAccess::runquery($qry); if (count($resStaff) == 0) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], ' شماره شناسایی معتبر نمی باشد.'); $unsuccess_count++; continue; } //.............................................................................. $Arr2 = preg_split('/[\\/]/', DateModules::GetDateFormat($data->sheets[0]['cells'][$i][7])); $sfd = (int) $Arr2[0] . "/" . (int) $Arr2[1] . "/" . (int) $Arr2[2]; if (!empty($data->sheets[0]['cells'][$i][8])) { $Arr3 = preg_split('/[\\/]/', DateModules::GetDateFormat($data->sheets[0]['cells'][$i][8])); $efd = (int) $Arr3[0] . "/" . (int) $Arr3[1] . "/" . (int) $Arr3[2]; } //........................................................................... $Arr = preg_split('/[\\/]/', DateModules::GetDateFormat($data->sheets[0]['cells'][$i][7])); $sdate = $edate = ''; $start_day = ""; $start_month = (int) $Arr[1]; if ($start_month < 7) { $day = 31; } elseif ($start_month < 12) { $day = 30; } elseif ($start_month == 12) { $day = 29; } $sd = (int) $Arr[0] . "/" . (int) $Arr[1] . "/01"; $ed = (int) $Arr[0] . "/" . (int) $Arr[1] . "/" . $day; $sdate = DateModules::shamsi_to_miladi($sd); $edate = DateModules::shamsi_to_miladi($ed); $PID = $resStaff[0]['PersonID']; //ثبت وام یا کسور جدید.................................................. if ($data->sheets[0]['cells'][$i][3] == 1) { $qry = " select subtract_id, remainder, instalment \n\t\t\t\t\t\t\t\t\tfrom person_subtracts \n\t\t\t\t\t\t\t\t\t\twhere salary_item_type_id = " . $data->sheets[0]['cells'][$i][1] . " and\n\t\t\t\t\t\t\t\t\t\t\t PersonID =" . $PID . " AND IsFinished = 0 and \n\t\t\t\t\t\t\t\t\t\t\t start_date <= '" . str_replace("/", "-", $sdate) . "' and \n\t\t\t\t\t\t\t\t\t\t\t ( end_date >= '" . str_replace("/", "-", $edate) . "' OR end_date IS NULL OR end_date = '0000-00-00' ) "; $res = PdoDataAccess::runquery($qry); if (count($res) > 0 && $res[0]['subtract_id'] > 0) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], "-", "این /کسور قبلا در سیستم ثبت گردیده است."); $unsuccess_count++; continue; } //....................................................... $subObj->PersonID = $PID; $subObj->subtract_type = $data->sheets[0]['cells'][$i][2] == 1 ? LOAN : FIX_FRACTION; $subObj->bank_id = !empty($data->sheets[0]['cells'][$i][4]) ? $resbank[0]['bank_id'] : ""; $subObj->first_value = !empty($data->sheets[0]['cells'][$i][5]) ? $data->sheets[0]['cells'][$i][5] : 0; $subObj->instalment = !empty($data->sheets[0]['cells'][$i][6]) ? $data->sheets[0]['cells'][$i][6] : 0; $subObj->remainder = !empty($data->sheets[0]['cells'][$i][5]) ? $data->sheets[0]['cells'][$i][5] : 0; $subObj->start_date = DateModules::shamsi_to_miladi($sfd); $subObj->end_date = !empty($data->sheets[0]['cells'][$i][8]) ? DateModules::shamsi_to_miladi($efd) : ""; $subObj->loan_no = !empty($data->sheets[0]['cells'][$i][9]) ? $data->sheets[0]['cells'][$i][9] : ""; $subObj->contract_no = !empty($data->sheets[0]['cells'][$i][10]) ? $data->sheets[0]['cells'][$i][10] : ""; $subObj->salary_item_type_id = $data->sheets[0]['cells'][$i][1]; $subObj->reg_date = DateModules::NowDateTime(); //Isfinished = 0 ; if ($subObj->Add() === false) { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], "-", " خطا "); $unsuccess_count++; continue; } } // ثبت گردش ................................................... if ($data->sheets[0]['cells'][$i][3] == 2) { $qry = " select psf.subtract_id \n\t\t\t\t\t\t\t\t\tfrom person_subtracts ps inner join person_subtract_flows psf \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton ps.subtract_id = psf.subtract_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\twhere ps.salary_item_type_id = " . $data->sheets[0]['cells'][$i][1] . " and\n\t\t\t\t\t\t\t\t\t\t\t ps.PersonID =" . $PID . " and \n\t\t\t\t\t\t\t\t\t\t\t psf.flow_date >= '" . str_replace("/", "-", $sdate) . "' and \n\t\t\t\t\t\t\t\t\t\t\t psf.flow_date <= '" . str_replace("/", "-", $edate) . "'"; $res = PdoDataAccess::runquery($qry); if (count($res) > 0 && $res[0]['subtract_id'] > 0) { //echo PdoDataAccess::GetLatestQueryString() ; die(); $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], "-", " این گردش قبلا در سیستم ثبت گردیده است."); $unsuccess_count++; continue; } //................................................................. $qry = " select ps.subtract_id, ts.remainder, ps.instalment \n\t\t\t\t\t\t\t\t\tfrom person_subtracts ps left join tmp_SubtractRemainders ts \n\t\t\t\t\t\t\t\t\t on ps.subtract_id = ts.subtract_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\twhere ps.salary_item_type_id = " . $data->sheets[0]['cells'][$i][1] . " and\n\t\t\t\t\t\t\t\t\t\t\t ps.PersonID =" . $PID . " AND ps.IsFinished = 0 AND ps.start_date <= '" . str_replace("/", "-", $sdate) . "' AND \n\t\t\t\t\t\t\t\t\t\t\t( ps.end_date >= '" . str_replace("/", "-", $edate) . "' OR ps.end_date IS NULL OR ps.end_date = '0000-00-00' ) "; $res = PdoDataAccess::runquery($qry); // echo PdoDataAccess::GetLatestQueryString() ; if (count($res) > 0 && $res[0]['subtract_id'] > 0) { $new_remainder = $new_instalment = 0; if ($data->sheets[0]['cells'][$i][2] == 1) { $subFlowObj->subtract_id = $res[0]['subtract_id']; $subFlowObj->flow_type = REGISTER_NEW_FLOW_TYPE; $subFlowObj->flow_date = DateModules::NowDateTime(); $subFlowObj->flow_coaf = !empty($data->sheets[0]['cells'][$i][5]) && $data->sheets[0]['cells'][$i][5] * 1 > $res[0]['remainder'] * 1 ? -1 : 1; $subFlowObj->amount = !empty($data->sheets[0]['cells'][$i][5]) && $data->sheets[0]['cells'][$i][5] * 1 > $res[0]['remainder'] * 1 ? $data->sheets[0]['cells'][$i][5] * 1 - $res[0]['remainder'] * 1 : $res[0]['remainder'] * 1 - $data->sheets[0]['cells'][$i][5] * 1; $subFlowObj->newRemainder = !empty($data->sheets[0]['cells'][$i][5]) ? $data->sheets[0]['cells'][$i][5] : 0; $subFlowObj->comments = "گردش دستی"; if ($subFlowObj->Add() == false) { $log_obj->make_unsuccess_rows($subObj->staff_id); $unsuccess_count++; continue; } else { $new_remainder = !empty($data->sheets[0]['cells'][$i][5]) ? $data->sheets[0]['cells'][$i][5] : 0; $new_instalment = !empty($data->sheets[0]['cells'][$i][6]) ? $data->sheets[0]['cells'][$i][6] : 0; $qry = " update person_subtracts \n\t\t\t\t\t\t\t\t\t\t\tset\t\tremainder = " . $new_remainder . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\tinstalment = " . $new_instalment . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\treg_date = '" . DateModules::NowDateTime() . "'\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\twhere subtract_id =" . $subFlowObj->subtract_id; PdoDataAccess::runquery($qry); } } else { //echo "*****"; die() ; $new_instalment = !empty($data->sheets[0]['cells'][$i][6]) ? $data->sheets[0]['cells'][$i][6] : 0; $qry = " update person_subtracts \n\t\t\t\t\t\t\t\t\t\tset\t\t\n\t\t\t\t\t\t\t\t\t\t\t\tinstalment = " . $new_instalment . ",\n\t\t\t\t\t\t\t\t\t\t\t\treg_date = '" . DateModules::NowDateTime() . "'\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\twhere subtract_id =" . $res[0]['subtract_id']; PdoDataAccess::runquery($qry); } } else { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], "این وام / کسور ثبت سیستم نشده است."); $unsuccess_count++; continue; } } } else { $log_obj->make_unsuccess_rows($data->sheets[0]['cells'][$i][0], $data->sheets[0]['cells'][$i][1], "کد قلم معتبر نمی باشد."); $unsuccess_count++; continue; } } $log_obj->finalize(); $st = preg_replace('/\\r\\n/', "", $log_obj->make_result()); if ($unsuccess_count > 0) { $pdo->rollBack(); } else { $pdo->commit(); } echo "{success:true,data:'" . $st . "'}"; die; } }