public function showBatchGrid($wherestring) { global $xoopsDB, $wherestring, $xoopsUser, $isadmin; include_once "../simantz/class/EBAGetHandler.php"; $getHandler = new EBAGetHandler(); //var_dump($_GET['StartRecord']) ; $this->log->showLog(3, "Load showBatchGrid with Query String=" . $_SERVER['QUERY_STRING']); $pageSize = 10; if (isset($_GET['PageSize'])) { $pageSize = $_GET['PageSize']; if (empty($pageSize)) { $pageSize = 10; } } $ordinalStart = 0; if (isset($_GET['StartRecord'])) { $ordinalStart = $_GET['StartRecord']; if (empty($ordinalStart)) { $ordinalStart = 0; } } $sortcolumn = $_GET["SortColumn"]; $sortdirection = $_GET["SortDirection"]; $tablename = "sim_simbiz_batch"; $searchbatch_no = $_GET['searchbatch_no']; $searchbatch_name = $_GET['searchbatch_name']; $batchdatefrom = $_GET['batchdatefrom']; $batchdateto = $_GET['batchdateto']; $reusesearch = $_GET['reusesearch']; $iscompletesearch = $_GET['iscompletesearch']; if ($batchdatefrom == "") { $batchdatefrom = "0000-00-00"; } if ($batchdateto == "") { $batchdateto = "9999-12-31"; } $wherestring .= " and bt.batchdate between '{$batchdatefrom}' and '{$batchdateto}' "; if ($searchbatch_no != "") { $wherestring = $wherestring . " and bt.batchno LIKE '{$searchbatch_no}' "; } if ($reusesearch != "") { $wherestring = $wherestring . " and bt.reuse = {$reusesearch} "; } if ($iscompletesearch != "") { $wherestring = $wherestring . " and bt.iscomplete = {$iscompletesearch} "; } if ($searchbatch_name != "") { $wherestring = $wherestring . " and bt.batch_name LIKE '{$searchbatch_name}' "; } $this->log->showLog(2, "Access showBatchGrid({$wherestring})"); if (empty($sortcolumn)) { $sortcolumn = "bt.batchdate DESC,bt.batchno"; } if (empty($sortdirection)) { $sortdirection = "DESC"; } $this->log->showLog(4, "sortcolumn: {$sortcolumn}, sortdirection {$sortdirection}"); $sql = "SELECT bt.*,usr.uname\r\n FROM sim_simbiz_batch bt\r\n LEFT JOIN sim_users usr ON bt.updatedby = usr.uid\r\n {$wherestring}\r\n ORDER BY {$sortcolumn} {$sortdirection}"; $rcode = $_GET['rcode']; $_SESSION['sql_txt_' . $rcode] = $sql; $this->log->showLog(4, "showBatchGrid SQL: {$sql}"); $query = $xoopsDB->query($sql); $getHandler->ProcessRecords(); $getHandler->DefineField("seq_no"); $getHandler->DefineField("batchno"); $getHandler->DefineField("batchdate"); $getHandler->DefineField("batch_name"); $getHandler->DefineField("iscomplete"); $getHandler->DefineField("reuse"); $getHandler->DefineField("uname"); $getHandler->DefineField("totaldebit"); $getHandler->DefineField("totalcredit"); $getHandler->DefineField("operation"); $getHandler->DefineField("batch_id"); $getHandler->DefineField("rh"); $currentRecord = 0; // This will assist us finding the ordinalStart position $i = 0; $rh = "odd"; while ($row = $xoopsDB->fetchArray($query)) { if ($rh == "even") { $rh = "odd"; } else { $rh = "even"; } $currentRecord = $currentRecord + 1; if ($currentRecord > $ordinalStart) { $i++; $getHandler->CreateNewRecord($row['batch_id']); $getHandler->DefineRecordFieldValue("seq_no", $currentRecord); $getHandler->DefineRecordFieldValue("batchno", $row['batchno']); $getHandler->DefineRecordFieldValue("batchdate", $row['batchdate']); $getHandler->DefineRecordFieldValue("batch_name", $row['batch_name']); $getHandler->DefineRecordFieldValue("iscomplete", $row['iscomplete'] != "1" ? "N" : "Y"); $getHandler->DefineRecordFieldValue("reuse", $row['reuse'] != "1" ? "N" : "Y"); $getHandler->DefineRecordFieldValue("uname", $row['uname']); $getHandler->DefineRecordFieldValue("totaldebit", $row['totaldebit']); $getHandler->DefineRecordFieldValue("totalcredit", $row['totalcredit']); $getHandler->DefineRecordFieldValue("operation", "batch.php?action=edit&batch_id=" . $row['batch_id']); $getHandler->DefineRecordFieldValue("info", "../simantz/recordinfo.php?id=" . $row['batch_id'] . "&tablename=sim_simbiz_batch&idname=batch_id&title=Journal Entry"); $getHandler->DefineRecordFieldValue("batch_id", $row['batch_id']); $getHandler->DefineRecordFieldValue("rh", $rh); $getHandler->SaveRecord(); } } $getHandler->setErrorMessage($currentRecord); $getHandler->CompleteGet(); $this->log->showLog(2, "complete function showBatch()"); }
public function showApprovallistGrid($wherestring) { global $xoopsDB, $wherestring, $xoopsUser, $isadmin; include_once "../simantz/class/EBAGetHandler.php"; $getHandler = new EBAGetHandler(); //var_dump($_GET['StartRecord']) ; $this->log->showLog(3, "Load showApprovallistGrid with Query String=" . $_SERVER['QUERY_STRING']); $pageSize = 10; if (isset($_GET['PageSize'])) { $pageSize = $_GET['PageSize']; if (empty($pageSize)) { $pageSize = 10; } } $ordinalStart = 0; if (isset($_GET['StartRecord'])) { $ordinalStart = $_GET['StartRecord']; if (empty($ordinalStart)) { $ordinalStart = 0; } } $sortcolumn = $_GET["SortColumn"]; //$sortdirection=$_GET["SortDirection"]; $tablename = "sim_hr_leave"; $searchemployee_no = $_GET['searchemployee_no']; $searchemployee_name = $_GET['searchemployee_name']; $searchleave_fromdate = $_GET['searchleave_fromdate']; $searchleave_todate = $_GET['searchleave_todate']; //$searchleave_no=$_GET['searchleave_no']; $searchiscomplete = $_GET['searchiscomplete']; $searchishistory = $_GET['searchishistory']; $this->log->showLog(2, "Access ShowApprovallisttype({$wherestring})"); /* if(empty($sortcolumn)){ $sortcolumn="wt.created"; } if(empty($sortdirection)){ $sortdirection="DESC"; } $wherestring2 = " WHERE 1 "; if($searchiscomplete != "true"){ $wherestring .= " AND lv.iscomplete = '0' "; }else{ $wherestring .= " AND lv.iscomplete = '1' "; } if($searchemployee_no != ""){ $wherestring .= " AND em.employee_no LIKE '$searchemployee_no' "; $whereArray[]=$searchemployee_no; } if($searchemployee_name != ""){ $wherestring .= " AND em.employee_name LIKE '$searchemployee_name' "; $whereArray[]=$searchemployee_name; } if($searchleave_fromdate != "" && $searchleave_todate != ""){ $wherestring2 .= " AND a.apply_date BETWEEN '$searchleave_fromdate' AND '$searchleave_todate' "; } if($searchleave_no != ""){ $wherestring2 .= " AND a.doc_no LIKE '%$searchleave_no' "; } $wherestring .= " AND (wt.target_uid = $this->createdby OR $this->createdby IN (wt.targetparameter_name) OR $this->createdby IN (SELECT uid FROM sim_groups_users_link WHERE groupid = wt.target_groupid) ) "; * */ if ($searchemployee_no != "") { $wherestrapp .= " AND employee_no LIKE '%{$searchemployee_no}%' "; } if ($searchemployee_name != "") { $wherestrapp .= " AND employee_name LIKE '%{$searchemployee_name}%' "; } if ($searchemployee_name != "" || $searchemployee_no != "") { $sql = "select employee_id from sim_hr_employee where employee_id>0 {$wherestrapp}"; $this->log->showLog(4, "Fetchappraisal With SQL: {$sql}"); $query = $xoopsDB->query($sql); $i = 0; $arremployee_id = ""; while ($row = $xoopsDB->fetchArray($query)) { $i++; $employee_id = $row['employee_id']; $arremployee_id .= ",'{$employee_id}'"; } $arremployee_id = substr($arremployee_id, 1); $wherestring .= " and emp.employee_id in ({$arremployee_id}) "; } if ($searchleave_fromdate != "" && $searchleave_todate != "") { $wherestring .= " AND wt.workflowtransaction_datetime BETWEEN '{$searchleave_fromdate}' AND '{$searchleave_todate}' "; } $wherestring .= " AND (wt.target_uid = {$this->createdby} OR wt.targetparameter_name LIKE concat('%[',{$this->createdby},']%') " . " OR {$this->createdby} IN (SELECT uid FROM sim_groups_users_link WHERE groupid = wt.target_groupid)) "; // $wherestring .= " AND wt.iscomplete = 0 "; if ($searchiscomplete != "true") { $wherestring .= " AND wt.iscomplete = '0' "; } else { $wherestring .= " AND wt.iscomplete = '1' "; } $sql = "SELECT wt.*, emp.employee_name, emp.employee_no, emp.employee_id," . " wf.workflow_name,ws.workflowstatus_name,wt.workflowtransaction_description " . " FROM sim_workflowtransaction wt " . " LEFT JOIN sim_hr_employee emp ON wt.person_id = emp.employee_id " . " INNER JOIN sim_workflow wf ON wt.workflow_id = wf.workflow_id " . " INNER JOIN sim_workflowstatus ws ON wt.workflowstatus_id = ws.workflowstatus_id " . " {$wherestring} ORDER BY wt.created DESC"; // GROUP BY wt.tablename, wt.primarykey_name, wt.primarykey_value //ORDER BY " . $sortcolumn . " " . $sortdirection ." "; $this->log->showLog(4, "showApprovallistGrid SQL: {$sql}"); $query = $xoopsDB->query($sql); $getHandler->ProcessRecords(); $getHandler->DefineField("seq_no"); $getHandler->DefineField("workflow_name"); $getHandler->DefineField("workflowstatus_name"); $getHandler->DefineField("tablename"); $getHandler->DefineField("primarykey_name"); $getHandler->DefineField("primarykey_value"); $getHandler->DefineField("window_workflow"); $getHandler->DefineField("workflow_name"); $getHandler->DefineField("employee_name"); $getHandler->DefineField("apply_date"); $getHandler->DefineField("doc_no"); $getHandler->DefineField("person_id"); $getHandler->DefineField("hyperlink"); $getHandler->DefineField("workflowstatus_name"); $getHandler->DefineField("workflowtransaction_description"); //$getHandler->DefineField("completeleave"); $getHandler->DefineField("rh"); $currentRecord = 0; // This will assist us finding the ordinalStart position $i = 0; while ($row = $xoopsDB->fetchArray($query)) { $issubmit = $row['issubmit']; if ($searchiscomplete == "true") { $issubmit = 1; } if ($issubmit == 1) { $currentRecord = $currentRecord + 1; if ($currentRecord > $ordinalStart) { if ($rh == "even") { $rh = "odd"; } else { $rh = "even"; } $i++; $getHandler->CreateNewRecord($row['workflowtransaction_id']); $getHandler->DefineRecordFieldValue("seq_no", $currentRecord); $getHandler->DefineRecordFieldValue("workflow_name", $row['workflow_name']); $getHandler->DefineRecordFieldValue("tablename", $row['tablename']); $getHandler->DefineRecordFieldValue("primarykey_name", $row['primarykey_name']); $getHandler->DefineRecordFieldValue("primarykey_value", $row['primarykey_value']); $getHandler->DefineRecordFieldValue("window_workflow", $row['window_workflow']); $getHandler->DefineRecordFieldValue("workflowstatus_name", $row['workflowstatus_name']); //$this->getWorkflowTransactionStatus($row['workflowtransaction_id']) $getHandler->DefineRecordFieldValue("employee_name", $row['employee_name'] . " - " . $row['employee_no']); $getHandler->DefineRecordFieldValue("apply_date", $row['created']); $getHandler->DefineRecordFieldValue("doc_no", $row['doc_no']); $getHandler->DefineRecordFieldValue("person_id", $row['person_id']); $getHandler->DefineRecordFieldValue("hyperlink", $row['hyperlink']); $getHandler->DefineRecordFieldValue("workflowstatus_name", $row['workflowstatus_name']); $getHandler->DefineRecordFieldValue("workflowtransaction_description", $row['workflowtransaction_description']); //$getHandler->DefineRecordFieldValue("iscomplete",($row['completeleave'] == 1 ? "Yes" : "No")); $getHandler->DefineRecordFieldValue("operation", "images/docicon.gif"); $getHandler->DefineRecordFieldValue("approval", "images/approval.gif"); $getHandler->DefineRecordFieldValue("workflowtransaction_id", $row['workflowtransaction_id']); $getHandler->DefineRecordFieldValue("rh", $rh); $getHandler->SaveRecord(); } } } $getHandler->setErrorMessage($currentRecord); $getHandler->CompleteGet(); $this->log->showLog(2, "complete function showApprovallist()"); }
public function showSearchResult($wherestring) { include_once "../simantz/class/EBAGetHandler.php"; $getHandler = new EBAGetHandler(); $this->log->showLog(3, "Load Grid with Query String=" . $_SERVER['QUERY_STRING']); global $xoopsDB, $wherestring, $xoopsUser, $isadmin, $defaultorganization_id; $pageSize = 10; if (isset($_GET['PageSize'])) { $pageSize = $_GET['PageSize']; if (empty($pageSize)) { $pageSize = 10; } } $ordinalStart = 0; if (isset($_GET['StartRecord'])) { $ordinalStart = $_GET['StartRecord']; if (empty($ordinalStart)) { $ordinalStart = 0; } } $sortcolumn = $_GET["SortColumn"]; $sortdirection = $_GET["SortDirection"]; $tablename = "sim_bpartner"; $tablebpartnergroup = "sim_bpartnergroup"; $tableindustry = "sim_industry"; $issearch = $_GET['issearch']; $searchbpartner_no = $_GET['searchbpartner_no']; $searchbpartner_name = $_GET['searchbpartner_name']; $searchbpartnergroup_id = $_GET['searchbpartnergroup_id']; $searchindustry_id = $_GET['searchindustry_id']; $searchpic = $_GET['searchpic']; $searchisactive = $_GET['searchisactive']; $searchchar = $_GET['searchchar']; $this->log->showLog(2, "Access ShowBPartner({$wherestring})"); if (empty($sortcolumn)) { $sortcolumn = "bp.seqno, bp.bpartner_name"; } if (empty($sortdirection)) { $sortdirection = "ASC"; } // if($searchchar !=""){ // $wherestring.= " AND a.employee_name LIKE '".$searchchar."%'"; // } if ($searchchar != "") { $wherestring .= " AND bp.bpartner_name LIKE '" . $searchchar . "%'"; } else { if ($searchbpartner_no != "") { $wherestring .= " AND bp.bpartner_no LIKE '%" . $searchbpartner_no . "%'"; } if ($searchbpartner_name != "") { $wherestring .= " AND bp.bpartner_name LIKE '%" . $searchbpartner_name . "%'"; } if ($searchpic != "") { $wherestring .= " AND bp.inchargeperson LIKE '%" . $searchpic . "%'"; } if ($searchbpartnergroup_id != "" && $searchbpartnergroup_id != "0") { $wherestring .= " AND bp.bpartnergroup_id={$searchbpartnergroup_id}"; } if ($searchindustry_id != "" && $searchindustry_id != "0") { $wherestring .= " AND bp.industry_id={$searchindustry_id}"; } if ($searchisactive == "Y") { $wherestring .= " AND bp.isactive=1"; } else { if ($searchisactive == "N") { $wherestring .= " AND bp.isactive=0"; } else { if ($searchisactive != "0") { // not show result $wherestring .= " AND bp.isactive='{$searchisactive}'"; } } } } $wherestring .= " AND bp.organization_id={$defaultorganization_id}"; $sql = "SELECT bp.*, bpg.bpartnergroup_name, terms_name\r\n FROM {$tablename} bp\r\n inner join sim_bpartnergroup bpg on bpg.bpartnergroup_id = bp.bpartnergroup_id\r\n left join sim_terms te on te.terms_id = bp.terms_id\r\n\r\n {$wherestring} ORDER BY " . $sortcolumn . " " . $sortdirection . ";"; $rcode = $_GET['rcode']; $_SESSION['sql_txt_' . $rcode] = $sql; $this->log->showLog(4, "With SQL: {$sql}"); $query = $xoopsDB->query($sql); $getHandler->ProcessRecords(); $getHandler->DefineField("bpartner_no"); $getHandler->DefineField("bpartner_name"); $getHandler->DefineField("bpartnergroup_name"); $getHandler->DefineField("terms_name"); $getHandler->DefineField("shortremarks"); $getHandler->DefineField("isactive"); $getHandler->DefineField("edit"); $getHandler->DefineField("inchargeperson"); $getHandler->DefineField("bpartner_id"); $getHandler->DefineField("rh"); $getHandler->DefineField("gridlink"); $currentRecord = 0; // This will assist us finding the ordinalStart position $rh = "odd"; while ($row = $xoopsDB->fetchArray($query)) { if ($rh == "even") { $rh = "odd"; } else { $rh = "even"; } $gridlink = "gridlink {$rh}"; $currentRecord = $currentRecord + 1; if ($currentRecord > $ordinalStart) { $getHandler->CreateNewRecord($row['bpartner_id']); $getHandler->DefineRecordFieldValue("bpartner_no", $row['bpartner_no']); $getHandler->DefineRecordFieldValue("bpartner_name", $row['bpartner_name']); $getHandler->DefineRecordFieldValue("bpartnergroup_name", $row['bpartnergroup_name']); $getHandler->DefineRecordFieldValue("terms_name", $row['terms_name']); $getHandler->DefineRecordFieldValue("shortremarks", $row['shortremarks']); $getHandler->DefineRecordFieldValue("inchargeperson", $row['inchargeperson']); $getHandler->DefineRecordFieldValue("isactive", $row['isactive'] == 1 ? "Yes" : "No"); $getHandler->DefineRecordFieldValue("edit", "bpartner.php?action=viewsummary&bpartner_id=" . $row['bpartner_id']); $getHandler->DefineRecordFieldValue("bpartner_id", $row['bpartner_id']); $getHandler->DefineRecordFieldValue("rh", $rh); $getHandler->DefineRecordFieldValue("gridlink", $gridlink); $getHandler->SaveRecord(); } } $getHandler->setErrorMessage($currentRecord); $getHandler->CompleteGet(); $this->log->showLog(2, "complete function showBpartner()"); }