Форум программистов [Powered by Invision Power Board]

Код


 private function create_sql_table()
  {
  
     $sql = $this->db->prepare("SELECT count(*) as count, s.case_num as case_num, 
     s.id_info_table as ser_id_info_table, s.familiy_service as ser_familiy_service, 
     s.date as ser_date, s.info as ser_info, s.progress as ser_progress, i.id as in_id,
     i.client_info as in_client_info, i.contract_info as in_contract_info, 
     i.pr_dep as in_pr_dep  FROM service as s, info as i 
     WHERE s.id_info_table=i.id GROUP BY s.id ORDER BY s.id"); 
     $sql->execute();
     $table = $sql->fetchAll();
  
     return $this->create_important_table($table);
}

Код


public function create_important_table($table)
{
$access = $this->user_info();
$count = $this->counts();

 $result ='<table class="potention">
    <tr>
     <td COLSPAN=';
     if ($access==1) {
     $result .='7';
     } else {
     $result .='6';
     }
     $result .=' class="info_table"><center>ВАЖНЫЕ</center></td>
     </tr>
     <tr>
     <td class="head"><center>Данные о клиенте</center></td>
     <td  class="head"><center>Данные по договору</center></td>
     <td class="head"><center>Кредитный договор</center></td>
     <td class="head"><center>Менеджер по работе с клиентами</center></td>
     <td  class="head"><center>Сервисный отдел</center></td>
     <td  class="head"><center>PR-отдел</center></td>';
     //if ($access==1 ) {
     //$result .='<td></td>';
     //}
     $result .='</tr>';
          
  if ($count == 0)
   {
     $result .='<tr>
     <td COLSPAN=5  class="info_table"><center>Нет важных записей</center></td>
     </tr>';
   }
  else
   {
   
  foreach($table as $row_table_id)    
  {
    $result .='<tr>
     <td '; 
     if ($access==1 or $access==2) { 
      $result .='class="js__p_edits_start" id="'.$row_table_id["in.id"].'" name_table="client_info"';
      }
      $result .='>'.$row_table_id[in.client_info].'</td>
     <td ';
     if ($access==1 or $access==2) {
     $result .='class="js__p_edits1_start" id="'.$row_table_id["in.id"].'" name_table="contract_info"';
     }
     $result .='>'.$row_table_id['in.contract_info'].'</td>
     <td ></td>
     <td ></td>
     <td '; 
     if ($access==1 or $access==3) {
     $result .='class="js__p_edits2_start" id="'.$row_table_id["in.id"].'" name_table="service_dep"';
     }
     $result .='> </td>
     <td ';
     //if ($access==1 or $access==4) {
     //$result .='class="js__p_pr_start" id="'.$row_table_id["id"].'" name_table="pr_dep"';
     //}
     //$result .='>'.$row_table_id['pr_dep'].'</td>';
     // if ($access==1) {
     // $result .='<td><a href="#" id="'.$row_table_id["id"].'" class="delete">удалить</a></td>';
     //}
    $result .='</tr>';
   } 
   }
    $result .='</table>';
    
    return $result; 
}