function selectMiscDoc() { $where = " PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "title": $where .= " AND title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "doc_no": $where .= " AND doc_no=:qry "; $whereParam[":qry"] = $_GET["query"]; break; case "row_no": $where .= " AND row_no=:qry "; $whereParam[":qry"] = $_GET["query"]; break; } } $no = manage_person_misc_doc::CountMiscDoc($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_misc_doc::GetAllMiscDoc($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function SearchJob() { $where = " (1=1) AND PersonType <> 3 "; $whereParam = array(); $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "" && $_REQUEST['JobH'] != 1) { switch ($field) { case "title": $where .= " AND title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "job_id": $where .= " AND job_id = :qry "; $whereParam[":qry"] = $_GET["query"]; break; } } if (isset($_REQUEST["query"]) && $_REQUEST["query"] != "" && $_REQUEST['JobH'] == 1) { $where .= " AND title LIKE :qry "; $whereParam = array(":qry" => "%" . $_REQUEST["query"] . "%"); } $where .= dataReader::makeOrder(); $temp = manage_Job::GetAll($where, $whereParam); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectPersons() { $where = "p.IsActive in ('YES','PENDING')"; $param = array(); if (!empty($_REQUEST["UserType"])) { switch ($_REQUEST["UserType"]) { case "IsAgent": $where .= " AND IsAgent='YES'"; break; case "IsCustomer": $where .= " AND IsCustomer='YES'"; break; case "IsStaff": $where .= " AND IsStaff='YES'"; break; case "IsSupporter": $where .= " AND IsSupporter='YES'"; break; case "IsExpert": $where .= " AND IsExpert='YES'"; break; } } if (!empty($_REQUEST["UserTypes"])) { $arr = preg_split("/,/", $_REQUEST["UserTypes"]); $where .= " AND ( 1=0 "; foreach ($arr as $r) { $where .= " OR {$r}='YES'"; } $where .= ")"; } if (isset($_REQUEST['fields']) && isset($_REQUEST['query'])) { $field = $_REQUEST['fields']; $field = $_REQUEST['fields'] == "fullname" ? "concat_ws(' ',fname,lname,CompanyName)" : $field; $where .= ' and ' . $field . ' like :fld'; $_REQUEST['query'] = $_REQUEST['query'] == "*" ? "YES" : $_REQUEST['query']; $param[':fld'] = '%' . $_REQUEST['query'] . '%'; } if (!empty($_REQUEST["PersonID"])) { $where .= " AND PersonID=:p"; $param[":p"] = $_REQUEST["PersonID"]; } if (!empty($_REQUEST["query"]) && !isset($_REQUEST['fields'])) { $where .= " AND ( concat(fname,' ',lname) like :p or CompanyName like :p)"; $param[":p"] = "%" . $_REQUEST["query"] . "%"; } if (!empty($_REQUEST["IsConfirm"])) { $where .= " AND IsConfirm = :e "; $param[":e"] = $_REQUEST["IsConfirm"]; } if (!empty($_REQUEST["full"])) { $temp = BSC_persons::SelectAll($where . dataReader::makeOrder(), $param); } else { $temp = BSC_persons::MinSelect($where . dataReader::makeOrder(), $param); } $no = $temp->rowCount(); $temp = PdoDataAccess::fetchAll($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function SelectAllWarrentyRequests() { $param = array(); $where = "1=1 "; if (!empty($_REQUEST["RequestID"])) { $where .= " AND RequestID=:r"; $param[":r"] = $_REQUEST["RequestID"]; } $param = array(); if (isset($_REQUEST['fields']) && isset($_REQUEST['query'])) { $field = $_REQUEST['fields']; $field = $field == "fullname" ? "concat_ws(' ',fname,lname,CompanyName)" : $field; $where .= ' and ' . $field . ' like :fld'; $param[':fld'] = '%' . $_REQUEST['query'] . '%'; } if (!empty($_REQUEST["IsEnded"])) { $where .= " AND StatusID = :e "; $param[":e"] = WAR_STEPID_END; } $dt = WAR_requests::SelectAll($where, $param, dataReader::makeOrder()); //print_r(ExceptionHandler::PopAllExceptions()); //echo PdoDataAccess::GetLatestQueryString(); $count = $dt->rowCount(); $dt = PdoDataAccess::fetchAll($dt, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($dt, $count, $_GET["callback"]); die; }
function selectUsers() { $query = "\r\n select distinct s.UserID,p.pfname,plname\r\n from UsersSystems as s\r\n join AccountSpecs a on(s.UserID=a.WebUserID)\r\n join persons p on(p.PersonID=a.PersonID)\r\n where SysCode in (" . PersonalSystemCode . "," . SalarySystemCode . ") AND UserSystemStatus <> 'DELETE' "; $whereParam = array(); if (!empty($_GET["fields"]) && !empty($_GET["query"])) { switch ($_GET["fields"]) { case "UserID": $query .= " AND s.UserID like :userid"; $whereParam[":userid"] = "%" . $_GET["query"] . "%"; break; case "pfname": $query .= " AND p.pfname like :pfname"; $whereParam[":pfname"] = "%" . $_GET["query"] . "%"; break; case "plname": $query .= " AND p.plname like :plname"; $whereParam[":plname"] = "%" . $_GET["query"] . "%"; break; } } $dt = PdoDataAccess::runquery($query . dataReader::makeOrder(), $whereParam); $no = count($dt); $dt = array_slice($dt, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($dt, $no, $_GET["callback"]); die; }
function selectAll() { $temp = manage_salary_params::GetAll($_GET["person_type"], $_GET["param_type"], dataReader::makeOrder()); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function Searchbank() { $where = dataReader::makeOrder(); $temp = manage_bank::GetAll($where); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function searchcostCenterItm() { $where = dataReader::makeOrder(); $temp = manage_cost_center_exception::GetAll($where); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function searchSITR() { $where = dataReader::makeOrder(); $temp = manage_salary_item_report::GetAll($where); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectAll() { $where = 'where ( 1=1 )'; $where .= dataReader::makeOrder(); $temp = manage_tax_table_types::GetAll($where); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectAll() { $where = " pe.staff_id = :staff_id "; $whereParam = array(); $whereParam[":staff_id"] = $_POST["staff_id"]; $where .= dataReader::makeOrder(); $temp = manage_professor_exe_posts::GetAll($where, $whereParam); echo dataReader::getJsonData($temp, count($temp), $_GET["callback"]); die; }
function selectbanchs() { $where = " sfid =" . $_GET['sfid']; $where .= dataReader::makeOrder(); $temp = manage_study_branch::GetAll($where); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function SelectAllLetter() { $where = "1=1"; $param = array(); foreach ($_POST as $field => $value) { if ($field == "excel" || empty($value) || strpos($field, "inputEl") !== false) { continue; } $prefix = ""; switch ($field) { case "PersonID": $prefix = "l."; break; case "Customer": $prefix = "lc."; break; case "LetterID": case "LetterTitle": $prefix = "l."; break; case "FromSendDate": case "FromLetterDate": case "ToSendDate": case "ToLetterDate": $value = DateModules::shamsi_to_miladi($value, "-"); break; } if ($field == "FromPersonID" || $field == "ToPersonID") { $where .= " AND s." . $field . " = :{$field}"; $param[":{$field}"] = $value; } else { if (strpos($field, "From") === 0) { $where .= " AND " . $prefix . substr($field, 4) . " >= :{$field}"; $param[":{$field}"] = $value; } else { if (strpos($field, "To") === 0) { $where .= " AND " . $prefix . substr($field, 2) . " <= :{$field}"; $param[":{$field}"] = $value; } else { $where .= " AND " . $prefix . $field . " like :{$field}"; $param[":{$field}"] = "%" . $value . "%"; } } } } //echo $where; //print_r($param); $list = OFC_letters::FullSelect($where, $param, dataReader::makeOrder()); print_r(ExceptionHandler::PopAllExceptions()); //echo PdoDataAccess::GetLatestQueryString(); $no = $list->rowCount(); $list = PdoDataAccess::fetchAll($list, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($list, $no, $_GET['callback']); die; }
function SearchHistoryJob() { $where = " PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $no = manage_person_job::CountPersonJob($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_job::GetAllPersonJob($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectDev() { $where = " d.PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; /* $field = isset ( $_GET ["fields"] ) ? $_GET ["fields"] : ""; if (isset ( $_GET ["query"] ) && $_GET ["query"] != "") { switch ( $field) { case "Title" : $where .= " AND Title LIKE :qry " ; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "enlisted" : $where .= " AND enlisted = :qry1 " ; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "from_date" : $where .= " AND from_date = :qry1 " ; $whereParam[":qry1"] = $_GET["query"]; break; case "to_date" : $where .= " AND to_date = :qry1 " ; $whereParam[":qry1"] = $_GET["query"]; break; case "amount" : $where .= " AND amount = :qry1 " ; $whereParam[":qry1"] = $_GET["query"]; break; case "war_place" : $where .= " AND war_place LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; } } */ $no = manage_person_devotion::CountDevotion($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_devotion::GetAllDevotions($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectAll() { $where = " where (1=1)"; if ($_GET["tax_table_type_id"] != "") { $where .= " AND tax_table_type_id=:ttid "; $whereParam[":ttid"] = $_GET["tax_table_type_id"]; } $where .= dataReader::makeOrder(); $temp = manage_Tax_Table::GetAll($_GET["tax_table_type_id"], $where, $whereParam); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectEduc() { $where = " pe.PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "fname": $where .= " AND fname LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "lname": $where .= " AND lname LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "birth_date": $where .= " AND birth_date = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "idcard_no": $where .= " AND idcard_no = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "father_name": $where .= " AND Fname LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "Title": $where .= " AND Title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "insure_type": // شماره بیمه $where .= " AND insure_type LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; } } $no = manage_person_education::CountEducation($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_education::GetAllEducations($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function selectEmp() { $where = " eh.PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "organization": $where .= " AND organization LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "unit": $where .= " AND unit LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "from_date": $where .= " AND from_date = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "to_date": $where .= " AND to_date = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "org_title": $where .= " AND org_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "unempTitle": $where .= " AND unempTitle = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "title": $where .= " AND title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; } } $no = manage_person_employment::CountEmp($where, $whereParam); $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $temp = manage_person_employment::GetAllEmp($where, $whereParam); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function GetAllRequests() { $where = ""; $param = array(); if (!empty($_REQUEST["fields"]) && !empty($_GET["query"])) { $field = $_REQUEST["fields"] == "fullname" ? "concat(p1.fname,' ',p1.lname)" : $_REQUEST["fields"]; $where .= " AND\t" . $field . " like :q"; $param[":q"] = "%" . $_GET["query"] . "%"; } if (isset($_REQUEST["AllReqs"]) && $_REQUEST["AllReqs"] == "false") { $where .= " AND IsArchive='NO'"; } $dt = ATN_requests::Get($where . dataReader::makeOrder(), $param); //print_r(ExceptionHandler::PopAllExceptions()); $result = PdoDataAccess::fetchAll($dt, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($result, $dt->rowCount(), $_GET["callback"]); die; }
function SelectContracts() { $where = ""; $params = array(); if (!empty($_REQUEST["ContractID"])) { $where .= " AND ContractID=:c"; $params[":c"] = $_REQUEST["ContractID"]; } $temp = CNT_contracts::Get(isset($_REQUEST["content"]), $where, $params, dataReader::makeOrder()); $res = PdoDataAccess::fetchAll($temp, $_GET['start'], $_GET['limit']); for ($i = 0; $i < count($res); $i++) { $arr = WFM_FlowRows::GetFlowInfo(2, $res[$i]["ContractID"]); $res[$i]["IsStarted"] = $arr["IsStarted"] ? "YES" : "NO"; $res[$i]["IsEnded"] = $arr["IsEnded"] ? "YES" : "NO"; $res[$i]["StepDesc"] = $arr["StepDesc"]; } echo dataReader::getJsonData($res, $temp->rowCount(), $_GET["callback"]); die; }
function selectBases() { $where = " (1=1) "; $whereParam = array(); $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "title": $where .= " AND title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "BaseValue": $where .= " AND BaseValue = :qry "; $whereParam[":qry"] = $_GET["query"]; break; case "typeName": $where .= " AND i.Title like :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "fullName": $where .= " AND concat(pfname,' ',plname) like :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "ExecuteDate": $where .= " AND ExecuteDate = :qry "; $whereParam[":qry"] = DateModules::shamsi_to_miladi($_GET["query"]); break; } } $where .= dataReader::makeOrder(); $temp = manage_bases::GetAll($where, $whereParam); $no = count($temp); $temp = array_slice($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
function SelectMyPlans() { $param = array($_SESSION["USER"]["PersonID"]); $where = "p.PersonID=?"; $dt = PLN_plans::SelectAll($where, $param, dataReader::makeOrder()); print_r(ExceptionHandler::PopAllExceptions()); //echo PdoDataAccess::GetLatestQueryString(); $count = $dt->rowCount(); $dt = PdoDataAccess::fetchAll($dt, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($dt, $count, $_GET["callback"]); die; }
static function SelectSendedLetters($where = "", $param = array()) { $query = "select s.*,l.*, \n\t\t\t\tconcat_ws(' ',fname, lname,CompanyName) ToPersonName,\n\t\t\t\tif(count(DocumentID) > 0,'YES','NO') hasAttach,\n\t\t\t\tsubstr(s.SendDate,1,10) _SendDate\n\t\t\tfrom OFC_send s\n\t\t\t\tjoin OFC_letters l using(LetterID)\n\t\t\t\tjoin BSC_persons p on(s.ToPersonID=p.PersonID)\n\t\t\t\tleft join DMS_documents on(ObjectType='letterAttach' AND ObjectID=s.LetterID)\n\t\t\twhere FromPersonID=:fpid " . $where . "\n\t\t\tgroup by SendID\n\t\t"; $param[":fpid"] = $_SESSION["USER"]["PersonID"]; $query .= dataReader::makeOrder(); return PdoDataAccess::runquery_fetchMode($query, $param); }
function GetAllHolidays() { $where = ""; $whereParam = array(); if (!empty($_REQUEST["Year"])) { $year = $_REQUEST["Year"]; $StartDate = DateModules::shamsi_to_miladi($year . "-01-01", "-"); $EndDate = DateModules::shamsi_to_miladi($year . "-12-" . DateModules::DaysOfMonth($year, 12), "-"); $where .= " AND TheDate between ? AND ?"; $whereParam[] = $StartDate; $whereParam[] = $EndDate; } $temp = ATN_holidays::Get($where . dataReader::makeOrder(), $whereParam); echo dataReader::getJsonData($temp->fetchAll(), $temp->rowCount(), $_GET["callback"]); die; }
function selectWrtData() { $where = ""; $whereParam = array(); MakeAdvanceSearchWhere($where, $whereParam); $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "PersonID": $where .= " AND p.PersonID = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "writ_id": $where .= " AND w.writ_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "writ_ver": $where .= " AND w.writ_ver = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "fullname": $where .= " AND fullname LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "staff_id": $where .= " AND w.staff_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "org_title": $where .= " AND org_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "wt_title": $where .= " AND wt_title LIKE :qry "; $whereParam[":qry"] = $_GET["query"]; break; case "emp_state_title": $where .= " AND emp_state_title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "execute_date": $where .= " AND w.execute_date = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "history_only_title": $where .= " AND history_only_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "corrective_title": $where .= " AND corrective_title = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "corrective_writ_id": $where .= " AND corrective_writ_id = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; case "mablagh": $where .= " AND mablagh = :qry1 "; $whereParam[":qry1"] = $_GET["query"]; break; } } $temp = manage_writ::GetAllWrits($where . dataReader::makeOrder(), $whereParam); $no = $temp->rowCount(); $temp = PdoDataAccess::fetchAll($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); // echo PdoDataAccess::GetLatestQueryString(); die; }
function SelectAllForms() { $where = "1=1"; $param = array(); $ObjectDesc = "case f.FlowID \r\n\t\t\twhen 1 then concat_ws(' ','وام شماره',lp.RequestID,'به مبلغ',\r\n\t\t\t\tPartAmount,'مربوط به',if(pp.IsReal='YES',concat(pp.fname, ' ', pp.lname),pp.CompanyName))\r\n\t\t\t\t\r\n\t\t\twhen 4 then concat_ws(' ','ضمانت نامه', wp.CompanyName,wp.fname,wp.lname, 'به مبلغ ',wr.amount)\r\n\t\t\t\r\n\t\tend"; if (!empty($_GET["fields"]) && !empty($_GET["query"])) { $field = $_GET["fields"] == "ObjectDesc" ? $ObjectDesc : $_GET["fields"]; $field = $_GET["fields"] == "StepDesc" ? "ifnull(fs.StepDesc,'شروع گردش')" : $field; $where .= " AND {$field} like :fld"; $param[":fld"] = "%" . $_GET["query"] . "%"; } //----------------- received forms ---------------------- if (!empty($_GET["MyForms"]) && $_GET["MyForms"] == "true") { $dt = PdoDataAccess::runquery("select FlowID,StepID \r\n\t\t\tfrom WFM_FlowSteps s \r\n\t\t\tleft join BSC_persons p using(PostID)\r\n\t\t\twhere s.IsActive='YES' AND if(s.PersonID>0,s.PersonID=:pid,p.PersonID=:pid)", array(":pid" => $_SESSION["USER"]["PersonID"])); if (count($dt) == 0) { echo dataReader::getJsonData(array(), 0, $_GET["callback"]); die; } $where .= " AND fr.IsEnded='NO' AND ("; foreach ($dt as $row) { $preStep = $row["StepID"] * 1 - 1; $nextStep = $row["StepID"] * 1 + 1; $where .= "(fr.FlowID=" . $row["FlowID"] . " AND fs.StepID" . ($preStep == 0 ? " is null" : "=" . $preStep) . " AND ActionType='CONFIRM') OR (fr.FlowID=" . $row["FlowID"] . " AND fs.StepID=" . $nextStep . " AND ActionType='REJECT') OR"; } $where = substr($where, 0, strlen($where) - 2) . ")"; } //-------------------------------------------------------- $query = "select fr.*,f.FlowDesc, \r\n\t\t\t\t\tb.InfoDesc ObjectTypeDesc,\r\n\t\t\t\t\tifnull(fr.StepDesc,'شروع گردش') StepDesc,\r\n\t\t\t\t\tif(p.IsReal='YES',concat(p.fname, ' ',p.lname),p.CompanyName) fullname,\r\n\t\t\t\t\t{$ObjectDesc} ObjectDesc,\r\n\t\t\t\t\tb.param1 url,\r\n\t\t\t\t\tb.param2 parameter\r\n\t\t\t\tfrom WFM_FlowRows fr\r\n\t\t\t\tjoin ( select max(RowID) RowID,FlowID,ObjectID from WFM_FlowRows group by FlowID,ObjectID )t\r\n\t\t\t\t\tusing(RowID,FlowID,ObjectID)\r\n\t\t\t\tjoin WFM_flows f using(FlowID)\r\n\t\t\t\tjoin BaseInfo b on(b.TypeID=11 AND b.InfoID=f.ObjectType)\r\n\t\t\t\tleft join WFM_FlowSteps fs on(fr.StepRowID=fs.StepRowID)\r\n\t\t\t\tjoin BSC_persons p on(fr.PersonID=p.PersonID)\r\n\t\t\t\t\r\n\t\t\t\tleft join LON_ReqParts lp on(fr.FlowID=1 AND fr.ObjectID=PartID)\r\n\t\t\t\tleft join LON_requests lr on(lp.RequestID=lr.RequestID)\r\n\t\t\t\tleft join BSC_persons pp on(lr.LoanPersonID=pp.PersonID)\r\n\t\r\n\t\t\t\tleft join WAR_requests wr on(fr.FlowID=4 AND wr.RequestID=fr.ObjectID)\r\n\t\t\t\tleft join BaseInfo bf on(bf.TypeID=74 AND bf.InfoID=wr.TypeID)\r\n\t\t\t\tleft join BSC_persons wp on(wp.PersonID=wr.PersonID)\r\n\r\n\t\t\t\twhere " . $where . dataReader::makeOrder(); $temp = PdoDataAccess::runquery_fetchMode($query, $param); //echo PdoDataAccess::GetLatestQueryString(); $no = $temp->rowCount(); $temp = PdoDataAccess::fetchAll($temp, $_GET["start"], $_GET["limit"]); echo dataReader::getJsonData($temp, $no, $_GET["callback"]); die; }
static function SelectReceivedForms($where = "", $params = array()) { $dt = PdoDataAccess::runquery("select FlowID,StepID \n\t\t\tfrom WFM_FlowSteps s \n\t\t\tleft join BSC_persons p using(PostID)\n\t\t\twhere s.IsActive='YES' AND if(s.PersonID>0,s.PersonID=:pid,p.PersonID=:pid)", array(":pid" => $_SESSION["USER"]["PersonID"])); if (count($dt) == 0) { return array(); } $where .= " AND fr.IsEnded='NO' AND ("; foreach ($dt as $row) { $preStep = $row["StepID"] * 1 - 1; $nextStep = $row["StepID"] * 1 + 1; $where .= "(fr.FlowID=" . $row["FlowID"] . " AND fs.StepID" . ($preStep == 0 ? " is null" : "=" . $preStep) . " AND ActionType='CONFIRM') OR (fr.FlowID=" . $row["FlowID"] . " AND fs.StepID=" . $nextStep . " AND ActionType='REJECT') OR"; } $where = substr($where, 0, strlen($where) - 2) . ")"; //-------------------------------------------------------- $query = "select fr.*,f.FlowDesc, \n\t\t\t\t\t\tb.InfoDesc ObjectTypeDesc,\n\t\t\t\t\t\tifnull(fr.StepDesc,'شروع گردش') StepDesc,\n\t\t\t\t\t\tif(p.IsReal='YES',concat(p.fname, ' ',p.lname),p.CompanyName) fullname,\n\t\t\t\t\t\tb.param1 url,\n\t\t\t\t\t\tb.param2 parameter\n\t\t\t\t\tfrom WFM_FlowRows fr\n\t\t\t\t\tjoin ( select max(RowID) RowID,FlowID,ObjectID from WFM_FlowRows group by FlowID,ObjectID )t\n\t\t\t\t\t\tusing(RowID,FlowID,ObjectID)\n\t\t\t\t\tjoin WFM_flows f using(FlowID)\n\t\t\t\t\tjoin BaseInfo b on(b.TypeID=11 AND b.InfoID=f.ObjectType)\n\t\t\t\t\tleft join WFM_FlowSteps fs on(fr.StepRowID=fs.StepRowID)\n\t\t\t\t\tjoin BSC_persons p on(fr.PersonID=p.PersonID)\n\n\t\t\t\t\tleft join LON_ReqParts lp on(fr.ObjectID=PartID)\n\t\t\t\t\tleft join LON_requests lr on(lp.RequestID=lr.RequestID)\n\t\t\t\t\tleft join BSC_persons pp on(lr.LoanPersonID=pp.PersonID)\n\n\t\t\t\t\twhere 1=1 " . $where . dataReader::makeOrder(); return PdoDataAccess::runquery_fetchMode($query, $params); }
function GetAccountFlow() { $CostID = $_REQUEST["BaseCostID"]; $TafsiliID = $_REQUEST["TafsiliID"]; $query = "select d.*,di.*\n\t\tfrom ACC_DocItems di\n\t\t\tjoin ACC_docs d using(DocID)\n\t\twhere d.CycleID=:c AND d.BranchID=:b AND \n\t\t\tdi.CostID=:cost AND di.TafsiliType = :t AND di.TafsiliID=:tid " . dataReader::makeOrder(); $param = array(":c" => $_SESSION["accounting"]["CycleID"], ":b" => $_SESSION["accounting"]["BranchID"], ":cost" => $CostID, ":t" => TAFTYPE_PERSONS, ":tid" => $TafsiliID); $temp = PdoDataAccess::runquery_fetchMode($query, $param); $no = $temp->rowCount(); //------------------------------------------------ $BlockedAmount = ACC_CostBlocks::GetBlockAmount($CostID, TAFTYPE_PERSONS, $TafsiliID); //------------------------------------------------ echo dataReader::getJsonData($temp->fetchAll(), $no, $_GET["callback"], $BlockedAmount); die; }
function selectCourse() { $where = " pc.PersonID = :PID "; $whereParam = array(); $whereParam[":PID"] = $_GET["Q0"]; $field = isset($_GET["fields"]) ? $_GET["fields"] : ""; if (isset($_GET["query"]) && $_GET["query"] != "") { switch ($field) { case "title": $where .= " AND pc.title LIKE :qry "; $whereParam[":qry"] = "%" . $_GET["query"] . "%"; break; case "from_date": $where .= " AND from_date = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "to_date": $where .= " AND to_date = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "related_Title": $where .= " AND related_Title = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "internal_Title": $where .= " AND internal_Title = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; case "total_hours": $where .= " AND total_hours = :qry1 "; $whereParam[":qry1"] = "%" . $_GET["query"] . "%"; break; } } $query = " SELECT count(*) \n\t\t FROM person_courses pc\n\t\t\t where 1=1"; $query .= $where != "" ? " AND " . $where : ""; $temp = PdoDataAccess::runquery($query, $whereParam); $no = $temp[0][0]; $where .= dataReader::makeOrder(); $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : ""; $query = " SELECT pc.PersonID,\n pc.group_id , \n pc.p_id , \n pc.title title,\n pc.course_id,\n pc.from_date,\n pc.to_date,\n\t\t\t\t\t pc.register_no , \n\t\t\t\t\t pc.score , \n\t\t\t\t\t pc.certficate_date ,\n if(pc.total_hours is null , 0 ,pc.total_hours ) total_hours ,\n bi1.Title related_Title,\n bi2.Title internal_Title \n \n\t\t FROM person_courses pc\n\t\t\t\t\tleft join Basic_Info bi1 on pc.related =bi1.InfoID and bi1.TypeID=5\n\t\t\t\t\tleft join Basic_Info bi2 on pc.internal =bi2.InfoID and bi2.TypeID=5\n\t\t\t\t\t\n\t\t\t where 1=1"; $query .= $where != "" ? " AND " . $where : ""; $temp = PdoDataAccess::runquery($query, $whereParam); $dt = PdoDataAccess::runquery("\n\t\t\t\t\t\t\t\t\tselect sum(total_hours) totalHrs\n\t\t\t\t\t\t\t\t\tfrom person_courses\n\t\t\t\t\t\t\t\t\twhere PersonID=? \n\t\t\t\t\t\t\t\t\t", array($_GET["Q0"])); $thSum = count($dt) != 0 ? $dt[0]["totalHrs"] : 0; echo dataReader::getJsonData($temp, $no, $_GET["callback"], $thSum); die; }
function selectDataAudits() { $query = "select \r\n\t\t\tSysName,\r\n\t\t\tconcat_ws(' ',fname,lname,CompanyName) fullname , \r\n\t\t\tMainObjectID , \r\n\t\t\tSubObjectID, \r\n\t\t\tActionType , \r\n\t\t\tActionTime, \r\n\t\t\ttable_comment\r\n\t\t\t\r\n\t\tfrom DataAudit d\r\n\t\tjoin FRW_systems using(SystemID)\r\n\t\tjoin BSC_persons using(PersonID)\r\n\t\tjoin information_schema.TABLES on(Table_schema = 'krrtfir_rtfund' AND Table_name=d.TableName)\r\n\t\t\r\n\t\twhere 1=1"; $param = array(); //------------------------------------------------------ if (!empty($_POST["PersonID"])) { $query .= " AND d.PersonID=:p"; $param[":p"] = $_POST["PersonID"]; } if (!empty($_POST["SystemID"])) { $query .= " AND d.SystemID=:s"; $param[":s"] = $_POST["SystemID"]; } if (!empty($_POST["StartDate"])) { $query .= " AND d.ActionTime>:sd"; $param[":sd"] = DateModules::shamsi_to_miladi($_POST["StartDate"], "-") . " 00:00:00"; } if (!empty($_POST["EndDate"])) { $query .= " AND d.ActionTime<:ed"; $param[":ed"] = DateModules::shamsi_to_miladi($_POST["EndDate"], "-") . " 23:59:59"; } //------------------------------------------------------ $temp = PdoDataAccess::runquery_fetchMode($query . dataReader::makeOrder(), $param); //print_r(ExceptionHandler::PopAllExceptions()); //echo PdoDataAccess::GetLatestQueryString(); $cnt = $temp->rowCount(); $temp = PdoDataAccess::fetchAll($temp, $_REQUEST["start"], $_REQUEST["limit"]); echo dataReader::getJsonData($temp, $cnt, $_GET["callback"]); die; }