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()");
}
