[Summary view] [Print] [Text view]

   1  <?php /* $Id: select_contact_company.php 38 2008-02-11 11:38:51Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/contacts/select_contact_company.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  $table_name = w2PgetParam($_GET, 'table_name', 'companies');
   7  
   8  switch ($table_name) {
   9      case 'companies':
  10          $id_field = 'company_id';
  11          $name_field = 'company_name';
  12          $selection_string = 'Company';
  13          $filter = null;
  14          $additional_get_information = '';
  15          break;
  16      case 'departments':
  17          $id_field = 'dept_id';
  18          $name_field = 'dept_name';
  19          $selection_string = 'Department';
  20          $filter = 'dept_company = ' . (int)w2PgetParam($_GET, 'company_id', 0);
  21          $additional_get_information = 'company_id=' . w2PgetParam($_GET, 'company_id', 0);
  22          break;
  23  }
  24  
  25  $q = new DBQuery;
  26  $q->addTable($table_name);
  27  $q->addQuery($id_field . ', ' . $name_field);
  28  if ($filter != null) {
  29      $q->addWhere($filter);
  30  }
  31  $q->addOrder($name_field);
  32  if ($table_name == 'companies') {
  33      require_once ($AppUI->getModuleClass('companies'));
  34      $company = new CCompany;
  35      $company->setAllowedSQL($AppUI->user_id, $q);    
  36  } elseif ($table_name == 'departments') {
  37      require_once ($AppUI->getModuleClass('departments'));
  38      $department = new CDepartment;
  39      $department->setAllowedSQL($AppUI->user_id, $q);
  40  } 
  41  $company_list = array('0' => '') + $q->loadHashList();
  42  
  43  ?>
  44  
  45  <?php
  46  if (w2PgetParam($_POST, $id_field, 0) != 0) {
  47      $q = new DBQuery;
  48      $q->addTable($table_name);
  49      $q->addQuery('*');
  50      $q->addWhere($id_field . '=' . $_POST[$id_field]);
  51      $r_data = $q->loadHash();
  52      $q->clear();
  53      $data_update_script = '';
  54      $update_address = isset($_POST['overwrite_address']);
  55  
  56      if ($table_name == 'companies') {
  57          $update_fields = array();
  58          if ($update_address) {
  59              $update_fields = array('company_address1' => 'contact_address1', 'company_address2' => 'contact_address2', 'company_city' => 'contact_city', 'company_state' => 'contact_state', 'company_zip' => 'contact_zip', 'company_phone1' => 'contact_phone', 'company_phone2' => 'contact_phone2', 'company_fax' => 'contact_fax');
  60          }
  61          $data_update_script = 'opener.setCompany(\'' . $_POST[$id_field] . '\', \'' . db_escape($r_data[$name_field]) . "');\n";
  62      } else
  63          if ($table_name == 'departments') {
  64              $update_fields = array('dept_id' => 'contact_department');
  65              if ($update_address) {
  66                  $update_fields = array('dept_address1' => 'contact_address1', 'dept_address2' => 'contact_address2', 'dept_city' => 'contact_city', 'dept_state' => 'contact_state', 'dept_zip' => 'contact_zip', 'dept_phone' => 'contact_phone', 'dept_fax' => 'contact_fax');
  67              }
  68              $data_update_script = 'opener.setDepartment(\'' . $_POST[$id_field] . '\', \'' . db_escape($r_data[$name_field]) . "');\n";
  69          }
  70  
  71      // Let's figure out which fields are going to
  72      // be updated
  73      foreach ($update_fields as $record_field => $contact_field) {
  74          $data_update_script .= 'opener.document.changecontact.' . $contact_field . '.value = \'' . $r_data[$record_field] . "';\n";
  75      }
  76  ?>
  77              <script language='javascript'>
  78                  <?php echo $data_update_script; ?>
  79                  self.close();
  80              </script>
  81          <?php
  82  } else {
  83  ?>
  84          
  85          <form name="frmSelector" action="./index.php?m=contacts&a=select_contact_company&dialog=1&table_name=<?php echo $table_name . '&' . $additional_get_information; ?>" method="post">
  86  <br />
  87  <?php
  88      if (function_exists('styleRenderBoxTop')) {
  89          echo styleRenderBoxTop();
  90      }
  91  ?>
  92              <table width="100%" cellspacing="0" cellpadding="3" border="0" class="std">
  93              <tr>
  94                  <td colspan="2">
  95              <?php
  96      echo $AppUI->_('Select') . ' ' . $AppUI->_($selection_string) . ':<br />';
  97      echo arraySelect($company_list, $id_field, 'class="text" style="width:300px" size="10"', $company_id);
  98  ?>
  99                  </td>
 100              </tr>
 101              <tr>
 102                  <td colspan="2" align="left">
 103                      <input type="checkbox" name="overwrite_address" id="overwrite_address" /> <label for="overwrite_address"><?php echo $AppUI->_('Overwrite contact address information'); ?></label>
 104                  </td>
 105              </tr>
 106              <tr>
 107                  <td>
 108                      <input type="button" class="button" value="<?php echo $AppUI->_('cancel'); ?>" onclick="window.close()" />
 109                  </td>
 110                  <td align="right">
 111                      <input type="submit" class="button" value="<?php echo $AppUI->_('Select', UI_CASE_LOWER); ?>" />
 112                  </td>
 113              </tr>
 114              </table>
 115          </form>
 116      <?php
 117  }
 118  ?>