Server IP : 92.204.138.22 / Your IP : 3.14.251.43 Web Server : Apache System : Linux ns1009439.ip-92-204-138.us 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64 User : internationaljou ( 1019) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/internationaljou/SSRG-01-03-2024/application/models/ |
Upload File : |
<?php class Specialissue extends CI_Model { function __construct() { parent::__construct(); } public function get_year_special() { $this->db->select("year"); $this->db->from('specialissue_conference'); $this->db->distinct(); $this->db->order_by("year","desc"); //$query= $this->db->get(); //echo $query = $this->db->last_query(); $query = $this->db->get()->result(); $i=0; foreach($query as $specialyear){ //print_r($year->year); $query[$i]->sub = $this->getspecial_year_second($specialyear->year); $i++; } return $query; } public function getspecial_year_second($yearvalue) { $this->db->select('*'); $this->db->from('specialissue_conference'); $this->db->distinct(); $this->db->where('year',$yearvalue); $this->db->order_by("year","desc"); $this->db->order_by("sp_id","desc"); /* $query= $this->db->get(); echo $query = $this->db->last_query(); exit; */ $query = $this->db->get()->result(); return $query; $i=0; foreach($query as $year){ //print_r($year->year); $query[$i]->sub = $this->getspecial_year_second($year->year); $i++; } return $query; } public function specialissue_part() { $cid = $this->uri->segment(3); $this->db->select("department_name,department,shortform,part as shortpart,department_short,conference_name"); $this->db->from('specialissue_conference'); $this->db->join('specialissue_article','specialissue_conference.sp_id = specialissue_article.sc_id','inner'); $this->db->join('article_department','specialissue_article.department = article_department.dp_id','inner'); $this->db->distinct(); $this->db->where('sp_id',$cid); $this->db->order_by('department_name','asc'); $this->db->order_by('partno','asc'); /* $query = $this->db->get(); echo $sql = $this->db->last_query(); exit; */ $query = $this->db->get()->result(); return $query; } public function specialissues_paperlist_title_model() { $deptid_part = $this->uri->segment(3); $s = explode('-',$deptid_part); $departmentid = $s['0']; $parts =$s['1']; $conferenceid = $s['2']; $this->db->select("*"); $this->db->from('specialissue_article'); $this->db->join('specialissue_conference','specialissue_article.sc_id=specialissue_conference.sp_id'); $this->db->where('department=',$departmentid); $this->db->where('part',$parts); $this->db->where('sc_id',$conferenceid); //$this->db->order_by('specialissue_article.sa_id','asc'); //$query = $this->db->get(); //echo $sql = $this->db->last_query(); exit; $query = $this->db->get()->result(); return $query; } public function specialissues_paperlist_model() { $deptid_part = $this->uri->segment(3); $s = explode('-',$deptid_part); $departmentid = $s['0']; $parts =$s['1']; $conferenceid = $s['2']; $this->db->select("*"); $this->db->from('specialissue_article'); $this->db->where('department=',$departmentid); $this->db->where('part',$parts); $this->db->where('sc_id',$conferenceid); $this->db->order_by('partno','asc'); // $query = $this->db->get(); $query = $this->db->get()->result(); return $query; } } ?>