public function changeStatus(Dtouser $user)
{
$this->db->set('updated_date', date('Y-m-d H:i:s'));
$this->db->set('updated_by', $this->ion_auth->get_user_id());
$this->db->set('active', 1 - $user->getActive());
$this->db->where('id', $user->getId());
return $this->db->update('users');
}
public function getSaleOfBAExecutiveArchievement(Dtouser $Dtouser, $status = 0)
{
$this->db->select("\n\t\t\t\t\t\t\tIFNULL(SUM(sale_items.price*sale_items.quantity),0) AS amount\n\t\t\t\t\t\t\t", FALSE);
$this->db->from('sales');
$this->db->join('users', 'sales.ba_id = users.id AND users.active = 1', 'LEFT');
$this->db->join('sale_items', 'sales.id=sale_items.sale_id', 'LEFT');
$this->db->where('sales.status', 1);
$this->db->where('users.parent_id IN (SELECT id FROM users where parent_id = ' . $Dtouser->getId() . ')');
if ($status == 0) {
$this->db->where("DATE(sales.sale_date)=DATE_FORMAT(CONVERT_TZ(NOW(), @@session.time_zone, '+07:00'),'%Y-%m-%d')");
} else {
if ($status == 1) {
$this->db->where("(sales.sale_date between DATE_FORMAT(NOW() ,'%Y-%m-01') AND CONVERT_TZ(NOW(), @@session.time_zone, '+07:00') )");
} else {
if ($status == 2) {
$this->db->where("(sales.sale_date between DATE_FORMAT(NOW() ,'%Y-01-01') AND CONVERT_TZ(NOW(), @@session.time_zone, '+07:00') )");
}
}
}
$query = $this->db->get();
return $query->row();
}
public function getSupervisorInformation(Dtouser $user)
{
$this->db->select("A.id\n\t\t\t\t\t\t\t\t, A.first_name\n\t\t\t\t\t\t\t\t, A.last_name\n\t\t\t\t\t\t\t\t, (SELECT CONCAT(last_name, ' ', first_name) AS supervisor \n\t\t\t\t\t\t\t\t FROM users where id = A.parent_id) AS executive\n\t\t\t\t\t\t\t\t, A.photo", FALSE);
$this->db->from('users A');
$this->db->where("A.deleted_at", null);
$this->db->where('A.id', $user->getId());
$query = $this->db->get();
return $query->row();
}
