function __construct($PersonID = "", $staff_id = "")
{
if ($PersonID != "") {
$query = "select * from HRM_persons where PersonID=:pid";
parent::FillObject($this, $query, array(":pid" => $PersonID));
if (empty($this->PersonID)) {
$this->PushException("کد وارد شده معتبر نمی باشد.");
return null;
}
} else {
if ($staff_id != "") {
$query = " SELECT p.*\n\t\t\t FROM HRM_persons p JOIN HRM_staff s ON(p.PersonID=s.PersonID)\n\n\t\t\t WHERE s.staff_id = :stid";
parent::FillObject($this, $query, array(":stid" => $staff_id));
if (empty($this->PersonID)) {
$this->PushException("کد وارد شده معتبر نمی باشد.");
return null;
}
} else {
$this->sex = "1";
$this->marital_status = "1";
$this->family_protector = "0";
$this->locality_type = "0";
$this->birth_state_id = "19";
$this->birth_city_id = "11";
$this->issue_state_id = "19";
$this->issue_city_id = "11";
}
}
return;
}
function __construct($param_type = "", $person_type = "")
{
$query = " SELECT *\r\n\t \tFROM salary_param_types\r\n\t \t\tWHERE param_type = :pid and person_type =:pt\r\n\t \t\t ";
$whereParam = array(":pid" => $param_type, ":pt" => $person_type);
$temp = parent::runquery($query, $whereParam);
parent::FillObject($this, $query, $whereParam);
}
function __construct($tax_table_type_id = "", $person_type = "")
{
$query = " SELECT *\r\n\t \tFROM tax_table_types\r\n\t \t\tWHERE tax_table_type_id = :tid and person_type =:pt\r\n\t \t\t ";
$whereParam = array(":tid" => $tax_table_type_id, ":pt" => $person_type);
$temp = parent::runquery($query, $whereParam);
parent::FillObject($this, $query, $whereParam);
}
function __construct($DocID = "", $pdo = null)
{
$this->DT_DocDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_RegDate = DataMember::CreateDMA(DataMember::DT_DATE);
if ($DocID != "") {
parent::FillObject($this, "select * from ACC_docs where DocID=?", array($DocID), $pdo);
}
}
function __construct($person_type, $writ_type_id, $writ_subtype_id)
{
if ($person_type != "" && $writ_type_id != "" && $writ_subtype_id != "") {
$query = "select * from writ_subtypes \r\n\t\t\t\twhere person_type = :ptype and \r\n\t\t\t\t\t writ_type_id = :wTypeId and \r\n\t\t\t\t\t writ_subtype_id = :wSubTypeId";
$whereParam = array(":ptype" => $person_type, ":wTypeId" => $writ_type_id, ":wSubTypeId" => $writ_subtype_id);
PdoDataAccess::FillObject($this, $query, $whereParam);
}
}
function __construct($subtract_id = "")
{
$this->DT_start_date = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_end_date = DataMember::CreateDMA(DataMember::DT_DATE);
if ($subtract_id != "") {
parent::FillObject($this, "select * from person_subtracts where subtract_id=?", array($subtract_id));
}
}
function __construct($staff_id = "")
{
if ($staff_id != "") {
$whereParam = array(":staff_id" => $staff_id);
$query = "select * from staff_details where staff_id=:staff_id";
PdoDataAccess::FillObject($this, $query, $whereParam);
}
}
public function __construct($staff_id = "")
{
if ($staff_id != "") {
$whereParam = array(":staff_id" => $staff_id);
$query = "select * from staff_tax_history where staff_id=:staff_id AND payed_tax_value IS NOT NULL ";
PdoDataAccess::FillObject($this, $query, $whereParam);
}
$this->DT_start_date = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_end_date = DataMember::CreateDMA(DataMember::DT_DATE);
}
function __construct($ShiftID = "")
{
$this->DT_FromTime = DataMember::CreateDMA(DataMember::DT_TIME);
$this->DT_ToTime = DataMember::CreateDMA(DataMember::DT_TIME);
$this->DT_ExceptFromTime = DataMember::CreateDMA(DataMember::DT_TIME);
$this->DT_ExceptToTime = DataMember::CreateDMA(DataMember::DT_TIME);
if ($ShiftID != "") {
PdoDataAccess::FillObject($this, "select *\tfrom ATN_shifts where ShiftID=?", array($ShiftID));
}
}
function __construct($RequestID = "")
{
$this->DT_ReqDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_StartDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_EndDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_LetterDate = DataMember::CreateDMA(DataMember::DT_DATE);
if ($RequestID != "") {
PdoDataAccess::FillObject($this, "\r\n\t\t\t\tselect r.* , concat_ws(' ',fname,lname,CompanyName) _fullname,bf.InfoDesc _TypeDesc\r\n\t\t\t\t\tfrom WAR_requests r \r\n\t\t\t\t\tleft join BaseInfo bf on(bf.TypeID=74 AND InfoID=r.TypeID)\r\n\t\t\t\t\tleft join BSC_persons using(PersonID)\r\n\t\t\t\twhere RequestID=?", array($RequestID));
}
}
function __construct($tax_table_id = "", $tax_table_type_id = "")
{
if ($tax_table_id != "") {
parent::FillObject($this, "select * from tax_tables where tax_table_id=:tid", array("tid" => $tax_table_id));
} else {
if ($tax_table_type_id != "") {
$query = "select * from tax_tables\r\n where tax_table_type_id = :ttid ";
$whereParam = array();
$whereParam[":ttid"] = $tax_table_type_id;
parent::FillObject($this, $query, $whereParam);
}
}
$this->DT_from_date = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_to_date = DataMember::CreateDMA(DataMember::DT_DATE);
}
function __construct($salary_item_type_id = "")
{
$this->DT_validity_start_date = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_validity_end_date = DataMember::CreateDMA(DataMember::DT_DATE);
if ($salary_item_type_id != "") {
$query = "select * from HRM_salary_item_types where salary_item_type_id=:sit";
PdoDataAccess::FillObject($this, $query, array(":sit" => $salary_item_type_id));
} else {
$this->insure_include = "1";
$this->tax_include = "1";
$this->retired_include = "1";
$this->pension_include = "1";
$this->user_data_entry = "1";
$this->backpay_include = "0";
}
return;
}
function __construct($param_id = "", $person_type = "", $param_type = "", $param_date = "", $dim_where = "")
{
if ($param_id != "") {
parent::FillObject($this, "select * from HRM_salary_params where param_id=:pid", array("pid" => $param_id));
} else {
if ($person_type != "" && $param_type != "" && $param_date != "") {
$query = "select * from HRM_salary_params \r\n where person_type in ( :hr ) AND param_type =:typ AND from_date <= :date AND to_date >= :date ";
$query .= $dim_where != "" ? " AND " . $dim_where : "";
$whereParam = array();
$whereParam[":hr"] = $person_type;
$whereParam[":typ"] = $param_type;
$whereParam[":date"] = $param_date;
parent::FillObject($this, $query, $whereParam);
}
}
$this->DT_from_date = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_to_date = DataMember::CreateDMA(DataMember::DT_DATE);
}
function __construct($BranchID = "")
{
if ($BranchID != "") {
parent::FillObject($this, "select * from BSC_branches where BranchID=:p", array(":p" => $BranchID));
}
}
function __construct($RowID = "")
{
if ($RowID != "") {
parent::FillObject($this, "select f.* ,StepID _StepID\n\t\t\t\tfrom WFM_FlowRows f\n\t\t\t\tleft join WFM_FlowSteps using(StepRowID)\n\t\t\t\twhere RowID=?", array($RowID));
}
}
function __construct($ChequeBookID = '')
{
if ($ChequeBookID == '') {
return;
}
return parent::FillObject($this, "select * from ACC_ChequeBooks where ChequeBookID=?", array($ChequeBookID));
}
/**
* ط§ط·ظ„ط§ط¹ط§طھ ط¢ط®ط±غŒظ† طع©ظ… ظپط±ط¯ ط±ط§ ط¨ط± ظ…غŒ ع¯ط±ط¯ط§ظ†ط¯
*
* @param string $staff_id
*
* @return manage_writ object
*/
public static function GetLastWrit($staff_id)
{
$query = "select * from writs \n\t\t\twhere staff_id=:stfid and (history_only != " . HISTORY_ONLY . " OR history_only IS NULL)\n\t\t\torder by execute_date DESC,writ_id DESC,writ_ver DESC";
$whereParam = array(":stfid" => $staff_id);
require_once '../../writs/class/writ.class.php';
$obj = new manage_writ("");
PdoDataAccess::FillObject($obj, $query, $whereParam);
return $obj;
}
function __construct($tax_table_id = "", $row_no = "")
{
if ($tax_table_id != "" && $row_no != "") {
parent::FillObject($this, "select * from tax_table_items where tax_table_id=:tid and row_no=:rid ", array("tid" => $tax_table_id, "rid" => $row_no));
}
}
public function __construct($SystemID = "")
{
if ($SystemID == "") {
return;
}
parent::FillObject($this, "select * from FRW_systems where SystemID=?", array($SystemID));
}
function __construct($PersonID = "")
{
if ($PersonID != "") {
PdoDataAccess::FillObject($this, "select * from BSC_persons where PersonID=?", array($PersonID));
}
}
function __construct($SendID = "")
{
$this->DT_SendDate = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_ResponseTimeout = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_FollowUpDate = DataMember::CreateDMA(DataMember::DT_DATE);
if ($SendID != "") {
parent::FillObject($this, "select * from OFC_send where SendID=?", array($SendID));
}
}
function __construct($RowID = "")
{
if ($RowID != "") {
PdoDataAccess::FillObject($this, "select * from PLN_PlanSurvey where RowID=?", array($RowID));
}
}
function __construct($RowID = "")
{
if ($RowID != "") {
PdoDataAccess::FillObject($this, "select * from DMS_DocFiles where RowID=?", array($RowID));
}
}
function __construct($writ_id = "", $writ_ver = "", $staff_id = "", $salary_item_type_id = "", $newItem = "") {
if (!empty($writ_id) && !empty($writ_ver) && !empty($staff_id) && !empty($salary_item_type_id)) {
$query = "select * from HRM_writ_salary_items where writ_id=" . $writ_id .
" AND writ_ver=" . $writ_ver . " AND staff_id = " . $staff_id . " AND salary_item_type_id=" . $salary_item_type_id;
PdoDataAccess::FillObject($this, $query);
}
if ($newItem == 'new') {
$this->must_pay = 1;
}
}
function __construct($StepID = "")
{
if ($StepID != "") {
parent::FillObject($this, "select * from FGR_steps where StepID=?", array($StepID));
}
}
function __construct($id = '')
{
if ($id != '') {
parent::FillObject($this, "select * from " . static::TableName . " where " . static::TableKey . " =:id", array(":id" => $id));
}
}
function __construct($post_id = "")
{
$this->DT_validity_start = DataMember::CreateDMA(DataMember::DT_DATE);
$this->DT_validity_end = DataMember::CreateDMA(DataMember::DT_DATE);
if ($post_id == "") {
return;
}
parent::FillObject($this, "select p.*,concat(pfname,' ',plname) as _fullName, jf.jcid as _jcid\r\n\t\t\tfrom `position` p\r\n\t\t\t\tleft join staff as s using(staff_id)\r\n left join persons as ps using(PersonID)\r\n\t\t\t\tleft join job_fields jf using(jfid)\r\n\t\t\t\t\r\n\t\t\twhere p.post_id=?", array($post_id));
}
static function get_last_writ_With_salry_before_date($staff_id, $execute_date)
{
$query = "\n\t\t\tselect *\n\t\t\tfrom writs\n\t\t\twhere staff_id = ? and execute_date < ? and\n\t\t\t\thistory_only != 1 and emp_mode not in (3,9,15)\n\t\t\torder by execute_date DESC , writ_id DESC , writ_ver DESC\n\t\t\tlimit 1 ";
$obj = new manage_writ();
PdoDataAccess::FillObject($obj, $query, array($staff_id, $execute_date));
return $obj;
}
function __construct($ouid = "")
{
if ($ouid == "") {
return;
}
parent::FillObject($this, "select * from org_new_units where ouid=?", array($ouid));
if (parent::AffectedRows() == 0) {
$this->PushException("کد وارد شده معتبر نمی باشد.");
return;
}
}
function __construct($LoanID = "")
{
if ($LoanID != "") {
PdoDataAccess::FillObject($this, "select l.*,b.BlockCode _BlockCode\r\n\t\t\t\tfrom LON_loans l join ACC_blocks b using(BlockID) where LoanID=?", array($LoanID));
}
}
