Esempio n. 1
0
 /**
  * 
  * @param type $reqid
  * @return type
  */
 public function requisitionhistoryreportdetail_RequisitionEmailsGrid($reqid)
 {
     $sort_order = 'DESC';
     $sort_field = 'c.id';
     $perPage = 100;
     $pageNo = 1;
     $searchData = '';
     $where = '';
     $searchArray = array();
     $data = array();
     $tableFields = array('requisitionemailid' => '#', 'requisitionemailtoemail' => 'Email Address', 'requisitionemailtoname' => 'Recipient', 'requisitionemailemailsubject' => 'Subject', 'requisitionemailheader' => 'Group', 'requisitionemailcreateddate' => 'Sent On');
     $requi_model = new Default_Model_Requisition();
     $req_cod = $requi_model->getRequisitionCodeByID($reqid);
     $searchQuery = "message like '%" . $req_cod['requisition_code'] . "%'";
     $tablecontent = $requi_model->getrequisitionEmailHistory($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;
 }