<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Confg extends Bko_Controller {

    public function siteitems() {
        $data["title"] = "Withdraws Report";
        $mysql = "SELECT m.added::date AS date,m.terminatingamount*0.01 AS amount,m.fee*0.01 as fee, "
                . "mm.firstname||' '||mm.lastname||'<br>Email:'||mm.email AS Sender,"
                . "r.firstname||' '||r.lastname||'<br><b>Acc:</b>'||r.account_no||'-'||b.name AS Recitient,mp.confirmation,"
                . "CASE WHEN m.status=1 THEN 'Pending' WHEN m.status=3 THEN 'Cancelled' WHEN m.status=5 THEN 'Completed' ELSE '' END AS Status "
                . "FROM money_transfer m "
                . "LEFT JOIN sendmoney_recipient r ON r.id = m.recipientid "
                . " LEFT JOIN members mm ON mm.id = m.member_id "
                . "LEFT JOIN bank_entity_codes b ON b.code = r.bank_code "
                . "LEFT JOIN members_payments mp ON mp.what_sendmoney = m.id "
                . "WHERE mp.confirmation IS NOT NULL ORDER BY m.id DESC LIMIT 4000";

        // $query = $this->db->query($mysql);
        // $this->table->set_heading('Date', 'Amount', 'Fee', 'Recipient', 'Confirmation', 'Status')
        //$this->table->set_heading('Date', 'Amount','Fee','Recipient','Confirmation', 'Status');
        //   $data['mysql'] = $mysql;
        //  $this->renderbkoreportpage($data);

        $data = array();
        $data['page_title'] = "Configurations";
        $this->renderAdminPage('configure/view_bko_configure', $data);
    }

    public function selpage() {
        $data = array();

        $data['page_id'] = trim($this->input->get('page_id'));

        if ($data['page_id'] != '') {

            switch ($data['page_id']) {
                case 'APPHELP':

                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT  id ,uid ,icon ,title ,contents FROM help_items WHERE status = 1  ORDER BY id  ASC"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    $data['faq_result'] = $query->result();
                    $data['faq_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/appfaq_form', $data);

                    break;

                case "JOBCATEG":
                    $this->load->library('table');
                    $this->table->set_template($this->template);

                    $mysql = "SELECT * FROM skill_category ORDER BY category ASC";
                    $query = $this->db->query($mysql);
                    //  $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                    $data['skill_category_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/jobcaregory_form', $data);
                    break;

                case "JOBSKILLTYPE":

                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT * FROM skill_category ORDER BY category ASC"; // temporary 
                    $query = $this->db->query($mysql);
                    $data['skill_category_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/jobskill_form', $data);
                    break;

                case "AREASON":
                case "MREASON":

                    $mysql = "SELECT * FROM reason_type WHERE rkey='" . $data['page_id'] . "'";
                    $q = $this->db->query($mysql);
                    $row = $q->row();
                    if (isset($row)) {
                        $data['reason_name'] = $row->rname;
                        $data['reason_key'] = $row->rkey;
                        $this->load->library('table');
                        $this->table->set_template($this->template);
                        $mysql = "SELECT lkey,name,'<button onclick=\"deleteReason('||id||'.'||lkey||');\">Del</button>' FROM reason_items WHERE rkey='" . $data['page_id'] . "'"; // WHERE agent_id = " . $data['agent_id'];
                        $query = $this->db->query($mysql);
                        $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                        $data['reason_table'] = $this->table->generate($query);
                        $this->load->view('bko/configure/extra/reason_form', $data);
                    }
                    break;
                case "LANGUAGE":
                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT * FROM languages ORDER BY language ASC"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    //  $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                    $data['language_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/language_form', $data);
                    break;
                case "COUNTRY":

                    $this->load->library('table');
                    $this->table->set_template($this->template);
                   $mysql = "SELECT id,code,country,phone_code,
                   (CASE WHEN 
                       allow IS NULL 
                       THEN '<div id=\"allow-'||code||'\" ><button  onclick=\"allowStatus('''||code||''',1);\" type=\"button\" class=\"btn btn-danger\">Enable</button></div>' 
                       ELSE 
                        '<a id=\"allow-'||code||'\" ><button  onclick=\"allowStatus('''||code||''',0);\" >'||allow::date::text||'</a>' 
                       END) 
                       AS Allow,
                   '<a href=\"#\" >'|| jobs::date||'</a>' AS Jobs,
                    status 
                    FROM country 
                    ORDER BY allow,	jobs,	status,country ASC"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    //  $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                    $data['country_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/country_form', $data);

                    break;

                case "UTRANSPRICE":
                    $data["form_title"] = "User Transport Pricing";
                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT * FROM country ORDER BY country ASC"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    //  $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                    $data['country_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/pricing_form', $data);

                    break;

                case "ULATORPRICE":
                    $data["form_title"] = "User Translator Pricing";

                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT * FROM country ORDER BY country ASC"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    //  $this->table->set_heading(array('data' => 'Key', 'style' => 'width:60px'), 'Reason', array('data' => 'Action', 'style' => 'width:100px'));
                    $data['country_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/pricing_form', $data);

                    break;

                case "FAQSET":
                   
                    $mysql2 = " SELECT code,description FROM faq_category";
                    $query2 = $this->db->query($mysql2);
                    $data['faq_category'] = $query2->result();

                    $this->load->library('table');
                    $this->table->set_template($this->template);
                    $mysql = "SELECT id,title,dir,msg,flags,added,status,code FROM faq ORDER BY id desc"; // WHERE agent_id = " . $data['agent_id'];
                    $query = $this->db->query($mysql);
                    $data['faq_result'] = $query->result();
                    $data['faq_table'] = $this->table->generate($query);
                    $this->load->view('bko/configure/extra/faq_form', $data);
                    break;

                    case "CRONJOBS":
                        $this->load->library('table');
                        $this->table->set_template($this->template);
                        $mysql = "SELECT * FROM cron_jobs ORDER BY updated desc"; // WHERE agent_id = " . $data['agent_id'];
                        $query = $this->db->query($mysql);
                        $data['cron_jobs_result'] = $query->result();
                        $data['cron_jobs_table'] = $this->table->generate($query);
                        $this->load->view('bko/configure/extra/cron_jobs', $data);                        
                        break;
                case "GENCOUPONS":
                        $this->load->view('bko/configure/extra/gen_coupons', $data);
                    break;

                default:
                    echo "Your favorite color is neither red, blue, nor green!";
            }
        }
    }

   //define('WRENCHBOARD_COUPON_CREATE',  85010);
    public function addCoupons(){

        echo 'Ameye....';

        if ($_GET) {
            $amount = $this->input->get('amount');
            $quantity = trim($this->input->get('quantity'));

            if($amount !='' & $quantity !='' & $quantity > 0  ){
                $this->load->model('backend_model');
                $data['action'] = WRENCHBOARD_COUPON_CREATE;
                $out = array();
                $result ='';
                for ($i = 1; $i <= $quantity; $i++) {
                    $data['amount'] = $amount*100;
                    $data['code'] = strtoupper( $this->getCouponsCode(10) );
                    $data['description'] = "Back Office Coupons Gen";
                    $res = $this->backend_model->wrenchboard_api($data, $out);
                    $result .=  $data['code']." - ".$res."  \n";
                }

                echo $result;
            }
            else{
                echo 'Not Generated';
            }
        }
    }

    private function getCouponsCode($n) {
        $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
        $randomString = '';

        for ($i = 0; $i < $n; $i++) {
            $index = rand(0, strlen($characters) - 1);
            $randomString .= $characters[$index];
        }

        return $randomString;
    }

    public function allowCountry(){

        if ($_GET) {
            $countyry_code = trim( $this->input->get('countyry_code') );
            $action = trim($this->input->get('action'));
            //echo "ameye-ameye 22 - ".$countyry_code;

         if($countyry_code !='' & $action !='' & $action == 1  ){
                $sql1 = "UPDATE country SET allow=now(), status = 1  WHERE code= '$countyry_code' ";
                $this->db->query($sql1);
                echo 'Updated';
            }
//            else{
//                echo 'Not Updated';
//            }

            if($countyry_code !='' & $action !='' & $action == 0  ){
                $sql1 = "UPDATE country SET allow=NULL,status = 0  WHERE code= '$countyry_code' ";
                $this->db->query($sql1);
                echo 'Disabled';
            }
//            else{
//                echo 'Not Updated';
//            }


        }
    }

    public function updateHelpfaq(){
        if ($_GET) {
            $faq_id = $this->input->get('faq_id');
            $title = trim($this->input->get('title'));
            $faq_uid = trim($this->input->get('faq_uid'));
            $msg = trim($this->input->get('msg'));
            if($title !='' & $msg !='' & $faq_id > 0  ){
                $sql1 = "UPDATE help_items SET title='$title',contents='$msg' WHERE id =   $faq_id AND uid='$faq_uid' ";
                $this->db->query($sql1);
                echo 'Updated';
            }
            else{
                echo 'Not Updated';
            }
        }
    }

public function updatefaq(){
  
//  url: "/confg/updatefaq?faq_id=" + page_id + "&title=" + title + "&code=" + code + "&msg=" + msg
    if ($_GET) {
        $faq_id = $this->input->get('faq_id');
        $title = trim($this->input->get('title'));
        $code = trim($this->input->get('code'));
        $msg = trim($this->input->get('msg'));
        if($title !='' & $msg !='' & $faq_id > 0  ){
        $sql1 = "UPDATE faq SET title='$title',msg='$msg', code='$code' WHERE id =   $faq_id";
           $this->db->query($sql1); 
           echo 'Updated';
        }
        else{
            echo 'Not Updated';
        }
    }
}
    public function addSkill() {
        $data = array();
        
          $data['rkey'] = trim($this->input->get('page_id'));
          $data['skill_name'] = trim($this->input->get('skill_name'));

          $mysql = "SELECT * FROM skill_category WHERE LOWER(category) = LOWER('" . $data['skill_name'] . "')";
          $q = $this->db->query($mysql);
          $nr = $q->num_rows();
          if ($nr > 0) {
          echo 'Duplicate Detected';
          } else {
          // echo 'Now Insert';
          $mysql = "INSERT INTO skill_category  (category) VALUES('" . $data['skill_name'] . "')";
          $q = $this->db->query($mysql);
          }

     
        echo '0';
    }

    private function renderAdminPage($page_name, $data) {

        $this->load->view('bko/view_bko_header', $data);
        $this->load->view('bko/' . $page_name, $data);
        $this->load->view('bko/view_bko_footer', $data);
    }

}