executeQuery($sql, $data_params); if ($deal_results === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } $regionSql = 'SELECT region_id, region_code, region FROM region'; $region_data = $pdoWrapperObj->executeQuery($regionSql, []); if ($region_data === false) { show_pdo_error($regionSql, $pdoWrapperObj->getLastStatement()); } $region_array = array(); foreach ($region_data as $region_row) { $region_array[$region_row['region_id']] = $region_row['region']; } ?>
| Company | Revenue | Region | Agreement Status | Contract Type | Distribution | Agreement Status Updated | Priority | Date Added | |
|---|---|---|---|---|---|---|---|---|---|
| =$deal_row['company']?> | =$deal_row['revenue']?> | //----------------------------------------------------------------------- if ($deal_row['region']) { $regionTemp = explode(',', $deal_row['region']); $regions = array(); if (is_array($regionTemp)) foreach ($regionTemp as $ij) if (array_key_exists($ij, $region_array)) array_push($regions, $region_array[$ij]); echo implode(', ', $regions); } ?> | =$deal_row['agreement_status']?> | =$deal_row['contract_type']?> | =ucwords($deal_row['dist_types'])?> | =$deal_row['aggrement_status_updated']?> | =$deal_row['priority']?> | =($deal_row['date_added'] ? date('Y-m-d',strtotime($deal_row['date_added'])) : '')?> | View |
| No new deals. | |||||||||