function get_data_by_stats($ws = false)
 {
     $ws_sql = $ws !== false ? " wa_status='" . $ws . "'" : "";
     $sql = "SELECT * FROM (\n\t\t\t\t\tSELECT count(idx) as total, propinsi, (\n\t\t\t\t\t\tCASE \n\t\t\t\t\t\t\tWHEN (wa_status=0) \n\t\t\t\t\t\t\tTHEN 'In Progress' \n\t\t\t\t\t\t\tWHEN (wa_status=1) \n\t\t\t\t\t\t\tTHEN 'Teregistrasi' \n\t\t\t\t\t\t\tWHEN (wa_status=2) \n\t\t\t\t\t\t\tTHEN 'Terverifikasi' \n\t\t\t\t\t\t\tELSE 'Tersertifikasi'  \n\t\t\t\t\t\tEND\n\t\t\t\t\t\t) AS wa_status\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\tv_wa_data\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t" . $ws_sql . "\n\t\t\t\t\t\tGROUP BY \n\t\t\t\t\t\t\tpropinsi,wa_status\n\t\t\t\t\t) stats\n\t\t\t\tORDER BY total";
     $arrData = $this->conn->GetAll($sql);
     pre($arrData);
 }

 function Example_Ajax()
 {
     global $page, $addonRelativeCode;
     //prepare the page
     $page->head_js[] = $addonRelativeCode . 'static/02_script.js';
     $page->admin_js = true;
     //get request parameters and execute any commands
     $string = '';
     if (isset($_REQUEST['string'])) {
         $string = $_REQUEST['string'];
     }
     $cmd = common::GetCommand();
     switch ($cmd) {
         case 'randomstring':
             $string = common::RandomString(10);
             break;
     }
     //display the form
     echo '<h2>Example Ajax Requests</h2>';
     echo '<form method="post" action="' . $page->title . '">';
     echo 'Text: <input type="text" name="string" value="' . htmlspecialchars($string) . '" size="30" />';
     echo ' <input type="submit" class="gpajax" value="Post Form Asynchronosly" /> ';
     echo common::Link($page->title, 'Get Random String', 'cmd=randomstring', 'name="gpajax"');
     echo '</form>';
     //output the $_REQUEST variable
     echo '<h3>Request</h3>';
     echo pre($_REQUEST);
     //plugin example navigation
     gpPlugin::incl('navigation.php');
     PluginExampleNavigation();
 }

 public function img()
 {
     $u_dados = $this->_upload();
     pre($u_dados);
     if ($u_dados->cod == 999) {
         echo '<img title="' . $u_dados->client_name . '" alt="' . $u_dados->client_name . '" src="' . base_url('imagens/' . $u_dados->name) . '" />';
     }
 }

function prj($input, $exit = false)
{
    if (is_string($input)) {
        $input = json_decode($input);
    }
    $input = json_encode($input, JSON_PRETTY_PRINT);
    pre($input, $exit);
}

 public static function dump($data, $dumptoScreen = false)
 {
     if ($dumptoScreen) {
         pre($data);
         die;
     }
     self::add_message('<xmp>' . print_r($data, 1) . '</xmp>');
 }

 public function execute()
 {
     $url = Config::getInstance()->get('interior.server_url');
     $connection = new Connection($url);
     $connection->usePost(false);
     pre($connection->get('knowledgepoint.get', array(), true));
     exit;
 }

 public function test_db()
 {
     //$conn=$this->conn;
     $conn = get_db_config("esirs");
     $conn->debug = true;
     $sql = "select * from airport";
     $arr = $conn->GetAll($sql);
     pre($arr);
 }

 public function test_action()
 {
     if ($this->user->logged()) {
         pre($this->user->data());
     }
     if ($this->user->request_recovery($this->uri->segment(3))) {
         echo $this->uri->segment(3);
     }
 }

 public function transform($value)
 {
     pre($value);
     exit;
     if ($value === null) {
         return '';
     }
     return $value->getId();
 }

 public function query($sql, array $params = array())
 {
     if (isset($_SESSION) && $_SESSION["debug"]) {
         pre($sql);
         pre($params);
     }
     $this->model->exec($sql, $params);
     return $this;
 }

 public function code_action()
 {
     $code = $this->uri->segment(2);
     $user = $this->user->check_recovery($code);
     if ($user) {
         pre($user);
     } else {
         echo "asd";
     }
 }

 function test()
 {
     echo $_SERVER['SERVER_ADDR'];
     die;
     $this->load->model('Order_model', 'order');
     //$rs=  $this->order->details(8);
     $rs = $this->order->get_all_chield_order(12);
     pre($rs);
     //pre(unserialize(base64_decode($rs[0]->orderInfo)));
 }

 function ae_send_admin_email($post_id)
 {
     $to = '[email protected]';
     $subject = 'A new post has been dropped.';
     $message = "Please Assign the editor to review the post: " . get_permalink($post_id);
     $send = wp_mail($to, $subject, $message);
     if ($send) {
         pre('sent');
     }
     pre('not sent');
 }

 public function main()
 {
     $this->model->id = 1;
     // get from request
     $book = $this->model->find();
     pre($book);
     $books = $this->model->findAll();
     $books = $this->model->findAll('id > ?', [0]);
     pre($books);
     // $this->view('main');
     // $this->view->display('main');
 }

    /**
     * @param $user_id
     * @return array|null
     */
    public function getUserInfo($user_id)
    {
        $sql = <<<SQL
SELECT * FROM {@auth_table} AS a LEFT JOIN {@profile_table} AS p ON a.`id` = p.`id` WHERE a.`id` = :id
SQL;
        $auth_table = UserAuthModel::getTableName();
        $profile_table = UserProfileModel::getTableName();
        $sql = strtr($sql, array('{@auth_table}' => $auth_table, '{@profile_table}' => $profile_table));
        pre($sql, false);
        $query = $this->getSelectQuery($sql, array(':id' => $user_id));
        return $query->getRow();
    }

 private function renderError(\Exception $e)
 {
     $response = response();
     if (app('config')['app']['debug']) {
         alert('Err... this is error: ' . $e->getMessage() . '<br>' . pre($e->getTraceAsString(), true), 'danger');
         $response->withContent(document());
     } else {
         $response->withContent(render(DIR_SYSTEM . '/views/error_500.php'));
         $response->withStatus(500);
     }
     return $response;
 }

 function data_rkp_peraturan()
 {
     $sql_rkp = "select 'propinsi' as batas_wilayah,1 as sort,tahun_peraturan as tahun,count(idx) as total from tb_batas_propinsi\r\n\t\t\t\t\tgroup by tahun_peraturan\r\n\t\t\t  union all\r\n\t\t\t  select 'kabupaten/kota' as batas_wilayah,2 as sort,tahun_peraturan as tahun,count(idx) as total from tb_batas_kabupaten\r\n\t\t\t\t\tgroup by tahun_peraturan";
     $sql_group = "select sort,batas_wilayah,group_concat(tahun,':',total order by tahun asc separator ',') as data from (" . $sql_rkp . ") a \r\n\t\t\t\t\tgroup by sort,batas_wilayah order by sort";
     //debug();
     $arrData = $this->conn->GetAll($sql_group);
     $data_header[] = "tahun";
     foreach ($arrData as $x => $val) {
         $data_header[] = $val["batas_wilayah"];
         $data_tmp_data = $this->parse_data($val["data"]);
         $arrData[$x]["data_per_tahun"] = $data_tmp_data;
     }
     pre($arrData);
 }

 public function execute()
 {
     $request = $this->getRequest();
     $model = $this->getModel('Course.Course');
     switch ($request->get('action')) {
         case 'edit':
             return $this->HTMLView('Course.Edit');
             break;
         case 'add':
             pre($request);
             die;
             break;
     }
 }

 /**
  * Set fields.
  * @param array $fields
  * @return Database_Query_Builder_Insert
  */
 public function setInsertFields(array $fields)
 {
     pre($fields);
     foreach ($fields as $key => $value) {
         if ($value === null) {
             $this->_fields[$key] = 'NULL';
         } elseif (strtolower($value) == 'now()') {
             $this->_fields[$key] = 'NOW()';
         } else {
             $this->_fields[$key] = "'" . $this->db->prepareString($value) . "'";
         }
     }
     return $this;
 }

 public static function createUser($user)
 {
     $db = new MongoDAO('users');
     $db = $db->c;
     $user = array();
     // This will come from a form , but here I used just for test
     $user['username'] = "milad";
     $user['password'] = "private";
     $hash = create_hash($user['username']);
     $user['password'] = md5(sha1($user['password']));
     $user['token'] = $hash['hash'];
     $user['salt'] = $hash['salt'];
     $res = $db->insert($user);
     pre($user);
 }