/**
*
* @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;
}
