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/Files_model.php |
<?php
class Files_model extends CI_Model {
function cats(){
$rs=$this->db->select("id, title")->order_by("id")->get("file_cats")->result_array();
return $rs;
}
function lists(){
$qs=trim_array($this->input->get());
if($qs['cat_id']){
$this->db->where("f.cat_id", $qs['cat_id']);
}
if($qs['k']){
$this->db->group_start()
->like('f.title', $qs['k'])
->or_like('f.file_name', $qs['k'])
->group_end();
}
$this->db->select("f.*, c.title cat")->from("files f")->join("file_cats c", "c.id=f.cat_id")->order_by("f.id", "DESC");
$rs=$this->dba->pagedRows($qs['p'], 50, 5);
foreach($rs['result'] as &$r){
$r['is_image']=(int)$r['is_image'];
$r['is_pdf']=(int)$r['is_pdf'];
$r['file_ext']=strtoupper($r['file_ext']);
$r['file_url']=UP_URLF.'files/'.$r['file_name'];
}
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("files", array('id'=>$id))->row_array();
if($rs){
}
return $rs;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("files", array('id'=>$id));
}
function saveCats($data){
$err=FALSE;
$this->db->trans_strict(FALSE);
$this->db->trans_begin();
try{
$ids=[];
foreach($data as $d){
$ids[]=$this->dba->save("file_cats", $d);
}
if($ids){
$this->db->where_not_in("id", $ids)->delete("file_cats");
}
}catch(Exception $e){
$err=TRUE;
$msg=$e->getMessage();
}
if($this->db->trans_status() === FALSE) {
$err=TRUE;
}
if($err){
$this->db->trans_rollback();
return FALSE;
}else{
$this->db->trans_commit();
return TRUE;
}
}
}
//End of file
Kontol Shell Bypass