<?php

class Forceonhold extends MY_Controller
{
   var $db_onedev;
   public function index()
   {
      echo "BRANCH API";
   }
   public function __construct()
   {
      parent::__construct();
      $this->db_onedev = $this->load->database("onedev", true);
   }
	
    function lookuppgbankbyname(){
        try {
            //# cek token valid
            if (! $this->isLogin) {
                $this->sys_error("Invalid Token");
                exit;
            }
    
            $prm = $this->sys_input;
		$pgbank = $prm['branch'];
            $all = $prm['all'];
            $limit = '';
            if($all == 'N'){
                $limit = ' LIMIT 10';
            }
            $number_limit = 10;
            $number_offset = ($prm['current_page'] - 1) * $number_limit ;
            $sql = "select COUNT(*) as total
                    from f_force_onhold 
                    JOIN m_mou ON M_MouID = F_ForceOnHoldM_MouID
                    WHERE
                     (M_MouNumber LIKE CONCAT('%','{$pgbank}','%') OR
				M_MouName LIKE CONCAT('%','{$pgbank}','%'))";
          //  $total = $this->db_onedev->query($sql,$sql_param)->row()->total;
          $query = $this->db_onedev->query($sql);
         // echo $this->db_onedev->last_query();
          $tot_count = 0;
          $tot_page = 0;
          if ($query) {
             $tot_count = $query->result_array()[0]["total"];
             $tot_page = ceil($tot_count/$number_limit);
          } else {
             $this->sys_error_db("f_force_onhold count", $this->db_onedev);
             exit;
          }
            
            $sql = "select F_ForceOnHoldID as id,
                M_CompanyID,
                CONCAT(M_CompanyName, ' [',M_CompanyNumber,']') as M_CompanyName,
                M_MouID,
                CONCAT(M_MouName, ' | Exp: ', DATE_FORMAT(M_MouEndDate,'%d-%m-%Y')) as M_MouDesc,
                M_MouName,
                f_force_onhold.*,
                M_StaffID,
                M_StaffName,
                DATE_FORMAT(F_ForceOnHoldCreated,'%d-%m-%Y') as tanggal,
                IF(F_ForceOnHoldIsActive = 'Y','On Hold','Batal') as status
                from f_force_onhold 
                JOIN m_mou ON M_MouID = F_ForceOnHoldM_MouID
                JOIN m_company ON M_CompanyID = M_MouM_CompanyID
                JOIN m_user ON M_UserID = F_ForceOnHoldUserID
                JOIN m_staff ON M_StaffID = M_UserM_StaffID
                WHERE
                 (M_MouNumber LIKE CONCAT('%','{$pgbank}','%') OR
            M_MouName LIKE CONCAT('%','{$pgbank}','%'))
                        GROUP BY F_ForceOnHoldID
                    ORDER BY F_ForceOnHoldID ASC
                    limit $number_limit offset $number_offset";
            $sql_param = array($search);
            $query = $this->db_onedev->query($sql);
           // echo $this->db_onedev->last_query();
            if ($query) {
                $rows = $query->result_array();
                
                
            } else {
              $this->sys_error_db("f_force_onhold select");
              exit;
            }
    
            $result = array ("total" => $tot_page, "total_filter"=>count($rows),"records" => $rows);
            $this->sys_ok($result);
    
        } catch(Exception $exc) {
            $message = $exc->getMessage();
            $this->sys_error($message);
        }
    }
   public function lookupregionalbyname()
   {
    try {
        //# cek token valid
        if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
        }

        $prm = $this->sys_input;
        $regional = $prm['regional'];
		$pgbank = $prm['pgbank'];
		$limit = '';
		if($all == 'N'){
			$limit = ' LIMIT 10';
        }
        $number_limit = 10;
        $number_offset = ($prm['current_page'] - 1) * $number_limit ;
		$sql = "select COUNT(*) as total
		FROM(SELECT *
                from s_regional
                LEFT JOIN f_force_onhold ON S_RegionalID = F_ForceOnHoldS_RegionalID AND F_ForceOnHoldIsActive = 'Y'
                where 
                S_RegionalName LIKE CONCAT('%','{$regional}','%') AND
				IFNULL(F_ForceOnHoldName,'') LIKE CONCAT('%','{$pgbank}','%') AND
                S_RegionalIsActive = 'Y'
				GROUP BY S_RegionalID) a";
        $sql_param = array($search);
      //  $total = $this->db_onedev->query($sql,$sql_param)->row()->total;
      $query = $this->db_onedev->query($sql);
      $tot_count = 0;
      $tot_page = 0;
      if ($query) {
         $tot_count = $query->result_array()[0]["total"];
         $tot_page = ceil($tot_count/$number_limit);
      } else {
         $this->sys_error_db("s_regional count", $this->db_onedev);
         exit;
      }
		
        $sql = "select S_RegionalID as id,
        S_RegionalName as name,
        S_RegionalName as namex,
        s_regional.*
                from s_regional 
                LEFT JOIN f_force_onhold ON S_RegionalID = F_ForceOnHoldS_RegionalID AND F_ForceOnHoldIsActive = 'Y'
                where 
                S_RegionalName LIKE CONCAT('%','{$regional}','%') AND
				IFNULL(F_ForceOnHoldName,'') LIKE CONCAT('%','{$pgbank}','%') AND
                S_RegionalIsActive = 'Y'
                GROUP BY S_RegionalID
                ORDER BY S_RegionalName ASC
                limit $number_limit offset $number_offset";
        $sql_param = array($search);
        $query = $this->db_onedev->query($sql);
		//echo $this->db_onedev->last_query();
        if ($query) {
            $rows = $query->result_array();
			
            
        } else {
          $this->sys_error_db("s_regional select");
          exit;
        }

        $result = array ("total" => $tot_page, "total_filter"=>count($rows),"records" => $rows);
        $this->sys_ok($result);

    } catch(Exception $exc) {
        $message = $exc->getMessage();
        $this->sys_error($message);
    }
   }
   public function addnewregional()
   {
    try {
        //# cek token valid
        if (! $this->isLogin) {
			$this->sys_error("Invalid Token");
			exit;
        }

        //# ambil parameter input
        $prm = $this->sys_input;
        $name = $prm['name'];
            $sql = "insert into s_regional(
                S_RegionalName,	
                S_RegionalCreated,	
                S_RegionalLastUpdated
				) 
				values( ?, now(), now())";
			$query = $this->db_onedev->query($sql,
				array(
                    $name
				)
			);
			//echo $query;
			if (!$query) {
				$this->sys_error_db("s_regional insert");
				exit;
            } 
            $last_id = $this->db_onedev->insert_id();
			$result = array ("total" => 1, "records" => array("xid" => 0));
            $this->sys_ok($result);
            $last_id = $this->db_onedev->insert_id();
        
            
        
            
    } catch(Exception $exc) {
        $message = $exc->getMessage();
        $this->sys_error($message);
    }
   }
   
   public function editregional()
   {
    try {
        //# cek token valid
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }

        //# ambil parameter input
        $prm = $this->sys_input;
        $id = $prm['id'];
		$name = $prm['name'];
        $userid = $this->sys_user["M_UserID"];
            $sqlcompany = "update s_regional SET 
            S_RegionalName = ?,
            S_RegionalLastUpdated = now()
                where
                S_RegionalID = ?
                ";
            $querycompany = $this->db_onedev->query($sqlcompany,
                array(
                    $name,
                  $id
                )
            );
          //  echo $query;
            if (!$querycompany) {
                $this->sys_error_db("s_regional update");
                exit;
            } 
            $result = array ("total" => 1, "records" => array("xid" => $id));
            $this->sys_ok($result);  
        
           
    } catch(Exception $exc) {
        $message = $exc->getMessage();
        $this->sys_error($message);
    }
   }
   public function addnewpgbank()
   {
      try {
         //# cek token valid
         if (! $this->isLogin) {
            $this->sys_error("Invalid Token");
            exit;
         }

         //# ambil parameter input
         $prm = $this->sys_input;
         $F_ForceOnHoldM_MouID = $prm['mouid'];
         $F_ForceOnHoldNote = $prm['note'];
         $userid = $this->sys_user["M_UserID"];

                   
            if($prm['xid'] == 0){
                    $sql = "insert into f_force_onhold(
                        F_ForceOnHoldM_MouID,	
                        F_ForceOnHoldNote,		
                        F_ForceOnHoldCreated,	
                        F_ForceOnHoldLastUpdated,	
                        F_ForceOnHoldUserID)
                     values(?,?,now(),now(),?)";
        $query = $this->db_onedev->query($sql,
        array(
            $F_ForceOnHoldM_MouID,	
            $F_ForceOnHoldNote,		
            $userid)
        );
        if (!$query) {
        $this->sys_error_db("f_force_onhold insert",$this->db_onedev);
        exit;
        }
        $last_id = $this->db_onedev->insert_id();
        $sql = "UPDATE m_mou SET M_MouIsActive = 'F'
        WHERE M_MouID = '{$F_ForceOnHoldM_MouID}'";
      // echo $sql;
      $query = $this->db_onedev->query($sql);
        $result = array ("total" => 1, "records" => array("xid" => 0));
        $this->sys_ok($result);
                        
                            
          }else{
                $sql = "UPDATE f_force_onhold SET F_ForceOnHoldM_MouID = '{$F_ForceOnHoldM_MouID}',
                F_ForceOnHoldNote = '{$F_ForceOnHoldNote}',
                F_ForceOnHoldUserID = '{$userid}',	
               F_ForceOnHoldLastUpdated = now()
                WHERE F_ForceOnHoldID = '{$prm['xid']}'";
               //echo $sql;
              $query = $this->db_onedev->query($sql);
              $result = array ("total" => 1, "records" => array("xid" => 0));
              $this->sys_ok($result);
             
                 
             
          }
         
         

      } catch(Exception $exc) {
         $message = $exc->getMessage();
         $this->sys_error($message);
      }
   }
   
   public function deleteregional()
   {
    try {
        //# cek token valid
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }

        //# ambil parameter input
        $prm = $this->sys_input;
        $userid = $this->sys_user["M_UserID"];
        $sql = "update s_regional SET 
        S_RegionalIsActive = 'N',
        S_RegionalLastUpdated = now()
				WHERE
				S_RegionalID = ?
            
				";

            $query = $this->db_onedev->query($sql,
                array(
                    $prm['id']
                )
            );
           // echo $query;
            if (!$query) {
                $this->sys_error_db("s_regional delete");
                exit;
            } 
            $sql = "update f_force_onhold SET 
            F_ForceOnHoldIsActive = 'N',
            F_ForceOnHoldLastUpdated = now()
                    WHERE
                    F_ForceOnHoldS_RegionalID = ?
                
                    ";
    
                $query = $this->db_onedev->query($sql,
                    array(
                        $prm['id']
                    )
                );
               // echo $query;
                if (!$query) {
                    $this->sys_error_db("f_force_onhold delete");
                    exit;
                } 
                
                    
        $result = array ("total" => 1, "records" => array("xid" => 0));
        $this->sys_ok($result);

    } catch(Exception $exc) {
        $message = $exc->getMessage();
        $this->sys_error($message);
    }
   }
   public function deletepgbank()
   {
    try {
        //# cek token valid
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }

        //# ambil parameter input
        $prm = $this->sys_input;
        $fid = $prm['id'];
        $sql = $this->db_onedev->query("SELECT F_ForceOnHoldM_MouID as mouid from 
        f_force_onhold
        WHERE F_ForceOnHoldID = $fid")->row();
        $mouid = $sql->mouid;

        $userid = $this->sys_user["M_UserID"];
            $sql = "update f_force_onhold SET 
            F_ForceOnHoldIsActive = 'N',
            F_ForceOnHoldLastUpdated = now()
                    WHERE
                    F_ForceOnHoldID = ?
                
                    ";
    
                $query = $this->db_onedev->query($sql,
                    array(
                        $prm['id']
                    )
                );
               // echo $query;
                if (!$query) {
                    $this->sys_error_db("f_force_onhold delete");
                    exit;
                } 

                $sql = "update m_mou SET 
                M_MouIsActive = 'Y'
                        WHERE
                        M_MouID = ? AND M_MouIsActive = 'F'";
        
                    $query = $this->db_onedev->query($sql,
                        array(
                            $mouid
                        )
                    );
        $result = array ("total" => 1, "records" => array("xid" => 0));
        $this->sys_ok($result);

    } catch(Exception $exc) {
        $message = $exc->getMessage();
        $this->sys_error($message);
    }
   }
   function searchcompany(){
    if (! $this->isLogin) {
    $this->sys_error("Invalid Token");
    exit;
    }
    $prm = $this->sys_input;

    $max_rst = 12;
    $tot_count =0;

    $q = [
            'search'     => '%'
    ];

    if ($prm['tes'] != '')
    {
            $q['search'] = "%{$prm['tes']}%";
    }

      // QUERY TOTAL
    $sql = "SELECT count(*) as total
                    FROM m_company
                    WHERE
                    CONCAT(M_CompanyName, ' [',M_CompanyNumber,']') like ?
                    AND M_CompanyIsActive = 'Y'";
    $query = $this->db_onedev->query($sql,$q['search']);
    //echo $query;
    if ($query) {
       $tot_count = $query->result_array()[0]["total"];
    }
    else {
       $this->sys_error_db("m_company count",$this->db_onedev);
       exit;
    }

    $sql = "
            SELECT *, CONCAT(M_CompanyName, ' [',M_CompanyNumber,']') as M_CompanyName
            FROM m_company
            WHERE
            CONCAT(M_CompanyName, ' [',M_CompanyNumber,']') like ?
            AND M_CompanyIsActive = 'Y'
            ORDER BY M_CompanyName DESC
      ";
    $query = $this->db_onedev->query($sql, array($q['search']));

    if ($query) {
       $rows = $query->result_array();
       //echo $this->db_onedev->last_query();
       $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
       $this->sys_ok($result);
    }
    else {
       $this->sys_error_db("m_company rows",$this->db_onedev);
       exit;
    }
}
function getmou(){
  $prm = $this->sys_input;
  $query ="SELECT M_MouID,
  M_MouName,
  CONCAT(M_MouName, ' | Exp: ', DATE_FORMAT(M_MouEndDate,'%d-%m-%Y')) as M_MouDesc,
  M_MouAgingDay,
  M_MouPicBillName,
  M_MouPicBillHandphone,
  M_MouPicBillEmail,
  M_MouFinanceName,
  M_MouFinanceHandphone,
  CONCAT(M_MouPicBillEmail,' , ', M_MouFinanceEmail) as M_MouFinanceEmail
     FROM m_mou
     WHERE
     M_MouIsActive = 'Y' AND M_MouM_CompanyID = ?
";
  //echo $query;
  $rows = $this->db_onedev->query($query,array($prm['id']))->result_array();

  $result = array(
     "total" => count($rows) ,
     "records" => $rows,
  );
  $this->sys_ok($result);
  exit;
}
    function searchakun(){
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }
        $prm = $this->sys_input;
    
        $max_rst = 12;
        $tot_count =0;
    
        $q = [
            'search'     => '%'
        ];
    
        if ($prm['tes'] != '')
        {
            $q['search'] = "%{$prm['tes']}%";  
        }
    
          // QUERY TOTAL
        $sql = "SELECT count(*) as total
                FROM m_mou
                WHERE 
                M_MouNumber like ?
                AND M_MouIsActive = 'Y'";
        $query = $this->db_onedev->query($sql,$q['search']);
        //echo $query;
        if ($query) { 
            $tot_count = $query->result_array()[0]["total"]; 
        } 
        else {
            $this->sys_error_db("m_mou count",$this->db_onedev);
            exit;
        }
    
        $sql = "
        SELECT M_MouID,CONCAT(M_MouName, ' [',M_MouNumber,'] ') as M_MouNumber
        FROM m_mou
             
            JOIN nat_bank ON Nat_BankID = M_MouNat_BankID
            WHERE
            CONCAT(M_MouName, ' [',M_MouNumber,'] ') like ?
            AND M_MouIsActive = 'Y'
            ORDER BY M_MouName ASC
          ";
          $query = $this->db_onedev->query($sql, array($q['search']));
            
          if ($query) { 
             $rows = $query->result_array();
             //echo $this->db_onedev->last_query();
             $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
             $this->sys_ok($result);
          } 
          else {
             $this->sys_error_db("m_mou rows",$this->db_onedev);
             exit;
          }
    }
    function selectpaymenttype(){
        
            try {
                //# cek token valid
                if (! $this->isLogin) {
                    $this->sys_error("Invalid Token");
                    exit;
                }
                $rows = [];
                $query ="	SELECT * 
                            FROM m_paymenttype 
                            WHERE	
                            M_PaymentTypeIsActive = 'Y'
                        ";
                        //echo $query;
                $rows['paymenttypes'] = $this->db_onedev->query($query)->result_array();
                
            
                $result = array(
                    "total" => count($rows) , 
                    "records" => $rows, 
                ); 
                $this->sys_ok($result);
        
        
            } catch(Exception $exc) {
                $message = $exc->getMessage();
                $this->sys_error($message);
            }
            
        }
    function searchregionalbyname(){
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }
        $prm = $this->sys_input;
    
        $max_rst = 12;
        $tot_count =0;
    
        $q = [
            'search'     => '%'
        ];
    
        if ($prm['search'] != '')
        {
            $q['search'] = "%{$prm['search']}%";  
        }
    
          // QUERY TOTAL
        $sql = "SELECT count(*) as total
                FROM s_regional
                WHERE 
                S_RegionalName like ?
                AND S_RegionalIsActive = 'Y'";
        $query = $this->db_onedev->query($sql,$q['search']);
        //echo $query;
        if ($query) { 
            $tot_count = $query->result_array()[0]["total"]; 
        } 
        else {
            $this->sys_error_db("s_regional count",$this->db_onedev);
            exit;
        }
    
        $sql = "
        SELECT S_RegionalID, S_RegionalName
        FROM s_regional
            WHERE 
            S_RegionalName like ?
            AND S_RegionalIsActive = 'Y'
            ORDER BY S_RegionalName ASC
          ";
          $query = $this->db_onedev->query($sql, array($q['search']));
            
          if ($query) { 
             $rows = $query->result_array();
             //echo $this->db_onedev->last_query();
             $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
             $this->sys_ok($result);
          } 
          else {
             $this->sys_error_db("s_regional rows",$this->db_onedev);
             exit;
          }
    }
    
    
    function searchpaymenttype(){
        if (! $this->isLogin) {
        $this->sys_error("Invalid Token");
        exit;
        }
        $prm = $this->sys_input;
    
        $max_rst = 12;
        $tot_count =0;
    
        $q = [
            'search'     => '%'
        ];
    
        if ($prm['search'] != '')
        {
            $q['search'] = "%{$prm['search']}%";  
        }
    
          // QUERY TOTAL
        $sql = "SELECT count(*) as total
                FROM m_paymenttype
                WHERE 
                M_PaymentTypeName like ?
                AND M_PaymentTypeIsActive = 'Y'";
        $query = $this->db_onedev->query($sql,$q['search']);
        //echo $query;
        if ($query) { 
            $tot_count = $query->result_array()[0]["total"]; 
        } 
        else {
            $this->sys_error_db("t_subcategory count",$this->db_onedev);
            exit;
        }
    
        $sql = "
            SELECT M_PaymentTypeID, M_PaymentTypeName
            FROM  m_paymenttype
            WHERE 
            M_PaymentTypeName like ?
            AND M_PaymentTypeIsActive = 'Y'
            ORDER BY M_PaymentTypeName ASC
          ";
          $query = $this->db_onedev->query($sql, array($q['search']));
            
          if ($query) { 
             $rows = $query->result_array();
             //echo $this->db_onedev->last_query();
             $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
             $this->sys_ok($result);
          } 
          else {
             $this->sys_error_db("t_subcategory rows",$this->db_onedev);
             exit;
          }
    }

function searchdistrict(){
    if (! $this->isLogin) {
    $this->sys_error("Invalid Token");
    exit;
    }
    $prm = $this->sys_input;
    $id = $prm['id'];

    $max_rst = 12;
    $tot_count =0;

    $q = [
        'search'     => '%'
    ];

    if ($prm['search'] != '')
    {
        $q['search'] = "%{$prm['search']}%";  
    }

      // QUERY TOTAL
    $sql = "SELECT count(*) as total
            FROM m_district
            WHERE 
            M_DistrictName like ?
            AND M_DistrictT_SubCategoryID = '{$id}'
            AND M_DistrictIsActive = 'Y'";
    $query = $this->db_onedev->query($sql,$q['search']);
    //echo $query;
    if ($query) { 
        $tot_count = $query->result_array()[0]["total"]; 
    } 
    else {
        $this->sys_error_db("m_district count",$this->db_onedev);
        exit;
    }

    $sql = "
        SELECT *
        FROM m_district
        WHERE 
        M_DistrictName like ?
        AND M_DistrictT_SubCategoryID = '{$id}'
        AND M_DistrictIsActive = 'Y'
        ORDER BY M_DistrictName ASC
      ";
      $query = $this->db_onedev->query($sql, array($q['search']));
        
      if ($query) { 
         $rows = $query->result_array();
         //echo $this->db_onedev->last_query();
         $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
         $this->sys_ok($result);
      } 
      else {
         $this->sys_error_db("m_district rows",$this->db_onedev);
         exit;
      }
}
function searchkelurahan(){
    if (! $this->isLogin) {
    $this->sys_error("Invalid Token");
    exit;
    }
    $prm = $this->sys_input;
    $id = $prm['id'];

    $max_rst = 12;
    $tot_count =0;

    $q = [
        'search'     => '%'
    ];

    if ($prm['search'] != '')
    {
        $q['search'] = "%{$prm['search']}%";  
    }

      // QUERY TOTAL
    $sql = "SELECT count(*) as total
            FROM m_kelurahan
            WHERE 
            M_KelurahanName like ?
            AND M_KelurahanM_DistrictID = '{$id}'
            AND M_KelurahanIsActive = 'Y'";
    $query = $this->db_onedev->query($sql,$q['search']);
    //echo $query;
    if ($query) { 
        $tot_count = $query->result_array()[0]["total"]; 
    } 
    else {
        $this->sys_error_db("m_district count",$this->db_onedev);
        exit;
    }

    $sql = "
        SELECT *
        FROM m_kelurahan
        WHERE 
        M_KelurahanName like ?
        AND M_KelurahanM_DistrictID = '{$id}'
        AND M_KelurahanIsActive = 'Y'
        ORDER BY M_KelurahanName ASC
      ";
      $query = $this->db_onedev->query($sql, array($q['search']));
        
      if ($query) { 
         $rows = $query->result_array();
         //echo $this->db_onedev->last_query();
         $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
         $this->sys_ok($result);
      } 
      else {
         $this->sys_error_db("m_district rows",$this->db_onedev);
         exit;
      }
}

function searchmou(){
    if (! $this->isLogin) {
    $this->sys_error("Invalid Token");
    exit;
    }
    $prm = $this->sys_input;
    $id = $prm['id'];

    $max_rst = 12;
    $tot_count =0;

    $q = [
        'search'     => '%'
    ];

    if ($prm['search'] != '')
    {
        $q['search'] = "%{$prm['search']}%";  
    }

      // QUERY TOTAL
    $sql = "SELECT count(*) as total
            FROM m_mou
            WHERE 
            M_MouName like ?
            AND M_MouM_CompanyID = '{$id}'
            AND M_MouIsActive = 'Y'";
    $query = $this->db_onedev->query($sql,$q['search']);
    //echo $query;
    if ($query) { 
        $tot_count = $query->result_array()[0]["total"]; 
    } 
    else {
        $this->sys_error_db("m_mou count",$this->db_onedev);
        exit;
    }

    $sql = "SELECT *
        FROM m_mou
        WHERE 
        M_MouName like ?
        AND M_MouM_CompanyID = '{$id}'
        AND M_MouIsActive = 'Y'
        ORDER BY M_MouName ASC
      ";
      $query = $this->db_onedev->query($sql, array($q['search']));
        
      if ($query) { 
         $rows = $query->result_array();
       //  echo $this->db_onedev->last_query();
         $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
         $this->sys_ok($result);
      } 
      else {
         $this->sys_error_db("m_mou rows",$this->db_onedev);
         exit;
      }
}  
function searchdoctor(){
    if (! $this->isLogin) {
    $this->sys_error("Invalid Token");
    exit;
    }
    $prm = $this->sys_input;

    $max_rst = 12;
    $tot_count =0;

    $q = [
        'search'     => '%'
    ];

    if ($prm['search'] != '')
    {
        $q['search'] = "%{$prm['search']}%";  
    }

      // QUERY TOTAL
    $sql = "SELECT count(*) as total
            FROM(SELECT M_DoctorID, CONCAT(M_DoctorPrefix, ' ',M_DoctorName) as M_DoctorName
            FROM m_doctor
            WHERE M_DoctorIsActive = 'Y') a
                WHERE 
                M_DoctorName like ?";
    $query = $this->db_onedev->query($sql,$q['search']);
    //echo $query;
    if ($query) { 
        $tot_count = $query->result_array()[0]["total"]; 
    } 
    else {
        $this->sys_error_db("m_doctor count",$this->db_onedev);
        exit;
    }

    $sql = "SELECT * FROM(SELECT M_DoctorID, CONCAT(M_DoctorPrefix, ' ',M_DoctorName) as M_DoctorName
    FROM m_doctor
    WHERE M_DoctorIsActive = 'Y') a
        WHERE 
        M_DoctorName like ?
        GROUP BY M_DoctorID
        ORDER BY M_DoctorName ASC";
      $query = $this->db_onedev->query($sql, array($q['search']));
        
      if ($query) { 
         $rows = $query->result_array();
         //echo $this->db_onedev->last_query();
         $result = array("total" => $tot_count, "records" => $rows, "total_display" => sizeof($rows));
         $this->sys_ok($result);
      } 
      else {
         $this->sys_error_db("m_doctor rows",$this->db_onedev);
         exit;
      }
}
function selectaddressdoctor(){
    
        try {
            //# cek token valid
            if (! $this->isLogin) {
                $this->sys_error("Invalid Token");
                exit;
            }
            $prm = $this->sys_input;
            $id = $prm['id'];
            $rows = [];
            $query ="SELECT M_DoctorAddressID,
            CONCAT(M_DoctorAddressNote, ': ',M_DoctorAddressDescription) as M_DoctorAddressNote
            FROM
            m_doctoraddress
            WHERE M_DoctorAddressIsActive = 'Y' AND M_DoctorAddressM_DoctorID = '{$id}'";
                    //echo $query;
            $rows['addressdoctors'] = $this->db_onedev->query($query)->result_array();
            
        
            $result = array(
                "total" => count($rows) , 
                "records" => $rows, 
            ); 
            $this->sys_ok($result);
    
    
        } catch(Exception $exc) {
            $message = $exc->getMessage();
            $this->sys_error($message);
        }
        
    }
}