예제 #1
0
 /**
  * 
  * @param type $reqid
  * @return string
  */
 public function requisitionhistoryreportdetail_ApprovalsGrid($reqid)
 {
     $sort_order = 'DESC';
     $sort_field = 'c.createdon';
     $perPage = 100;
     $pageNo = 1;
     $searchData = '';
     $where = '';
     $searchQuery = 'requisition_id = ' . $reqid;
     $searchArray = array();
     $data = array();
     $tableFields = array('approvalreq_status' => 'Approval Status', 'approvaluserfullname' => 'Approved By', 'approvalcreatedon' => 'Approved On');
     $requi_model = new Default_Model_Requisition();
     $tablecontent = $requi_model->getrequisitionAppovalHistory($sort_order, $sort_field, $pageNo, $perPage, $searchQuery);
     $dataTmp = array('sort' => $sort_order, 'by' => $sort_field, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'tableheader' => $tableFields);
     return $dataTmp;
 }