1024 lines
31 KiB
PHP
1024 lines
31 KiB
PHP
<?php
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Dashboard_controller extends CI_Controller {
|
|
|
|
public function __construct(){
|
|
|
|
parent::__construct();
|
|
|
|
error_reporting(0);
|
|
|
|
if(!$this->session->userdata('admin_name')){
|
|
redirect('login');
|
|
}
|
|
|
|
$this->id = $this->session->userdata('admin_id');
|
|
$this->load->model('get_model');
|
|
$this->load->model('common_model');
|
|
$this->load->model('insert_model');
|
|
$this->load->model('update_model');
|
|
|
|
|
|
// echo $this->id; exit();
|
|
|
|
}
|
|
|
|
public function index()
|
|
{
|
|
|
|
$this->load->view('pages/index');
|
|
|
|
}
|
|
|
|
// public function admin_profile(){
|
|
// $data['data'] = $this->get_model->get_by_id('tbl_admin', array('admin_id' => $this->id));
|
|
// $this->load->view('pages/admin_profile', $data);
|
|
// }
|
|
|
|
|
|
public function profile()
|
|
{
|
|
$data['data'] = $this->get_model->get_by_id('tbl_admin', array('admin_id' => $this->id));
|
|
$this->load->view('pages/profile', $data);
|
|
}
|
|
|
|
|
|
public function client_testimonial()
|
|
{
|
|
//$data['data'] = $this->get_model->get_all_desc('tbl_testimonials', 'id');
|
|
//$this->load->view('pages/client_testimonial', $data);
|
|
$config['base_url'] = base_url() . "Dashboard_controller/client_testimonial";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tbl_testimonials');
|
|
$config['per_page'] = 10 ;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tbl_testimonials','id');
|
|
$this->load->view('pages/client_testimonial', $data);
|
|
}
|
|
|
|
|
|
public function faq()
|
|
{
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/faq";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tbl_faq');
|
|
$config['per_page'] = 10 ;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tbl_faq','id');
|
|
|
|
$this->load->view('pages/faq', $data);
|
|
}
|
|
|
|
|
|
|
|
public function insert_faq()
|
|
{
|
|
|
|
$msg = array(
|
|
'question' => $this->input->post('question'),
|
|
'answer' => $this->input->post('answer'),
|
|
);
|
|
$insert = $this->insert_model->insert('tbl_faq', $msg);
|
|
|
|
if($insert){
|
|
|
|
$this->session->set_flashdata('success', 'Faq Added Successfully...!');
|
|
redirect('faq');
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
public function edit_faq()
|
|
{
|
|
$id=$this->input->post("id");
|
|
$question=$this->input->post("question");
|
|
$answer=$this->input->post("answer");
|
|
|
|
$data=array('question'=>$question,'answer'=>$answer,);
|
|
$where= array('id' => $id);
|
|
|
|
$this->common_model->update('tbl_faq', $data, $where);
|
|
|
|
redirect('faq',$this->session->set_flashdata('success', 'FAQ Update Successfully',3));
|
|
}
|
|
|
|
|
|
|
|
|
|
public function reset_pass()
|
|
{
|
|
$this->load->view('pages/reset_pass');
|
|
}
|
|
|
|
public function deleterecords()
|
|
{
|
|
|
|
|
|
|
|
if($this->input->post('testi_id')){
|
|
$image_path = FCPATH .'uploads/'; // your image path
|
|
$id = $this->input->post('testi_id');
|
|
|
|
// get db record from image to be deleted
|
|
$query_get_image = $this->db->get_where('tbl_testimonials', array('id ' => $id));
|
|
foreach ($query_get_image->result() as $record)
|
|
{
|
|
// delete file, if exists...
|
|
$filename = $image_path . $record->image;
|
|
|
|
if (file_exists($filename))
|
|
{
|
|
unlink($filename);
|
|
|
|
}
|
|
}
|
|
|
|
$this->load->library('session');
|
|
|
|
$where = array('id' => $id);
|
|
|
|
$result = $this->common_model->delete('tbl_testimonials',$where);
|
|
|
|
|
|
echo json_encode(array(
|
|
"statusCode"=>200
|
|
));
|
|
|
|
|
|
|
|
} // ends client delete
|
|
|
|
if($this->input->post('faq_id')){
|
|
$id = $this->input->post('faq_id');
|
|
|
|
$where = array('id' => $id);
|
|
|
|
$this->common_model->delete('tbl_faq',$where);
|
|
|
|
echo json_encode(array(
|
|
"statusCode"=>200
|
|
));
|
|
|
|
} // ends faq delete
|
|
|
|
|
|
|
|
if($this->input->post('country_id')){
|
|
$image_path = FCPATH .'assets/images/country/'; // your image path
|
|
$id = $this->input->post('country_id');
|
|
|
|
// get db record from image to be deleted
|
|
$query_get_image = $this->db->get_where('tbl_country', array('id ' => $id));
|
|
foreach ($query_get_image->result() as $record)
|
|
{
|
|
// delete file, if exists...
|
|
$filename = $image_path . $record->country_flag;
|
|
|
|
if (file_exists($filename))
|
|
{
|
|
unlink($filename);
|
|
|
|
}
|
|
|
|
}
|
|
|
|
$this->load->library('session');
|
|
|
|
$where = array('id' => $id);
|
|
|
|
$result = $this->common_model->delete('tbl_country',$where);
|
|
|
|
|
|
echo json_encode(array(
|
|
"statusCode"=>200
|
|
));
|
|
|
|
|
|
|
|
} // ends country delete
|
|
|
|
|
|
if($this->input->post('lang_id')){
|
|
$id = $this->input->post('lang_id');
|
|
|
|
$where = array('id' => $id);
|
|
|
|
$this->common_model->delete('tbl_lang',$where);
|
|
|
|
echo json_encode(array(
|
|
"statusCode"=>200
|
|
));
|
|
|
|
} // ends lang id
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
public function privacy_policy()
|
|
{
|
|
$data['data'] = $this->get_model->get_by_id('tbl_privacy_policy', array('id' => '1'));
|
|
|
|
|
|
$this->load->view('pages/privacy_policy', $data);
|
|
}
|
|
|
|
|
|
public function add_edit_privacy()
|
|
{
|
|
|
|
$data = array('privacy_policy' => $this->input->post('text'));
|
|
$where = array('id' => '1');
|
|
$store = $this->common_model->insert_or_update('tbl_privacy_policy', $where , $data);
|
|
|
|
//if($store){
|
|
redirect('privacy_policy',$this->session->set_flashdata('success', 'Privacy Policy Update Successfully',3));
|
|
|
|
}
|
|
|
|
|
|
public function terms()
|
|
{
|
|
$data['data'] = $this->get_model->get_by_id('tbl_terms', array('id' => '1'));
|
|
|
|
|
|
$this->load->view('pages/terms', $data);
|
|
}
|
|
|
|
|
|
public function add_edit_terms()
|
|
{
|
|
|
|
$data = array('terms' => $this->input->post('text'));
|
|
$where = array('id' => '1');
|
|
$store = $this->common_model->insert_or_update('tbl_terms', $where , $data);
|
|
|
|
//if($store){
|
|
redirect('terms',$this->session->set_flashdata('success', 'Terms and Condition Update Successfully',3));
|
|
|
|
}
|
|
|
|
|
|
// country
|
|
|
|
public function add_country()
|
|
{
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/add_country";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tbl_country');
|
|
$config['per_page'] = 10 ;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tbl_country','id');
|
|
|
|
$this->load->view('pages/add_country', $data);
|
|
}
|
|
|
|
|
|
// country
|
|
public function add_language()
|
|
{
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/add_language";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tbl_lang');
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tbl_lang','id');
|
|
|
|
$this->load->view('pages/add_language', $data);
|
|
}
|
|
|
|
|
|
// user_manage
|
|
public function user_manage()
|
|
{
|
|
//echo "hh"; exit();
|
|
$where = '(user_type = 1)';
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/user_manage";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row_wh('tbl_user', $where);
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc_wh($config['per_page'],$offset,'tbl_user','user_id', $where);
|
|
|
|
//print_r($data); exit();
|
|
|
|
$this->load->view('pages/user_manage', $data);
|
|
}
|
|
|
|
|
|
// user_manage
|
|
public function wallet_manage()
|
|
{
|
|
//echo "hh"; exit();
|
|
$where = '(user_type = 1)';
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/wallet_manage";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row_wh('tbl_user', $where);
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc_wh($config['per_page'],$offset,'tbl_user','user_id', $where);
|
|
|
|
//print_r($data); exit();
|
|
|
|
$this->load->view('pages/wallet_manage', $data);
|
|
}
|
|
|
|
|
|
|
|
|
|
public function contact_us()
|
|
{
|
|
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/contact_us";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('user_contact_us');
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'user_contact_us','id');
|
|
|
|
//print_r($data); exit();
|
|
|
|
$this->load->view('pages/contact_us', $data);
|
|
}
|
|
|
|
public function time_slot()
|
|
{
|
|
|
|
|
|
$config['base_url'] = base_url() . "Dashboard_controller/time_slot";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tbl_time_slot');
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tbl_time_slot','id');
|
|
|
|
//print_r($data); exit();
|
|
|
|
$this->load->view('pages/time_slots', $data);
|
|
}
|
|
|
|
|
|
public function send_add_amount()
|
|
{
|
|
$amount = $this->input->post('amount');
|
|
$user_id = $this->input->post('user_id');
|
|
|
|
$msg = array(
|
|
'user_id' => $user_id,
|
|
'amount' => $amount,
|
|
'message' => 'amount added',
|
|
'added_date' => date('Y-m-d'),
|
|
'added_by' => 1,
|
|
't_status' => 1
|
|
);
|
|
|
|
$insert = $this->insert_model->insert_and_get_last_id('wallet_transaction_details', $msg);
|
|
|
|
if($insert){
|
|
|
|
$user = $this->db->get_where('tbl_user' , array('user_id' => $user_id))->row_array();
|
|
if($user){
|
|
|
|
$old_amount = $user['wallet_amount'];
|
|
$new_amount = $old_amount + $amount;
|
|
$this->common_model->update('tbl_user', array('wallet_amount' => $new_amount), array('user_id' => $user_id));
|
|
|
|
$this->common_model->update('wallet_transaction_details', array('wallet_amount' => $new_amount), array('t_id' => $insert));
|
|
|
|
}
|
|
|
|
$this->session->set_flashdata('success', 'Amount Added Successfully...!');
|
|
redirect('wallet_manage');
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
public function wallet_history(){
|
|
|
|
$id=$this->uri->segment(2);
|
|
$where = '(user_id = "'.$id.'")';
|
|
|
|
$config['base_url'] = base_url() . "wallet_history/".$id;
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row_wh('wallet_transaction_details', $where);
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
|
|
//echo $page; exit();
|
|
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
|
|
$offset = $page;
|
|
}
|
|
|
|
//echo $offset; exit();
|
|
|
|
$this->pagination->initialize($config);
|
|
|
|
$data['data'] = $this->get_model->list_by_desc_wh($config['per_page'],$offset,'wallet_transaction_details','t_id', $where);
|
|
|
|
$data['user'] = $this->get_model->get_by_id('tbl_user', $where);
|
|
|
|
$this->load->view('pages/wallet_history', $data);
|
|
|
|
}
|
|
|
|
|
|
public function withdrawl_request()
|
|
{
|
|
$data['data'] = $this->get_model->get_all_desc('wallet_transaction_details', 't_id');
|
|
//$this->load->view('pages/client_testimonial', $data);
|
|
$config['base_url'] = base_url() . "Dashboard_controller/withdrawl_request";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('wallet_transaction_details');
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'wallet_transaction_details','t_id');
|
|
$this->load->view('pages/withdrawl_request', $data);
|
|
|
|
}
|
|
|
|
|
|
public function change_status_with()
|
|
{
|
|
|
|
$id = $this->input->post('id');
|
|
$status = $this->input->post('status');
|
|
if($status == '1'){
|
|
|
|
$with_data = $this->db->get_where('withdrawl_request', array('id' => $id))->row_array();
|
|
if($with_data){
|
|
|
|
$uid = $with_data['user_id'];
|
|
$with_amount = $with_data['withdraw_amt'];
|
|
|
|
$user_data = $this->db->get_where('tbl_user', array('user_id' => $uid))->row_array();
|
|
|
|
if($user_data){
|
|
|
|
$wamount = $user_data['wallet_amount'];
|
|
|
|
$update_amt = (int) $wamount + (int) $with_amount;
|
|
|
|
$arr1 = array(
|
|
|
|
'wallet_amount' => $update_amt
|
|
|
|
);
|
|
|
|
$update = $this->common_model->update('tbl_user', $arr1, array('user_id' => $user_data['user_id']));
|
|
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
$where = array('id' => $id);
|
|
$data = array('request_status' => $status);
|
|
$update = $this->common_model->update_data('withdrawl_request',$data, $where);
|
|
// echo $update; exit();
|
|
$arr = array('success' => false, 'data' => '');
|
|
if($update){
|
|
$arr = array('success' => true, 'data' => $update);
|
|
}
|
|
echo json_encode($arr);
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
public function withdrawl_history()
|
|
{
|
|
//$data['data'] = $this->get_model->get_all_desc('tbl_testimonials', 'id');
|
|
//$this->load->view('pages/client_testimonial', $data);
|
|
$user_id = $this->uri->segment(2);
|
|
$config['base_url'] = base_url() . "withdrawl_history/".$user_id;
|
|
$config['use_page_numbers'] = TRUE;
|
|
|
|
$config['total_rows'] = $this->get_model->num_row_wh('withdrawl_request', array('user_id' => $user_id));
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 3;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
|
|
$offset = ($page-1) * $limit;
|
|
|
|
}else{
|
|
|
|
$offset = $page;
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
|
|
$data['data'] = $this->get_model->list_by_desc_wh($config['per_page'],$offset,'withdrawl_request','id', array('user_id' => $user_id));
|
|
$data['user'] = $this->get_model->get_by_id('tbl_user', array('user_id' => $user_id));
|
|
$data['bank'] = $this->get_model->get_by_id('user_bank_details', array('user_id' => $user_id));
|
|
|
|
//echo "<pre>"; print_r($data); die;
|
|
$this->load->view('pages/withdrawl_history', $data);
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
public function manage_tournament()
|
|
{
|
|
//$data['data'] = $this->get_model->get_all_desc('tbl_testimonials', 'id');
|
|
//$this->load->view('pages/client_testimonial', $data);
|
|
$config['base_url'] = base_url() . "Dashboard_controller/manage_tournament";
|
|
$config['use_page_numbers'] = TRUE;
|
|
$config['total_rows'] = $this->get_model->num_row('tournament');
|
|
$config['per_page'] = 10;
|
|
$config['url_sigment'] = 3;
|
|
$config['num_links'] = 2;
|
|
/*start add boostrap class and styles*/
|
|
$config['next_link'] = 'Next';
|
|
$config['prev_link'] = 'Prev';
|
|
$config['first_link'] = false;
|
|
$config['last_link'] = false;
|
|
$config['full_tag_open'] = '<ul class="pagination listjs-pagination mb-0">';
|
|
$config['full_tag_close'] = '</ul>';
|
|
$config['attributes'] = ['class' => 'page-link'];
|
|
$config['first_tag_open'] = '<li class="page-item">';
|
|
$config['first_tag_close'] = '</li>';
|
|
$config['prev_tag_open'] = '<li class="page-item">';
|
|
$config['prev_tag_close'] = '</li>';
|
|
$config['next_tag_open'] = '<li class="page-item">';
|
|
$config['next_tag_close'] = '</li>';
|
|
$config['last_tag_open'] = '<li class="page-item">';
|
|
$config['last_tag_close'] = '</li>';
|
|
$config['cur_tag_open'] = '<li class="page-item active"><span class="page-link">';
|
|
$config['cur_tag_close'] = '<span class="sr-only">(current)</span></span></li>';
|
|
$config['num_tag_open'] = '<li class="page-item">';
|
|
$config['num_tag_close'] = '</li>';
|
|
|
|
$limit = $config['per_page'];
|
|
$page = $this->uri->segment(3);
|
|
if($page > 1){
|
|
$offset = ($page-1) * $limit;
|
|
}else{
|
|
$offset = $page;
|
|
|
|
}
|
|
|
|
$this->pagination->initialize($config);
|
|
$data['data'] = $this->get_model->list_by_desc($config['per_page'],$offset,'tournament','tid');
|
|
$data['time_slot'] = $this->get_model->get_table('tbl_time_slot');
|
|
|
|
$this->load->view('pages/manage_tournament', $data);
|
|
|
|
}
|
|
|
|
|
|
public function add_tournament(){
|
|
|
|
// echo "<pre>";
|
|
// print_r($_POST); exit();
|
|
|
|
$tournament = $this->input->post('tournament');
|
|
$entry_fee = $this->input->post('entry_fee');
|
|
$start_date = $this->input->post('start_date');
|
|
$start_time =$this->input->post('start_time');
|
|
$win_Amount = $this->input->post('win_Amount');
|
|
$time_slot = $this->input->post('time_slot');
|
|
$start_date_time = $start_date .' '. $start_time;
|
|
$response = array();
|
|
$msg = array(
|
|
|
|
'tname' => $tournament,
|
|
'entry_fee' => $entry_fee,
|
|
'start_date_time' => $start_date_time,
|
|
'win_Amount' => $win_Amount,
|
|
'time_slot' => $time_slot
|
|
|
|
);
|
|
|
|
|
|
|
|
$insert = $this->insert_model->insert_and_get_last_id('tournament', $msg);
|
|
|
|
if($insert){
|
|
|
|
//add rounds
|
|
$cnt = count($_POST['round']);
|
|
if($cnt > 0) {
|
|
|
|
for($i=0; $i<$cnt; $i++){
|
|
|
|
$round = $_POST['round'][$i];
|
|
$insert2 = $this->insert_model->insert_and_get_last_id('tournament_round', array('tid' => $insert, 'round' => $round));
|
|
|
|
}
|
|
}
|
|
|
|
$this->session->set_flashdata('success', 'Tournament added successfully.');
|
|
redirect('manage_tournament');
|
|
$response = array(
|
|
'success' => true
|
|
);
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
// Dashboard_controller.php
|
|
|
|
|
|
public function update_tournament() {
|
|
// Check if the form is submitted
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
// Get form data
|
|
$tournamentId = $this->input->post('id');
|
|
$tournamentName = $this->input->post('tournament');
|
|
$entryFee = $this->input->post('entry_fee');
|
|
$start_date_time = $this->input->post('start_date_time');
|
|
// $starttime = $this->input->post('start_time');
|
|
$winAmount = $this->input->post('win_Amount');
|
|
$timeSlot = $this->input->post('time_slot');
|
|
$rounds = $this->input->post('round'); // Assuming 'round' is an array
|
|
// $startDateTime = $startDate.' '.$starttime;
|
|
// Update tournament information in the database
|
|
$data = array(
|
|
'tname' => $tournamentName,
|
|
'entry_fee' => $entryFee,
|
|
'start_date_time' => $start_date_time,
|
|
'win_amount' => $winAmount,
|
|
'time_slot' => $timeSlot,
|
|
);
|
|
|
|
$this->db->where('tid', $tournamentId);
|
|
$this->db->update('tournament', $data);
|
|
|
|
// Update rounds information in the database
|
|
foreach ($rounds as $index => $round) {
|
|
// Assuming you have a 'tournament_round' table
|
|
$roundData = array(
|
|
'round' => $round,
|
|
);
|
|
|
|
$this->db->where(array('tid' => $tournamentId, 'round' => $index));
|
|
$this->db->update('tournament_round', $roundData);
|
|
}
|
|
|
|
// Redirect or perform any other necessary actions after the update
|
|
redirect('manage_tournament');
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
} |