function manage_template()
{
if (isset($this->params['pass'][0]) && $this->params['pass'][0]) {
$this->loadModel("CaseTemplate");
$this->CaseTemplate->id = $this->params['pass'][0];
$this->CaseTemplate->delete();
$this->CaseTemplate->delete();
$this->Session->write("SUCCESS", "Deleted successfully");
$this->redirect(HTTP_ROOT . "users/manage_template");
}
if (isset($this->request->query['act']) && $this->request->query['act']) {
$v = urldecode(trim($this->request->query['act']));
$this->loadModel("CaseTemplate");
$this->CaseTemplate->id = $v;
if ($this->CaseTemplate->saveField("is_active", 1)) {
$this->Session->write("SUCCESS", "Template activated successfully");
$this->redirect(HTTP_ROOT . "users/manage_template/");
} else {
$this->Session->write("ERROR", "Template can't be activated.Please try again.");
$this->redirect(HTTP_ROOT . "users/manage_template/");
}
}
if (isset($this->request->query['inact']) && $this->request->query['inact']) {
$v = urldecode(trim($this->request->query['inact']));
$this->loadModel("CaseTemplate");
$this->CaseTemplate->id = $v;
if ($this->CaseTemplate->saveField("is_active", 0)) {
$this->Session->write("SUCCESS", "Template deactivated successfully");
$this->redirect(HTTP_ROOT . "users/manage_template/");
} else {
$this->Session->write("ERROR", "Template can't be deactivated.Please try again.");
$this->redirect(HTTP_ROOT . "users/manage_template/");
}
}
$this->loadModel("CaseTemplate");
$res = $this->CaseTemplate->find('all', array('conditions' => array('company_id' => SES_COMP, 'user_id' => SES_ID, 'is_active' => 1)));
$total_record1 = $res;
$total_records = count($total_record1);
$this->set('total_records', $total_records);
$page_limit = MILE_PAGE_LIMIT;
$page = 1;
$pageprev = 1;
if (isset($_GET['page']) && $_GET['page']) {
$page = $_GET['page'];
}
$limit1 = $page * $page_limit - $page_limit;
$limit2 = $page_limit;
$query = "SELECT * FROM case_templates WHERE case_templates.company_id='" . SES_COMP . "' AND case_templates.user_id='" . SES_ID . "' ORDER BY created ASC LIMIT " . $limit1 . "," . $limit2;
$TempalteArray = $this->CaseTemplate->query($query);
//$limit = $limit1.",".$limit2;
//$TempalteArray =$this->CaseTemplate->find('all', array('conditions'=> array('CaseTemplate.is_active'=>1,'order'=>array('CaseTemplate.created DESC'),'limit' =>$limit)));
$count_mile = count($TempalteArray);
$this->set('count_mile', $count_mile);
$this->set('page_limit', $page_limit);
$this->set('page', $page);
$this->set('pageprev', $pageprev);
$this->set('TempalteArray', $TempalteArray);
}