start($db); $action = isset( $_REQUEST['q']) ? $_REQUEST['q'] : '' ; if(!$utility_class->isNotEmpty($action)){ header('location:role.php'); } $role_id = $db->escape($_REQUEST['q']); $company_name = $db -> select("SELECT name FROM `employee_role` WHERE status = 1 AND id = $role_id /*AND id <> 1*/"); if(!$utility_class->isNotEmpty($company_name)){ header('location:role.php'); } $hasAccessComponies = $db -> select("SELECT company_permissions FROM `employee_role_access` WHERE status = 1 AND employee_role_id = '$role_id'"); if($utility_class->isNotEmpty($hasAccessComponies)){ $hasAccessComponiesArray = (json_decode($hasAccessComponies)); }else{ $hasAccessComponiesArray =array(); } // var_dump( $hasAccessComponies); // $where_company_id =''; // $count_company_id = count((array)$hasAccessComponies); // echo $count_company_id; // if($count_company_id >1) // { $string = substr($hasAccessComponies, 1, -1); // Remove double quotes $company_ids = str_replace('"', '', $string); $where_company_id = ' AND scd.company_id IN ('.$company_ids.')'; // } // echo'
';print_r($hasAccessComponies);echo'
'; $hasAccessDealer = $db -> select("SELECT dealer_permissions FROM `employee_role_access` WHERE status = 1 AND employee_role_id = '$role_id'"); $hasAccessDealer = json_decode($hasAccessDealer); $is_all_check = 1; ?> <?php echo $variable['site_name']; ?> | Dealer Access

Dealer Access

  1. Home
  2. Dealer Access

Role Dealer Access

Dealership
sql_query("SELECT scd.company_id,scd.dealer_id,d.id AS dealer_id,d.code,d.name FROM source_company_dealer scd LEFT JOIN source_dealer AS d ON scd.dealer_id = d.id WHERE scd.type=1 AND d.status =1 $where_company_id GROUP BY d.id order BY d.name"); if($companies->num_rows>0){ foreach($companies as $company){ $checked = ""; if($hasAccessDealer!=null && in_array($company['dealer_id'],$hasAccessDealer)) { $checked = "checked"; }else{ $is_all_check = 0; } ?>
id="" json-modal="true" type="checkbox" class="company_access" name="permissions[company][]">