ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models/Landingpage_model.php |
<?php
class Landingpage_model extends CI_Model {
function lists(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->group_start()
->like('P.title', $qs['k'])
->group_end();
}
$f="P.id, P.title, P.for_mob_app, P.isdefault, P.step1pay, P.instant_fee, P.male_fee, P.female_fee, P.other_fee,
P.male_offer_fee, P.female_offer_fee, P.other_offer_fee, P.offer_msg, P.status, UTM.title na_utm_source";
$this->db->select($f)
->from("landing_pages P")
->join("master_utm_sources UTM", "UTM.id=P.na_utm_source_id", "LEFT")
->order_by("P.title");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
if($rs['result']){
foreach($rs['result'] as &$r){
$r['coupan_added']=0;
if($this->lpUsedCoupanIds($r['id'])){
$r['coupan_added']=1;
}
}
}
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("landing_pages", array('id'=>$id))->row_array();
if($rs){
$rs['coupanIds']=$this->lpUsedCoupanIds($rs['id']);
}
return $rs;
}
function lpUsedCoupanIds($lpage_id){
return $this->db->select("cu.coupan_id")
->from("coupans_in_use cu")
->join("master_coupans mc", "mc.id=cu.coupan_id")
->where(['cu.lpage_id'=>$lpage_id, 'mc.expiry_date>='=>date('Y-m-d')])
->get()->result_array();
}
function delete($id){
$this->db->db_debug=FALSE;
$this->db->delete("coupans_in_use", array('lpage_id'=>$id));
return $this->db->delete("landing_pages", array('id'=>$id));
}
/** Landing Page Programs */
function lpPrograms($lpageId=0){
return $this->db->select("LPP.id, P.title AS program, AC.title AS ac")
->from("landing_page_programs AS LPP")
->join("master_programs AS P", "LPP.program_id=P.id")
->join("master_academic_careers AS AC", "P.ac_id=AC.id")
->where(array('LPP.lpage_id'=>$lpageId))
->order_by("P.title")
->get()->result_array();
}
function listPrograms($lpageId=0){
$lpageId=(int)$lpageId;
$qs=trim_array($this->input->get());
$this->db->where(array('P.status'=>1, 'LPP.id'=>NULL));
if($qs['type_id']){
$this->db->where("P.type_id", $qs['type_id']);
}
if($qs['ac_id']){
$this->db->where("P.ac_id", $qs['ac_id']);
}
if($qs['discipline_id']){
$this->db->where("P.discipline_id", $qs['discipline_id']);
}
if($qs['school_id']){
$this->db->where("P.school_id", $qs['school_id']);
}
if($qs['k']){
$this->db->group_start()
->like('P.title', $qs['k'])
->or_like('AC.title', $qs['k'])
->or_like('PT.title', $qs['k'])
->or_like('MD.title', $qs['k'])
->or_like('SCH.title', $qs['k'])
->group_end();
}
$this->db->select("P.id, P.title, P.fee, P.status, PT.title AS type, AC.title AS ac_name, MD.title AS discipline, SCH.title AS school")
->from("master_programs AS P")
->join("master_program_types AS PT", "P.type_id=PT.id")
->join("master_academic_careers AS AC", "P.ac_id=AC.id")
->join("master_disciplines AS MD", "P.discipline_id=MD.id")
->join("master_schools AS SCH", "P.school_id=SCH.id")
->join("landing_page_programs AS LPP", "P.id=LPP.program_id AND LPP.lpage_id='$lpageId'", "LEFT")
->order_by("P.title");
$rs=$this->db->get()->result_array();
return $rs;
}
function saveLPP($post){
$err = FALSE;
$this->db->trans_strict(FALSE);
$this->db->trans_begin();
try{
foreach($post['programs'] as $program_id){
$d=array('lpage_id'=>$post['lpage_id'], 'program_id'=>$program_id);
$isAdded=$this->db->get_where("landing_page_programs", $d)->row_array();
if($isAdded){
$d['updated']=currentDT();
$this->db->update("landing_page_programs", $d, array('id'=>$isAdded['id']));
}else{
$d['created']=currentDT();
$d['updated']=currentDT();
$this->db->insert("landing_page_programs", $d);
}
}
}catch(Exception $e) {
$err = TRUE;
$msg = $e->getMessage();
}
if($this->db->trans_status() === FALSE) {
$err = TRUE;
}
if ($err) {
$this->db->trans_rollback();
return array('success'=>'F', 'msg'=>$msg?$msg:'Server Error!');
} else {
$this->db->trans_commit();
return array('success'=>'T', 'msg'=>'Programs added');
}
}
function deleteLPP($id){
$this->db->db_debug=FALSE;
return $this->db->delete("landing_page_programs", array('id'=>$id));
}
function deleteAllLPP($lpage_id){
$this->db->db_debug=FALSE;
return $this->db->delete("landing_page_programs", array('lpage_id'=>$lpage_id));
}
/** Landing Page Faq */
function lpFaqs($lpageId=0){
$rs=$this->db->select("LPF.id, F.question, F.cat_ids")
->from("landing_page_faqs AS LPF")
->join("master_faq AS F", "LPF.faq_id=F.id")
->where(array('LPF.lpage_id'=>$lpageId))
->order_by("F.disp_odr")
->get()->result_array();
foreach($rs as &$r){
$r['cats']=$this->db->select("GROUP_CONCAT(title ORDER BY title SEPARATOR ', ') AS cats", FALSE)->from("master_faq_cats")->where_in("id", explode(",", $r['cat_ids']))->get()->row()->cats;
}
return $rs;
}
function listFaqs($lpageId=0){
$qs=trim_array($this->input->get());
$this->db->where(array('F.status'=>1, 'LPF.id'=>NULL));
if($qs['cat_id']){
$catId=$this->db->escape_str($qs['cat_id']);
$this->db->where("FIND_IN_SET('$catId', F.cat_ids)", NULL, FALSE);
}
if($qs['k']){
$this->db->db_debug = FALSE;
$k=$this->db->escape_str(str_for_fulltext($qs['k'], TRUE, TRUE));
$fts_mode="IN BOOLEAN MODE";
$fulltext_cond="MATCH(F.question, F.ans) AGAINST('$k' $fts_mode)";
$this->db->where($fulltext_cond, NULL, FALSE)->or_like("F.question", $qs['k'])->or_like("F.ans", $qs['k']);
}
$rs=$this->db->select("F.id, F.question, F.disp_odr, F.status, F.cat_ids")
->from("master_faq AS F")
->join("landing_page_faqs AS LPF", "F.id=LPF.faq_id AND LPF.lpage_id='$lpageId'", "LEFT")
->order_by("F.disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['cats']=$this->db->select("GROUP_CONCAT(title ORDER BY title SEPARATOR ', ') AS cats", FALSE)->from("master_faq_cats")->where_in("id", explode(",", $r['cat_ids']))->get()->row()->cats;
}
return $rs;
}
function saveLPF($post){
$err = FALSE;
$this->db->trans_strict(FALSE);
$this->db->trans_begin();
try{
foreach($post['faqs'] as $faq_id){
$d=array('lpage_id'=>$post['lpage_id'], 'faq_id'=>$faq_id);
$isAdded=$this->db->get_where("landing_page_faqs", $d)->row_array();
if($isAdded){
$d['updated']=currentDT();
$this->db->update("landing_page_faqs", $d, array('id'=>$isAdded['id']));
}else{
$d['created']=currentDT();
$d['updated']=currentDT();
$this->db->insert("landing_page_faqs", $d);
}
}
}catch(Exception $e) {
$err = TRUE;
$msg = $e->getMessage();
}
if($this->db->trans_status() === FALSE) {
$err = TRUE;
}
if ($err) {
$this->db->trans_rollback();
return array('success'=>'F', 'msg'=>$msg?$msg:'Server Error!');
} else {
$this->db->trans_commit();
return array('success'=>'T', 'msg'=>'FAQ added');
}
}
function deleteLPF($id){
$this->db->db_debug=FALSE;
return $this->db->delete("landing_page_faqs", array('id'=>$id));
}
function deleteAllLPF($lpage_id){
$this->db->db_debug=FALSE;
return $this->db->delete("landing_page_faqs", array('lpage_id'=>$lpage_id));
}
/** Apply Before */
function applyBeforeDetail(){
$rs=$this->db->select("datakey, datavalue")->from("master_data")->where_in("datakey", ['apply_before_image', 'apply_before_line1', 'apply_before_line2', 'apply_before_line3'])->get()->result_array();
$dtl=[];
foreach($rs as $r){
switch($r['datakey']){
case 'apply_before_image':
$dtl['apply_before_image']=$r['datavalue'];
$dtl['apply_before_image_url']=$r['datavalue']?(UP_URLF.'lpages/'.$r['datavalue']):'';
break;
case 'apply_before_line1':
$dtl['apply_before_line1']=$r['datavalue'];
break;
case 'apply_before_line2':
$dtl['apply_before_line2']=$r['datavalue'];
break;
case 'apply_before_line3':
$dtl['apply_before_line3']=$r['datavalue'];
break;
}
}
return $dtl;
}
}
//End of file
Kontol Shell Bypass