function Remove($All = "")
{
$query = " select * from evaluation_lists where list_id = " . $this->list_id . " and doc_state = 3 ";
$tmp2 = parent::runquery($query);
if (count($tmp2) > 0) {
parent::PushException("این لیست تایید واحد مرکزی می باشد .");
return false;
} else {
if ($All == "true") {
$result = parent::delete("evaluation_list_items", "list_id=?", array($this->list_id));
} else {
$result = parent::delete("evaluation_list_items", "list_id =? and ListItemID=? ", array($this->list_id, $this->ListItemID));
}
}
if (!$result) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $this->list_id;
$daObj->SubObjectID = $this->ListItemID;
$daObj->TableName = "evaluation_list_items";
$daObj->execute();
return true;
}
function Remove()
{
if ($this->list_type == 9) {
$tblName = "mission_list_items";
} else {
$tblName = "pay_get_list_items";
}
$query = " select * from " . $tblName . " where list_id = " . $this->list_id;
$tmp = parent::runquery($query);
$query = " select * from pay_get_lists where list_id = " . $this->list_id . " and doc_state = 3 ";
$tmp2 = parent::runquery($query);
if (count($tmp) > 0) {
parent::PushException("این لیست شامل مجموعه ای از افراد می باشد .");
return false;
} else {
if (count($tmp2) > 0) {
parent::PushException("این لیست تایید واحد مرکزی می باشد .");
return false;
} else {
$result = parent::delete("pay_get_lists", "list_id=?", array($this->list_id));
}
}
if (!$result) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $this->list_id;
$daObj->TableName = "pay_get_lists";
$daObj->execute();
return true;
}
private function onBeforeDelete()
{
$res = parent::runquery(" select * from tax_table_items\r\n\t\t\t\t\t\t\t\t\t\t\t\t\twhere tax_table_id = " . $this->tax_table_id);
if (count($res) > 0) {
parent::PushException("این رکورد دارای اطلاعات وابسته می باشد.");
return false;
}
return true;
}
function duty_year_month_day($staff_id = "", $personID = "", $toDate) {
if ($staff_id == "" && $personID = "") {
PdoDataAccess::PushException("يکي از دو پارامتر staff_id و PersonID بايد فرستاده شود");
return false;
}
$query = "select w.execute_date,
w.contract_start_date ,
w.contract_end_date ,
w.person_type ,
w.onduty_year ,
w.onduty_month ,
w.onduty_day ,
w.annual_effect
from writs as w";
if ($personID != "")
$query .= " join staff as s using(staff_id) where s.PersonID=" . $personID;
else if ($staff_id != "")
$query .= " where w.staff_id = $staff_id";
$query .= " AND (w.history_only != " . HISTORY_ONLY . " OR w.history_only is null) AND w.execute_date <= '$toDate'
order by w.execute_date DESC,w.writ_id DESC,w.writ_ver DESC
limit 1";
$temp = PdoDataAccess::runquery($query);
if (count($temp) == 0)
return array("year" => 0, "month" => 0, "day" => 0);
$writ_rec = $temp[0];
$temp_duration = 0;
if (DateModules::CompareDate($toDate, $writ_rec['execute_date']) >= 0)
$temp_duration = DateModules::GDateMinusGDate($toDate, $writ_rec['execute_date']);
if ($writ_rec['annual_effect'] == HALF_COMPUTED)
$temp_duration *= 0.5;
else if ($writ_rec['annual_effect'] == DOUBLE_COMPUTED)
$temp_duration *= 2;
else if ($writ_rec['annual_effect'] == NOT_COMPUTED)
$temp_duration = 0;
$prev_writ_duration = DateModules::ymd_to_days($writ_rec['onduty_year'], $writ_rec['onduty_month'], $writ_rec['onduty_day']);
$duration = $prev_writ_duration + $temp_duration;
$return = array();
DateModules::day_to_ymd($duration, $return['year'], $return['month'], $return['day']);
return $return;
}
private function onBeforeDelete()
{
$res = parent::runquery(" select * from tax_tables\r\n\t\t\t\t\t\t\t\t\t\t\t\t\twhere tax_table_type_id = " . $this->tax_table_type_id);
if (count($res) > 0) {
parent::PushException(TAX_CAN_NOT_DELETE);
return false;
}
$resstaff = parent::runquery(" select * from staff_tax_history\r\n\t\t\t\t\t\t\t\t\t\t\t\t\twhere tax_table_type_id = " . $this->tax_table_type_id);
if (count($resstaff) > 0) {
parent::PushException(STAFF_TAX_CAN_NOT_DELETE);
return false;
}
return true;
}
static function RemoveJobHistory($PersonID, $row_no)
{
$whereParams = array();
$whereParams[":pid"] = $PersonID;
$whereParams[":rowid"] = $row_no;
if (PdoDataAccess::delete("PersonJobs", " PersonID=:pid and RowNO=:rowid", $whereParams) === false) {
parent::PushException(ER_PERSON_DEP_DEL);
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->RelatedPersonID = $PersonID;
$daObj->MainObjectID = $row_no;
$daObj->TableName = "PersonJobs";
$daObj->execute();
return true;
}
static function Remove($pid)
{
$res = parent::runquery(" select count(*) cn from SubtractItemInfo where arrangement = " . $pid);
if ($res[0]['cn'] > 0) {
parent::PushException("حذف این رکورد امکان پذیر نمی باشد.");
return false;
}
$result = parent::delete("priority", "PriorityID=:PID ", array(":PID" => $pid));
if (!$result) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $pid;
$daObj->TableName = "priority";
$daObj->execute();
return true;
}
static function Remove($bid)
{
$res = parent::runquery(" select count(*) cn from staff where bank_id = " . $bid);
if ($res[0]['cn'] > 0) {
parent::PushException("حذف این رکورد امکان پذیر نمی باشد.");
return false;
}
$result = parent::delete("banks", "bank_id=:BID ", array(":BID" => $bid));
if (!$result) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $bid;
$daObj->TableName = "banks";
$daObj->execute();
return true;
}
static function Remove($sfid, $sbid)
{
$res = parent::runquery(" select count(*) cn from person_educations where sfid = " . $sfid . " and sbid = " . $sbid);
if ($res[0]['cn'] > 0) {
parent::PushException("این رشته در اطلاعات پایه افراد ثبت شده است به همین دلیل حذف امکان پذیر نمی باشد .");
return false;
}
$result = parent::delete("study_branchs", "sfid=:sfid and sbid=:sbid", array(":sfid" => $sfid, ":sbid" => $sbid));
if ($result === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $sfid;
$daObj->SubObjectID = $sbid;
$daObj->TableName = "study_branchs";
$daObj->execute();
return true;
}
static function Remove($uid, $cid)
{
$res = parent::runquery(" select count(*) cn from person_educations where university_id = " . $uid . " and country_id =" . $cid);
if ($res[0]['cn'] > 0) {
parent::PushException("حذف این رکورد به علت استفاده در اطلاعات پرسنل امکان پذیر نمی باشد.");
return false;
}
$result = parent::delete("universities", "university_id=:UID and country_id = :CID ", array(":UID" => $uid, ":CID" => $cid));
if (!$result) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $uid;
$daObj->SubObjectID = $cid;
$daObj->TableName = "universities";
$daObj->execute();
return true;
}
static function Remove($CostID)
{
$query = " select count(*) cn \r\n\t\t\t\tfrom writs \r\n\t\t\t\t where cost_center_id = " . $CostID;
$res = parent::runquery($query);
if ($res[0]['cn'] > 0) {
parent::PushException("این مرکز هزینه در احکام ثبت گردیده است لذا حذف امکان پذیر نمی باشد.");
return false;
}
$result = parent::delete("cost_centers", "cost_center_id=:CID ", array(":CID" => $CostID));
if ($result === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $CostID;
$daObj->TableName = "cost_centers";
$daObj->execute();
return true;
}
function Add()
{
$query = " select * from CostCenterException where SalaryItemTypeID= " . $this->SalaryItemTypeID . " and \r\n PersonType = " . $this->PersonType . " and CostCenterID = " . $this->CostCenterID;
$res = parent::runquery($query);
if (count($res) > 0) {
parent::PushException(IS_AVAILABLE);
return false;
}
$return = parent::insert("CostCenterException", $this);
if ($return === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_add;
$daObj->MainObjectID = $this->SalaryItemTypeID;
$daObj->SubObjectID = $this->PersonType;
$daObj->TableName = "CostCenterException";
$daObj->execute();
return true;
}
function Add()
{
$query = " select * \r\n\t\t\t\t from SubtractItemInfo \r\n\t\t\t\t\twhere SalaryItemTypeID= " . $this->SalaryItemTypeID . " and PersonType = " . $this->PersonType . " and \r\n\t\t\t\t\t ( ToDate is Null OR ToDate = '0000-00-00' )";
$res = parent::runquery($query);
if (count($res) > 0) {
parent::PushException(strtr(IS_AVAILABLE, array("%0%" => $res[0]["arrangement"])));
return false;
}
$return = parent::insert("SubtractItemInfo", $this);
if ($return === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_add;
$daObj->MainObjectID = $this->SalaryItemTypeID;
$daObj->SubObjectID = $this->PersonType;
$daObj->TableName = "SubtractItemInfo";
$daObj->execute();
return true;
}
private function date_overlap($PID)
{
$whereParam = array();
$whereParam[":pid"] = $PID;
$query = "select count(*) cn\n\t\t\t\t\t\t\tfrom staff_tax_history sth inner join staff s\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton sth.staff_id = s.staff_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join persons p\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton s.personid = p.personid\n\t\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\t\t\t\t p.personid =:pid and payed_tax_value is null and ( sth.end_date is null or sth.end_date = '0000-00-00' )\n ";
$temp = PdoDataAccess::runquery($query, $whereParam);
if ($temp[0][0] > 0 && $this->tax_history_id == null) {
parent::PushException("لطفا ابتدا تاریخ انتهای رکورد قبل را پر نمایید.");
return false;
}
$query = "\tselect count(*)\n\t\t\t\t\t\t\tfrom staff_tax_history sth inner join staff s\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton sth.staff_id = s.staff_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join persons p\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton s.personid = p.personid\n\t\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\t\t\t\t((sth.start_date <=:fdate AND sth.end_date>=:fdate) OR (sth.start_date>=:fdate AND sth.start_date <=:tdate)) AND\n\t\t\t\t\t\t\t\t\t\t\t p.personid =:pid ";
$whereParam[":fdate"] = str_replace('/', '-', DateModules::shamsi_to_miladi($this->start_date));
$whereParam[":tdate"] = str_replace('/', '-', DateModules::shamsi_to_miladi($this->end_date));
if ($this->tax_history_id) {
$query .= " and tax_history_id != :ihid ";
$whereParam[":ihid"] = $this->tax_history_id;
}
$temp = PdoDataAccess::runquery($query, $whereParam);
if ($temp[0][0] != 0) {
parent::PushException(ER_DATE_RANGE_OVERLAP);
return false;
}
return true;
}
private function date_overlap()
{
$query = "select count(*) from salary_params where \r\n\t\t\t((from_date<=:fdate AND to_date>=:fdate) OR (from_date>=:fdate AND from_date <=:tdate)) \r\n\t\t\tAND person_type=:hr AND param_type=:ptype";
$whereParam = array();
$whereParam[":fdate"] = $this->from_date;
$whereParam[":tdate"] = $this->to_date;
$whereParam[":hr"] = $this->person_type;
$whereParam[":ptype"] = $this->param_type;
if (isset($this->param_id)) {
$query .= " AND param_id<>:pid";
$whereParam[":pid"] = $this->param_id;
}
if (isset($this->dim1_id)) {
$query .= " AND dim1_id = :d1id";
$whereParam[":d1id"] = $this->dim1_id;
}
if (isset($this->dim2_id)) {
$query .= " AND dim2_id = :d2id";
$whereParam[":d2id"] = $this->dim2_id;
}
if (isset($this->dim3_id)) {
$query .= " AND dim3_id = :d3id";
$whereParam[":d3id"] = $this->dim3_id;
}
$temp = PdoDataAccess::runquery($query, $whereParam);
if ($temp[0][0] != 0) {
parent::PushException(ER_DATE_RANGE_OVERLAP);
return true;
}
return false;
}
function compute_salary_item1_01($writ_rec)
{
//param1 : پايه
//param2 : عدد مبنا
//param3 : ضريب حقوق
if (($writ_rec['emp_state'] == EMP_STATE_SOLDIER_CONTRACTUAL || $writ_rec['emp_state'] == EMP_STATE_ONUS_SOLDIER_CONTRACTUAL || $writ_rec['emp_state'] == EMP_STATE_CONTRACTUAL) && $writ_rec['execute_date'] < str_replace("/", "-", DateModules::shamsi_to_miladi('1389-07-01'))) {
$base = 1;
} else {
$base = $writ_rec['base'];
}
$professor_base_number = Get_professor_base_number($writ_rec['science_level']);
$salary_coef = manage_salary_params::get_salaryParam_value("", HR_PROFESSOR, SPT_SALARY_COEF, $writ_rec['execute_date']);
if (!$salary_coef) {
PdoDataAccess::PushException(SALARY_COEF_NOT_FOUND);
return false;
}
//$this->param1 = $base;
//$this->param2 = $professor_base_number;
//$this->param3 = $salary_coef;
$value = $salary_coef * ($professor_base_number + 5 * $base);
//echo $value ." value ----<br> ";
if (!($value > 0)) {
parent::PushException(BASE_SALARY_CALC_ERR);
return false;
}
if (($writ_rec['emp_state'] == EMP_STATE_SOLDIER_CONTRACTUAL || $writ_rec['emp_state'] == EMP_STATE_ONUS_SOLDIER_CONTRACTUAL || $writ_rec['emp_state'] == EMP_STATE_CONTRACTUAL) && $writ_rec['execute_date'] < '2009-09-23') {
$value *= 0.95;
}
//echo $value ." value ----<br> "; die();
return $value;
}
static function RemoveDependency($PersonID, $row_no)
{
$whereParams = array();
$whereParams[":pid"] = $PersonID;
$whereParams[":rowid"] = $row_no;
if (parent::delete("HRM_person_dependents", " PersonID=:pid and row_no=:rowid", $whereParams) === false) {
$error = implode("", parent::popExceptionDescription());
if (strpos($error, "a foreign key constraint fails") !== false) {
if (strpos($error, "person_dependent_supports") !== false) {
parent::PushException("این وابسته دارای سابقه کفالت بوده و قابل حذف نمی باشد.");
} else {
parent::PushException("از این وابسته در جای دیگری استفاده شده و قابل حدف نمی باشد.");
}
} else {
parent::PushException($error);
}
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->MainObjectID = $row_no;
$daObj->RelatedPersonType = 3;
$daObj->RelatedPersonID = $PersonID;
$daObj->TableName = "person_dependents";
$daObj->execute();
return true;
}
function check_to_run()
{
if ($this->backpay_recurrence > 1) {
return true;
}
$tmp_rs = parent::runquery('SELECT * FROM payment_runs WHERE time_stamp >= :expireDate', array(":expireDate" => time() - $this->expire_time));
//هيچ اجراي فعالي وجود ندارد
if ($tmp_rs->recordCount() == 0) {
parent::runquery('INSERT INTO payment_runs(time_stamp,uname) VALUES(?,?)', array(time(), $_SESSION["UserID"]));
$this->run_id = parent::InsertID();
return true;
}
parent::PushException(strstr(ER_CAN_NOT_RUN_PAYMENT_CALC, array("%0%" => $temp[0]["uname"], "%1%" => $this->expire_time)));
return false;
}
/**
این تابع آخرین وضعیت تحصیلی فرد را تا تاریخ ورودی بر می گرداند
* *اگر رکورد آخرین سطح تحصیلی را می خواهید باید پارامتر تاریخ را ارسال نکنید
*
* @param int $PersonID
* @param miladi date $date
* @return record
*/
static function GetEducationLevelByDate($PersonID, $date = "", $is_auto = "")
{
$where = "";
$whereParam = array();
$whereParam[":pid"] = $PersonID;
if ($date != "") {
$where = $date != "" ? " AND doc_date <= :date" : "";
$whereParam[":date"] = $date;
}
$query = "select education_level as max_education_level,\n\t \t\t\t\t\trow_no,\n\t \t\t\t\t\tPersonID,\n\t \t\t\t\t\tsfid,\n\t \t\t\t\t\tsbid,\n\t\t\t\t\t\tdoc_date,\n\t \t\t\t\t\tu.university_id,\n\t \t\t\t\t\tburse,\n\t\t\t\t\t\tc.ptitle as countryTitle,\n\t\t\t\t\t\tu.ptitle as universityTitle\n\t \t\t\tfrom HRM_person_educations pe\n\t\t\t\t\tLEFT OUTER JOIN HRM_countries c ON(pe.country_id = c.country_id)\n\t\t\t\t LEFT OUTER JOIN HRM_universities u ON(pe.university_id = u.university_id AND pe.country_id = u.country_id)\n\t \t\t\twhere PersonID = :pid {$where}\n\t \t\t\torder by doc_date DESC\n\t \t\t\tlimit 1";
$temp = parent::runquery($query, $whereParam);
if ((count($temp) == 0 || $temp[0]["max_education_level"] == "") && $is_auto) {
parent::PushException(ERROR_PERSON_EDUCATIONS_NOT_SET);
return false;
} else {
if (count($temp) == 0 || $temp[0]["max_education_level"] == "") {
return 101;
}
}
return $temp[0];
}
function Remove()
{
$query = " select s.staff_id\n\t\t\t\t\t\t\t\tfrom HRM_staff s inner join HRM_persons p on s.personid = p.personid and s.person_type = p.person_type\n\t\t\t\t\t\t\t\t\twhere s.staff_id = " . $this->staff_id;
$temp = PdoDataAccess::runquery($query);
if (count($temp) == 0) {
parent::PushException("حذف این رکورد امکان پذیر نمی باشد.");
return false;
}
$result = parent::delete("HRM_staff_include_history", " staff_id = :SID and include_history_id = :ID ", array(":SID" => $this->staff_id, ":ID" => $this->include_history_id));
if ($result === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->RelatedPersonID = $this->staff_id;
$daObj->RelatedPersonType = 3;
$daObj->MainObjectID = $this->include_history_id;
$daObj->TableName = "staff_include_history";
$daObj->execute();
return true;
}
function ActiveCode()
{
$dt = PdoDataAccess::runquery("select c2.* from ACC_CostCodes c1 \n\t\t\tjoin ACC_CostCodes c2 on(c2.IsActive='YES' AND c1.CostID<>c2.CostID AND c1.CostCode=c2.CostCode)\n\t\t\twhere c1.CostID=?", array($this->CostID));
if (count($dt) > 0) {
parent::PushException("کد حساب تکراری است");
return false;
}
$this->IsActive = "YES";
if (!parent::update("ACC_CostCodes", $this, "CostID=:c", array(":c" => $this->CostID))) {
return false;
}
$auditObj = new DataAudit();
$auditObj->ActionType = DataAudit::Action_update;
$auditObj->MainObjectID = $this->CostID;
$auditObj->TableName = "ACC_CostCodes";
$auditObj->execute();
}
function Next_Corrective_Writ()
{
$query = " SELECT w.writ_id,\n w.writ_ver,\n w.staff_id,\n w.execute_date,\n w.corrective ,\n s.person_type ,\n w2.writ_ver upper_ver\n\n FROM staff s\n LEFT OUTER JOIN writs w\n ON (w.staff_id = s.staff_id )\n LEFT OUTER JOIN writs w2\n ON (w2.staff_id = s.staff_id AND w2.writ_id = w.writ_id AND w.writ_ver + 1 = w2.writ_ver )\n WHERE\n s.staff_id = {$this->staff_id} AND\n (w.execute_date > '{$this->execute_date}' OR (w.execute_date = '{$this->execute_date}' AND w.writ_id > {$this->writ_id}) ) AND\n ((w.history_only != " . HISTORY_ONLY . " OR w.history_only IS NULL)OR\n (w.writ_id={$this->corrective_writ_id} AND w.writ_ver={$this->corrective_writ_ver}))\n AND (w2.writ_ver IS NULL OR w.history_only != " . HISTORY_ONLY . " OR w.history_only IS NULL)\n ORDER BY s.staff_id , w.execute_date,w.writ_id , w.writ_ver ";
$temp = parent::runquery($query);
if (count($temp) > 0) {
$state = 1;
$next_writ_rec = $temp[0];
for ($i = 0; $i < count($temp); $i++) {
if ($state == 2) {
if ($temp[$i]['execute_date'] == $min_execute_date && $temp[$i]['corrective'] != 1) {
$next_writ_rec = $temp[$i];
} else {
break;
}
}
if ($state == 1) {
$min_execute_date = $temp[$i]['execute_date'];
$next_writ_rec = $temp[$i];
$state = 2;
}
}
}
if (!$next_writ_rec) {
return false;
}
$obj = new manage_writ($next_writ_rec['writ_id'], $next_writ_rec['writ_ver'], $next_writ_rec['staff_id']);
if ($obj->writ_id > 0) {
if ($this->corrective_writ_id != $obj->writ_id || $this->corrective_writ_ver != $obj->writ_ver || $obj->corrective == 0) {
$obj->history_only = 1;
$qry3 = " select writ_id , writ_ver\n from writs\n where writ_id = " . $obj->writ_id . " and writ_ver = " . $obj->writ_ver . " and\n staff_id =" . $obj->staff_id . " and state=" . WRIT_PERSONAL;
$tmp3 = parent::runquery($qry3);
if (count($tmp3) > 0) {
$obj->EditWrit();
}
//............
$qry1 = " SELECT issue_date\n \t\t\t\t\t FROM writs\n \t\t\t\t\t WHERE writ_id = " . $this->corrective_writ_id . " AND writ_ver= " . $this->corrective_writ_ver . " AND staff_id = " . $this->staff_id;
$tmp1 = parent::runquery($qry1);
$obj->issue_date = DateModules::shNow();
//$tmp1[0]['issue_date'];
if ($obj->execute_date > $obj->issue_date) {
$obj->pay_date = $obj->execute_date;
} else {
$obj->pay_date = $obj->issue_date;
}
$qry2 = " select last_writ_id , last_writ_ver\n from staff where staff_id =" . $obj->staff_id;
$tmp2 = parent::runquery($qry2);
//.............
$obj->history_only = 0;
//end
if (!$next_writ_rec['upper_ver']) {
$obj->writ_ver++;
} else {
$qry4 = " SELECT MAX(writ_ver) writ_ver\n FROM writs\n WHERE writ_id = " . $obj->writ_id;
$tmp4 = parent::runquery($qry4);
$obj->writ_ver = $tmp4[0]['writ_ver'] + 1;
}
$obj->state = 1;
$obj->corrective = 0;
$obj->corrective_date = $this->corrective_date;
$obj->corrective_writ_id = $this->corrective_writ_id;
$obj->corrective_writ_ver = $this->corrective_writ_ver;
$obj->correct_completed = WRIT_CORRECTING;
$qry5 = " select personid,staff_id from staff where staff_id =" . $obj->staff_id;
$tmp5 = parent::runquery($qry5);
$education_level_rec = manage_person_education::GetEducationLevelByDate($tmp5[0]['personid'], $obj->execute_date);
$obj->education_level = $education_level_rec['max_education_level'];
$obj->sfid = $education_level_rec['sfid'];
$obj->sbid = $education_level_rec['sbid'];
$where = " PersonID=" . $tmp5[0]['personid'] . " AND\n (dependency = 5 or dependency = 6) AND\n\t\t\t\t birth_date <='" . $obj->execute_date . "'";
$obj->children_count = manage_person_dependency::CountDependency($where);
$obj->included_children_count = manage_person_dependency::bail_count($tmp5[0]['personid'], $obj->person_type, $obj->execute_date, $obj->execute_date);
$person_obj = new manage_person($tmp5[0]['personid']);
$obj->marital_status = $person_obj->marital_status;
//......
if ($obj->person_type == HR_PROFESSOR && $obj->staff_id != '111551') {
$obj->writ_signature_post_owner = 'محمد کافی';
$obj->writ_signature_post_title = ' رئیس دانشگاه';
//$this->writ_signature_post_title = ' رئیس دانشگاه ';
} else {
if ($obj->person_type == HR_PROFESSOR && $obj->staff_id == '111551') {
//$this->writ_signature_post_owner = 'محمدجواد وریدی' ;
$obj->writ_signature_post_owner = 'ابوالفضل باباخانی';
$obj->writ_signature_post_title = 'معاون اداری ومالی دانشگاه';
} else {
$obj->writ_signature_post_owner = $obj->issue_date > '2014-02-01' ? 'ابوالقاسم ساقی' : WRIT_SIGNATURE_POST_OWNER;
}
}
//.......
//$obj->writ_signature_post_owner = ($obj->issue_date > '2014-02-01') ? 'ابوالقاسم ساقی' : WRIT_SIGNATURE_POST_OWNER ;
$pdo = parent::getPdoObject();
$pdo->beginTransaction();
if (!$obj->onBeforeInsert()) {
$pdo->rollBack();
return false;
}
$return = parent::insert("writs", $obj);
if (!$return) {
parent::PushException("ايجاد با شکست مواجه شد");
$pdo->rollBack();
return false;
}
if (!$obj->onAfterInsert()) {
parent::PushException("ايجاد با شکست مواجه شد");
$pdo->rollBack();
return false;
}
$pdo->commit();
if (!manage_writ_item::compute_writ_items($obj->writ_id, $obj->writ_ver, $obj->staff_id)) {
return false;
}
} else {
$description = "";
$this->writ_id = $obj->writ_id;
$this->writ_ver = $obj->writ_ver;
$qry3 = " SELECT w.writ_id , w.writ_ver , w.execute_date , w.issue_date , ws.title\n FROM writs w\n INNER JOIN writ_subtypes ws ON ws.writ_type_id = w.writ_type_id\n AND ws.writ_subtype_id = w.writ_subtype_id AND w.person_type = ws.person_type\n AND w.staff_id = " . $obj->staff_id . "\n INNER JOIN\n (\n SELECT\n writ_id , writ_ver - 1 writ_ver2\n FROM writs\n WHERE\n corrective_writ_id = {$this->corrective_writ_id} AND corrective_writ_ver = {$this->corrective_writ_ver} AND staff_id = " . $obj->staff_id . "\n )\n w2\n ON w.writ_id = w2.writ_id AND w.writ_ver = w2.writ_ver2";
$tmp3 = parent::runquery($qry3);
$qry4 = " SELECT w.writ_id , w.writ_ver , w.execute_date , w.issue_date , ws.title\n FROM writs w\n INNER JOIN writ_subtypes ws\n ON ws.writ_type_id = w.writ_type_id\n AND ws.writ_subtype_id = w.writ_subtype_id AND w.person_type = ws.person_type\n AND w.staff_id = {$obj->staff_id}\n WHERE\n corrective_writ_id = {$this->corrective_writ_id} AND corrective_writ_ver = {$this->corrective_writ_ver} AND\n w.writ_ver = 1 AND staff_id =" . $obj->staff_id;
$tmp4 = parent::runquery($qry4);
$i = 0;
$j = 0;
if (!empty($tmp4[0]['send_letter_no'])) {
$description .= 'بر اساس حکم شماره ' . $tmp4[0]['send_letter_no'] . ' مورخه ' . DateModules::miladi_to_shamsi($tmp4[0]['issue_date']) . ' احکام ذيل اصلاح مي گردد : ' . chr(13);
} else {
$description .= 'ليست احکام اصلاح شده : ' . chr(13);
}
for ($i = 0; $i < count($tmp3); $i++) {
$description .= $i + 1 . '- حکم ' . $tmp3[$i]['title'] . ' شماره ' . $tmp3[$i]['send_letter_no'] . ' مورخه ' . DateModules::miladi_to_shamsi($tmp3[$i]['issue_date']) . chr(13);
}
parent::runquery(" UPDATE writs\n SET correct_completed=" . WRIT_CORRECT_COMPLETED . "\n WHERE(\n (corrective_writ_id={$this->corrective_writ_id} AND corrective_writ_ver={$this->corrective_writ_ver})\n OR(writ_id={$this->corrective_writ_id} AND writ_ver={$this->corrective_writ_ver} AND staff_id = {$this->staff_id} )\n )");
parent::runquery(" UPDATE writs\n SET description = '" . $description . "'\n WHERE writ_id = {$this->writ_id} AND writ_ver={$this->writ_ver} AND description IS NULL AND staff_id =" . $this->staff_id);
}
return $obj;
}
}
static function get_devotions_last_coefs($staff_id, $gdate = "", $pt = "")
{
if ($gdate != "") {
$w = "and pd.from_date <= '{$gdate}' ";
} else {
$w = "";
}
if ($pt != HR_WORKER) {
$est = " and enlisted = 1 ";
} else {
$est = " ";
}
//_________________________________________________
// جمع اوري سوابق ايثارگري يك شخص خاص
$query = "SELECT s.staff_id,\n\t\t\t\t\tSUM(CASE WHEN pd.devotion_type=" . DEVOTION_TYPE_FIGHTER . " {$est}\n\t THEN if((pd.from_date <= '1988-08-20' and to_date <= '1988-08-20'),amount ,\n\t\t\t\t\t\t\t\tif(( pd.from_date <= '1988-08-20' and to_date >= '1988-08-20'),\n\t\t\t\t\t\t\t\t\tdatediff('1988-08-20',pd.from_date ),0 )) END) fighter,\n\t\t\t\t\tSUM(CASE WHEN pd.devotion_type=" . DEVOTION_TYPE_PRISONER . " THEN amount ELSE 0 END) prisoner,\n\t\t\t\t\tMAX(CASE WHEN pd.devotion_type=" . DEVOTION_TYPE_WOUNDED . " THEN amount ELSE 0 END) wounded\n\t\t\t\t FROM staff s\n\t\t\t\t \tINNER JOIN persons p ON (p.personID = s.personID)\n\t\t\t\t \tINNER JOIN person_devotions pd ON (pd.personID = p.personID)\n\t\t\t\t WHERE s.staff_id = {$staff_id} {$w}\n\t\t\t\t GROUP BY pd.PersonID";
$dt = parent::runquery($query);
if (count($dt) == 0) {
parent::PushException(WRIT_SALARY_ITEM_NOT_FOUND);
return false;
}
$devotion_coefs['fighter'] = $dt[0]['fighter'];
$devotion_coefs['prisoner'] = $dt[0]['prisoner'];
$devotion_coefs['wounded'] = $dt[0]['wounded'];
return $devotion_coefs;
}
/**
*ع†ع© ظ…غŒ ع©ظ†ط¯ ط§غŒط§ ط§غŒظ† ط´ظ…ط§ط±ظ‡ ط´ظ†ط§ط³ط§غŒغŒ ظˆط¬ظˆط¯ ط¯ط§ط±ط¯ غŒط§ ط®غŒط±طں
* */
static function check_exist_staff_id($staff_id)
{
$query = " SELECT staff_id\n \t\t\t FROM staff\n\t\t\t\t WHERE staff_id = {$staff_id} ";
$tmp = PdoDataAccess::runquery($query);
if (count($tmp) != 0) {
return true;
} else {
parent::PushException("ط´ط®طµ ط¨ط§ ط´ظ…ط§ط±ظ‡ ط´ظ†ط§ط³ط§غŒغŒ" . $staff_id . "ظˆط¬ظˆط¯ ظ†ط¯ط§ط±ط¯.");
return false;
}
}
static function Remove($staff_id, $row_no)
{
$whereParams = array();
$whereParams[":staff_id"] = $staff_id;
$whereParams[":rowid"] = $row_no;
if (parent::delete("professor_exe_posts", " staff_id=:staff_id and row_no=:rowid", $whereParams) === false) {
parent::PushException(ER_PERSON_DEP_DEL);
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_delete;
$daObj->RelatedPersonType = DataAudit::PersonType_staff;
$daObj->RelatedPersonID = $staff_id;
$daObj->MainObjectID = $staff_id;
$daObj->SubObjectID = $row_no;
$daObj->TableName = "professor_exe_posts";
$daObj->execute();
return true;
}
static function is_valid($post_id, $date, $staff_id)
{
$query = " select * from position where post_id =" . $post_id;
$temp = PdoDataAccess::runquery($query);
if (count($temp) == 0) {
parent::PushException(POST_IS_NOT_VALID);
return false;
}
//پست در اختيار فرد ديگري است
if ($temp[0]["staff_id"] != $staff_id && $temp[0]["staff_id"] != NULL) {
parent::PushException(str_replace("%0%", $temp[0]['staff_id'], POST_HAS_DETERMINED_ERR));
return false;
}
// پست در تاريخ اجراي حكم معتبر است
if (($temp[0]['validity_start'] <= $date || $temp[0]['validity_start'] == "" || $temp[0]['validity_start'] == "0000-00-00") && ($temp[0]['validity_end'] >= $date || $temp[0]['validity_end'] == "" || $temp[0]['validity_end'] == "0000-00-00")) {
return true;
} else {
parent::PushException(POST_EXPIRE);
return false;
}
}
/**
مزد سنوات
*/
private function compute_salary_item5_39($writ_rec) {
// should be deleted at the first of 91 ------------------------------------------
$MONTH_DAY_COUNT = ($writ_rec["person_type"] == HR_WORKER) ? 31 : MONTH_DAY_COUNT;
if ($writ_rec['execute_date'] >= '2012-03-20') {
$MONTH_DAY_COUNT = 30;
}
//param1 : افزايش سنواتي سال قبل
//param2 : نرخ سنوات امسال
//param3 : تعداد روزهاي ماه
$this_writ_year = substr(DateModules::miladi_to_shamsi($writ_rec['execute_date']), 0, 4);
$one_year_ago = $this_writ_year - 1;
$one_year_ago_first_day = $one_year_ago . "-01-01";
$one_year_ago_last_day_writ = $one_year_ago . "-12-29";
$Gone_year_ago_first_day = DateModules::shamsi_to_miladi($one_year_ago_first_day);
$Gone_year_ago_last_day = DateModules::shamsi_to_miladi($one_year_ago_last_day_writ);
if ($this_writ_year >= '1389') {
//آخرين حکم قبل از سال شخص را استخراج مي کند.
$prior_writ_rec = manage_writ::get_last_writ_by_date($writ_rec['staff_id'],$Gone_year_ago_last_day); //'2013-02-18'
//در بدو استخدام سنوات به شخص تعلق نمي گيرد.
if ($prior_writ_rec->writ_id == "")
return 0;
//end
}
$annual_rate = manage_salary_params::get_salaryParam_value("", $writ_rec['person_type'].",101", SPT_GROUP1_ANNUAL_RATE, $writ_rec['execute_date'], $writ_rec['job_group']);
if (!(0 < $annual_rate)) {
parent::PushException(UNKNOWN_GROUP1_ANNUAL_RATE);
return false;
}
if ($this_writ_year >= '1389') {
if ($prior_writ_rec->writ_id != "")
$prior_annual_inc = manage_writ_item::get_writSalaryItem_value($prior_writ_rec->writ_id, $prior_writ_rec->writ_ver, $prior_writ_rec->staff_id, SIT_STAFF_DEFINED_ANNUAL_INC);
else
$prior_annual_inc = 0;
}
else {
$prior_annual_inc = 0;
}
$work_start_date = $writ_rec["work_start_date"];
if ($this_writ_year >= '1389')
$year_work_days = manage_writ::compute_year_work_days($Gone_year_ago_first_day, $Gone_year_ago_last_day, $writ_rec['staff_id']);
else
$year_work_days = manage_writ::compute_year_work_days($work_start_date, $Gone_year_ago_last_day, $writ_rec['staff_id']);
if ($year_work_days > 365 &&
$writ_rec['person_type'] == HR_CONTRACT) {
$year_work_days = 360;
}
$Day_Year = ( $writ_rec['person_type'] == HR_CONTRACT ) ? 360 : 365;
if ($writ_rec['person_type'] == HR_CONTRACT)
$month_duration = 30;
else if ($writ_rec['person_type'] == HR_WORKER)
$month_duration = $MONTH_DAY_COUNT;
if ($writ_rec['execute_date'] >= '2012-03-20') {
$month_duration = 30;
}
$value = $prior_annual_inc + (($annual_rate * $month_duration) * $year_work_days / $Day_Year );
return $value;
}
private function date_overlap()
{
if ($this->tax_table_id == null) {
$W = "";
} else {
$W = " AND tax_table_id != " . $this->tax_table_id;
}
$query = "\tselect count(*)\r\n\t\t\t\t\t\t\tfrom tax_tables\r\n\t\t\t\t\t\t\t\t\twhere\r\n\t\t\t\t\t\t\t\t\t\t\t((from_date <=:fdate AND to_date>=:fdate) OR (from_date>=:fdate AND from_date <=:tdate)) AND\r\n\t\t\t\t\t\t\t\t\t\t\t tax_table_type_id=:ttid " . $W;
$whereParam = array();
$whereParam[":fdate"] = DateModules::shamsi_to_miladi($this->from_date);
$whereParam[":tdate"] = DateModules::shamsi_to_miladi($this->to_date);
$whereParam[":ttid"] = $this->tax_table_type_id;
$temp = PdoDataAccess::runquery($query, $whereParam);
if ($temp[0][0] != 0) {
parent::PushException(ER_DATE_RANGE_OVERLAP);
return false;
}
return true;
}
function EditPerson()
{
$whereParams = array();
$whereParams[":pid"] = $this->PersonID;
//........بررسی اعتبار کد ملی فرد .........
if (!self::IsValidNID($this->national_code)) {
parent::PushException("کد ملی فرد معتبر نمی باشد.");
return false;
}
if (PdoDataAccess::update("HRM_persons", $this, " PersonID=:pid", $whereParams) === false) {
return false;
}
$daObj = new DataAudit();
$daObj->ActionType = DataAudit::Action_update;
$daObj->MainObjectID = $this->PersonID;
$daObj->TableName = "HRM_persons";
$daObj->execute();
return true;
}
