public function listTemplate() { if (!Request::ajax()) { return App::abort(404); } $start = Input::has('start') ? (int) Input::get('start') : 0; $length = Input::has('length') ? Input::get('length') : 10; $search = Input::has('search') ? Input::get('search') : []; $emailTemplates = EmailTemplate::select('id', 'name', 'type', 'active'); if (!empty($search)) { foreach ($search as $key => $value) { if (empty($value)) { continue; } if ($key == 'active') { if ($value == 'yes') { $value = 1; } else { $value = 0; } $emailTemplates->where($key, $value); } else { $value = ltrim(rtrim($value)); $emailTemplates->where($key, 'like', '%' . $value . '%'); } } } $order = Input::has('order') ? Input::get('order') : []; if (!empty($order)) { $columns = Input::has('columns') ? Input::get('columns') : []; foreach ($order as $value) { $column = $value['column']; if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) { continue; } $emailTemplates->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc'); } } $count = $emailTemplates->count(); if ($length > 0) { $emailTemplates = $emailTemplates->skip($start)->take($length); } $arrTemplates = $emailTemplates->get()->toArray(); $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => EmailTemplate::count(), 'recordsFiltered' => $count, 'data' => []]; if (!empty($arrTemplates)) { foreach ($arrTemplates as $template) { $arrReturn['data'][] = array(++$start, $template['id'], $template['name'], $template['type'], $template['active']); } } $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; }
} /** This is for Check Duplicate Record-------------------------------------------*/ $generalobj->getRequestVars(); $redirect_file = "index.php?file={$file}&view={$view}&iFormatId={$iFormatId}"; $generalobj->checkDuplicate('iFormatId', PRJ_DB_PREFIX . "_email_template", array('vSub' => $Data['vSub']), $redirect_file, SUBJECT_ALREADY_EXISTS, $iFormatId); if ($view == "add") { //prints($Data);exit; $emailTempObj->setAllVar($Data); $result = $emailTempObj->insert(); if ($result) { $var_msg = "Record Added Successfully."; } else { $var_msg = "Eror-in Add."; } } else { if ($view == "edit") { //prints($Data);exit; $arr = $emailTempObj->select($iFormatId); $emailTempObj->setAllVar($arr); $emailTempObj->setAllVar($Data); $where = " iFormatId = '" . $iFormatId . "'"; $result = $emailTempObj->update($where); if ($result) { $var_msg = "Record Updated Successfully."; } else { $var_msg = "Eror-in Update."; } } } header("Location:index.php?file=" . $actionfile . "&view=index&AX=Yes&var_msg={$var_msg}"); exit;