|
Server IP : 172.26.0.195 / Your IP : 3.143.237.140 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/css/../../web/../alumni/application/models/user/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
/**
* Description of User
*
* @author Softpro India Pvt. Ltd.
*/
class PostManagement extends CI_Model {
//put your code here
function savePost($postData) {
$this->db->insert("tbl_post", $postData);
return $this->db->insert_id();
}
function getPosts($userid) {
$this->db->select("*");
$this->db->from("tbl_post");
$this->db->Where("userid", $userid);
$this->db->Where("pst_delete_status", "f");
$this->db->order_by("datentime", "DESC");
return $this->db->get();
}
function getPostsByID($pst_id) {
$this->db->select("*");
$this->db->from("tbl_post");
$this->db->Where("pst_id", $pst_id);
return $this->db->get();
}
function getPostForReport($userid, $usertype, $limit, $offset) {
$this->db->select("*");
$this->db->from("tbl_post p");
$this->db->join("tbl_stu_alu sa", "sa.userid = p.userid");
$this->db->join("tbl_profile pr", "pr.user_id = sa.userid");
$this->db->where("p.userid NOT IN ($userid)");
$this->db->where("p.pst_for IN ('All','$usertype')");
$this->db->Where("p.pst_delete_status", "f");
$this->db->Where("p.pst_publish_status", "t");
$this->db->limit($limit, $offset);
$this->db->order_by("datentime", "DESC");
return $this->db->get();
}
function getNumOfPosts($userid, $usertype) {
$this->db->select("*");
$this->db->from("tbl_post p");
$this->db->join("tbl_stu_alu sa", "sa.userid = p.userid");
$this->db->where("p.userid NOT IN ($userid)");
$this->db->where("p.pst_for IN ('All','$usertype')");
$this->db->Where("p.pst_delete_status", "f");
$this->db->Where("p.pst_publish_status", "t");
return $this->db->get()->num_rows();
}
function updatePost($postArrayData, $pst_id) {
$this->db->where("pst_id", $pst_id);
return $this->db->update("tbl_post", $postArrayData);
}
}