[Summary view] [Print] [Text view]

   1  <?php /* $Id: view.php 178 2008-07-17 15:03:35Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/companies/view.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  $company_id = intval(w2PgetParam($_GET, 'company_id', 0));
   7  
   8  // check permissions for this record
   9  $perms = &$AppUI->acl();
  10  
  11  $canEdit = $perms->checkModuleItem($m, 'edit', $company_id);
  12  $canRead = $perms->checkModuleItem($m, 'view', $company_id);
  13  
  14  if (!$canRead) {
  15      $AppUI->redirect('m=public&a=access_denied');
  16  }
  17  
  18  // retrieve any state parameters
  19  if (isset($_GET['tab'])) {
  20      $AppUI->setState('CompVwTab', $_GET['tab']);
  21  }
  22  $tab = $AppUI->getState('CompVwTab') !== null ? $AppUI->getState('CompVwTab') : 0;
  23  
  24  // check if this record has dependencies to prevent deletion
  25  $msg = '';
  26  $obj = new CCompany();
  27  $canDelete = $obj->canDelete($msg, $company_id);
  28  
  29  // load the record data
  30  $q = new DBQuery;
  31  $q->addTable('companies');
  32  $q->addQuery('companies.*');
  33  $q->addQuery('con.contact_first_name');
  34  $q->addQuery('con.contact_last_name');
  35  $q->leftJoin('users', 'u', 'u.user_id = companies.company_owner');
  36  $q->leftJoin('contacts', 'con', 'u.user_contact = con.contact_id');
  37  $q->addWhere('companies.company_id = ' . (int)$company_id);
  38  $obj = null;
  39  $q->loadObject($obj);
  40  $q->clear();
  41  
  42  if (!$obj) {
  43      $AppUI->setMsg('Company');
  44      $AppUI->setMsg('invalidID', UI_MSG_ERROR, true);
  45      $AppUI->redirect();
  46  } else {
  47      $AppUI->savePlace();
  48  }
  49  
  50  // load the list of project statii and company types
  51  $pstatus = w2PgetSysVal('ProjectStatus');
  52  $types = w2PgetSysVal('CompanyType');
  53  $countries = w2PgetSysVal('GlobalCountries');
  54  
  55  // setup the title block
  56  $titleBlock = new CTitleBlock('View Company', 'handshake.png', $m, "$m.$a");
  57  if ($canEdit) {
  58      $titleBlock->addCell();
  59      $titleBlock->addCell('<input type="submit" class="button" value="' . $AppUI->_('new company') . '" />', '', '<form action="?m=companies&a=addedit" method="post">', '</form>');
  60      $titleBlock->addCell('<input type="submit" class="button" value="' . $AppUI->_('new department') . '" />', '', '<form action="?m=departments&a=addedit&company_id=' . $company_id . '" method="post">', '</form>');
  61      $titleBlock->addCell('<input type="submit" class="button" value="' . $AppUI->_('new project') . '" />', '', '<form action="?m=projects&a=addedit&company_id=' . $company_id . '" method="post">', '</form>');
  62  }
  63  $titleBlock->addCrumb('?m=companies', 'company list');
  64  if ($canEdit) {
  65      $titleBlock->addCrumb('?m=companies&a=addedit&company_id=' . $company_id, 'edit this company');
  66  
  67      if ($canDelete) {
  68          $titleBlock->addCrumbDelete('delete company', $canDelete, $msg);
  69      }
  70  }
  71  $titleBlock->show();
  72  ?>
  73  <script language="javascript">
  74  <?php
  75  // security improvement:
  76  // some javascript functions may not appear on client side in case of user not having write permissions
  77  // else users would be able to arbitrarily run 'bad' functions
  78  if ($canDelete) {
  79  ?>
  80  function delIt() {
  81      if (confirm( '<?php echo $AppUI->_('doDelete') . ' ' . $AppUI->_('Company') . '?'; ?>' )) {
  82          document.frmDelete.submit();
  83      }
  84  }
  85  <?php } ?>
  86  </script>
  87  
  88  <table border="0" cellpadding="4" cellspacing="0" width="100%" class="std">
  89  
  90  <?php if ($canDelete) {
  91  ?>
  92  <form name="frmDelete" action="./index.php?m=companies" method="post">
  93      <input type="hidden" name="dosql" value="do_company_aed" />
  94      <input type="hidden" name="del" value="1" />
  95      <input type="hidden" name="company_id" value="<?php echo $company_id; ?>" />
  96  </form>
  97  <?php } ?>
  98  
  99  <tr>
 100      <td valign="top" width="50%">
 101          <strong><?php echo $AppUI->_('Details'); ?></strong>
 102          <table cellspacing="1" cellpadding="2" width="100%">
 103          <tr>
 104              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Company'); ?>:</td>
 105              <td class="hilite" width="100%"><?php echo $obj->company_name; ?></td>
 106          </tr>
 107          <tr>
 108              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Owner'); ?>:</td>
 109              <td class="hilite" width="100%"><?php echo $obj->contact_first_name . ' ' . $obj->contact_last_name; ?></td>
 110          </tr>
 111          <tr>
 112              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Email'); ?>:</td>
 113              <td class="hilite" width="100%"><?php echo $obj->company_email; ?></td>
 114          </tr>
 115          <tr>
 116              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Phone'); ?>:</td>
 117              <td class="hilite"><?php echo $obj->company_phone1; ?></td>
 118          </tr>
 119          <tr>
 120              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Phone'); ?>2:</td>
 121              <td class="hilite"><?php echo $obj->company_phone2; ?></td>
 122          </tr>
 123          <tr>
 124              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Fax'); ?>:</td>
 125              <td class="hilite"><?php echo $obj->company_fax; ?></td>
 126          </tr>
 127          <tr valign="top">
 128              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Address'); ?>:</td>
 129              <td class="hilite">
 130              <a href="http://maps.google.com/maps?q=<?php echo $obj->company_address1; ?>+<?php echo $obj->company_address2; ?>+<?php echo $obj->company_city; ?>+<?php echo $obj->company_state; ?>+<?php echo $obj->company_zip; ?>+<?php echo $obj->company_country; ?>" target="_blank">
 131              <img align="right" border="0" src="<?php echo w2PfindImage('googlemaps.gif'); ?>" width="55" height="22" alt="Find It on Google" /></a>
 132              <?php
 133                  echo $obj->company_address1 . (($obj->company_address2) ? '<br />' . $obj->company_address2 : '') . (($obj->company_city) ? '<br />' . $obj->company_city : '') . (($obj->company_state) ? '<br />' . $obj->company_state : '') . (($obj->company_zip) ? '<br />' . $obj->company_zip : '') . (($obj->company_country) ? '<br />' . $countries[$obj->company_country] : '');?>
 134              </td>
 135          </tr>
 136          <tr>
 137              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('URL'); ?>:</td>
 138              <td class="hilite">
 139                  <a href="http://<?php echo $obj->company_primary_url; ?>" target="Company"><?php echo $obj->company_primary_url; ?></a>
 140              </td>
 141          </tr>
 142          <tr>
 143              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Type'); ?>:</td>
 144              <td class="hilite"><?php echo $AppUI->_($types[$obj->company_type]); ?></td>
 145          </tr>
 146          </table>
 147  
 148      </td>
 149      <td width="50%" valign="top">
 150          <strong><?php echo $AppUI->_('Description'); ?></strong>
 151          <table cellspacing="0" cellpadding="2" border="0" width="100%">
 152          <tr>
 153              <td class="hilite">
 154                  <?php echo str_replace(chr(10), '<br />', $obj->company_description); ?>&nbsp;
 155              </td>
 156          </tr>
 157          
 158          </table>
 159          <?php
 160  require_once ($AppUI->getSystemClass('CustomFields'));
 161  $custom_fields = new CustomFields($m, $a, $obj->company_id, 'view');
 162  $custom_fields->printHTML();
 163  ?>
 164      </td>
 165  </tr>
 166  </table>
 167  
 168  <?php
 169  // tabbed information boxes
 170  $moddir = W2P_BASE_DIR . '/modules/companies/';
 171  $tabBox = new CTabBox('?m=companies&a=view&company_id=' . $company_id, '', $tab);
 172  $tabBox->add($moddir . 'vw_active', 'Active Projects');
 173  $tabBox->add($moddir . 'vw_archived', 'Archived Projects');
 174  $tabBox->add($moddir . 'vw_depts', 'Departments');
 175  $tabBox->add($moddir . 'vw_users', 'Users');
 176  $tabBox->add($moddir . 'vw_contacts', 'Contacts');
 177  $tabBox->show();
 178  ?>