ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models_old/Master_model.php |
<?php
class Master_model extends CI_Model {
/** Program Types */
function programTypes(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_program_types")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function programTypeDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_program_types", array('id'=>$id))->row_array();
return $rs;
}
function deleteProgramType($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_program_types", array('id'=>$id));
}
/** \ */
/** Academic Careers */
function academicCareers(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_academic_careers")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function academicCareerDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_academic_careers", array('id'=>$id))->row_array();
return $rs;
}
function deleteAcademicCareer($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_academic_careers", array('id'=>$id));
}
/** \ */
/** Discipline */
function disciplines(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_disciplines")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function disciplineDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_disciplines", array('id'=>$id))->row_array();
return $rs;
}
function deleteDiscipline($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_disciplines", array('id'=>$id));
}
/** \ */
/** Schools */
function schools(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status")->from("master_schools")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function schoolDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_schools", array('id'=>$id))->row_array();
return $rs;
}
function deleteSchool($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_schools", array('id'=>$id));
}
/** \ */
/** Applicat Cats */
function applicantCats(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status")->from("master_applicat_cats")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function applicantCatDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_applicat_cats", array('id'=>$id))->row_array();
return $rs;
}
function deleteApplicantCat($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_applicat_cats", array('id'=>$id));
}
/** \ */
/** Applicat religions */
function applicantReligions(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status")->from("master_applicat_religions")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function applicantReligionDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_applicat_religions", array('id'=>$id))->row_array();
return $rs;
}
function deleteApplicantReligion($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_applicat_religions", array('id'=>$id));
}
/** \ */
/** Marking Schemes */
function markingSchemes(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status,allowed_data")->from("master_marking_schemes")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function markingSchemeDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_marking_schemes", array('id'=>$id))->row_array();
return $rs;
}
function deleteMarkingScheme($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_marking_schemes", array('id'=>$id));
}
/** \ */
/** Edu Boards */
function eduBoards(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, status")->from("master_edu_boards")->order_by("title")->get()->result_array();
return $rs;
}
function eduBoardDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_edu_boards", array('id'=>$id))->row_array();
return $rs;
}
function deleteEduBoard($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_edu_boards", array('id'=>$id));
}
/** \ */
/** Universities */
function universities(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$this->db->select("id, title, ps_code, status")->from("master_universities")->order_by("title");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function universityDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_universities", array('id'=>$id))->row_array();
return $rs;
}
function deleteUniversity($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_universities", array('id'=>$id));
}
/** \ */
/** Admin Emalils */
function adminEmails(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('email', $qs['k']);
}
$this->db->select("id, email,send_payment_alert, send_appointment_alert, send_issue_alert")->from("master_admin_emails")->order_by("id");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function adminEmailDetal($id,$f='*'){
$rs=$this->db->select($f)->get_where("master_admin_emails", array('id'=>$id))->row_array();
if($rs){
$rs['send_payment_alert'] =$rs['send_payment_alert']?true:false;
$rs['send_appointment_alert'] =$rs['send_appointment_alert']?true:false;
$rs['send_issue_alert'] =$rs['send_issue_alert']?true:false;
}
return $rs;
}
function deleteAdminEmail($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_admin_emails", array('id'=>$id));
}
/** \ */
/** UTM Source */
function utmSources($getmedium=false){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('medium', $qs['k']);
}
$rs=$this->db->select("id, title, grp, status")->from("master_utm_sources")->order_by("title")->get()->result_array();
if($getmedium){
foreach($rs as &$r){
$mediums=$this->db->select("DISTINCT utm_medium", false)->get_where("applicants", array('utm_source_id'=>$r['id']))->result_array();
$meds=[];
foreach($mediums as $m){
if($m['utm_medium']){
$meds[]=$m['utm_medium'];
}
}
$r['medium']=implode(", ", $meds);
}
}
return $rs;
}
function utmSourceDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_utm_sources", array('id'=>$id))->row_array();
return $rs;
}
function deleteUtmSource($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_utm_sources", array('id'=>$id));
}
/** \ */
/** Coupans */
function coupans(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, amt, DATE_FORMAT(expiry_date, '%d %b %Y') AS expiry_date, gender, disp_odr, status")->from("master_coupans")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function coupanDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_coupans", array('id'=>$id))->row_array();
if($rs){
$rs['expiry_date']=get_date($rs['expiry_date']);
}
return $rs;
}
function deleteCoupan($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_coupans", array('id'=>$id));
}
/** \ */
/** States */
function states(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('code', $qs['k']);
}
$rs=$this->db->select("id, title, code, status")->from("master_states")->order_by("title")->get()->result_array();
return $rs;
}
function stateDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_states", array('id'=>$id))->row_array();
return $rs;
}
function deleteState($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_states", array('id'=>$id));
}
function cities($stateId=''){
$this->db->where('state_id', $stateId);
$rs=$this->db->select("id, title, pincode, status")->from("master_cities")->order_by("title")->get()->result_array();
return $rs;
}
function cityDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_cities", array('id'=>$id))->row_array();
return $rs;
}
function deleteCity($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_cities", array('id'=>$id));
}
/** \ */
/** Notifications */
function notifications(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('msg', $qs['k']);
}
$rs=$this->db->select("id, msg, steps, type, status")->from("notifications")->order_by("id", "DESC")->get()->result_array();
foreach($rs as &$r){
$r['msg']=str_short($r['msg'], 250);
}
return $rs;
}
function notificationDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("notifications", array('id'=>$id))->row_array();
return $rs;
}
function deleteNotification($id){
$this->db->db_debug=FALSE;
return $this->db->delete("notifications", array('id'=>$id));
}
/** \ */
/** Faq */
function faqs(){
$qs=trim_array($this->input->get());
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.ans, F.disp_odr, F.status, F.cat_ids")->from("master_faq AS F")->order_by("F.disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['ans']=str_short($r['ans'], 250);
$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 faqDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_faq", array('id'=>$id))->row_array();
return $rs;
}
function deleteFaq($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_faq", array('id'=>$id));
}
function faqCatDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_faq_cats", array('id'=>$id))->row_array();
return $rs;
}
function deleteFaqCat($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_faq_cats", array('id'=>$id));
}
/** \ */
}
//End of file
Kontol Shell Bypass