<? if (!empty($EnterpriseArr))
for ( $i = 0; $i < sizeof( $EnterpriseArr['ID_ENTERPRISE']); $i++ ) { ?>
<tr class='rowList item' style="cursor:pointer" onMouseOver="this.style.background = '#f0f5fa';" onMouseOut="this.style.background = '#e4eaf2';"
<? if(!$EnterpriseArr['ACTION'][$i]) echo'style="background-color:#cccccc"'; ?>
>
<a href="../Enterprise/Enterprise/ViewEnterprise/ViewEnterprise.php?id_enterprise=<? echo $EnterpriseArr['ID_ENTERPRISE'][$i] ?>">
<td valign="top"><? echo $EnterpriseArr['NAME_CALL'][$i] ?></td>
<td valign="top"><? echo $EnterpriseArr['NAME_SMALL'][$i] ?></td>
<td valign="top"><? echo $EnterpriseArr['NAME_ENTERPRISE'][$i] ?></td>
<td valign="top">
<?
if(!empty($EnterpriseArr['ENTERPRISE_ADDRESS'][$i]))
for ( $j = 0; $j < sizeof($EnterpriseArr['ENTERPRISE_ADDRESS'][$i]['ID_ENTERPRISE_ADDRESS']); $j++ ) {
if($j>0)echo '<hr style="height:1px; color:#ffffff;">';
if(!empty($EnterpriseArr['ENTERPRISE_ADDRESS'][$i]['ID_ENTERPRISE_ADDRESS']))
echo '<u>'.$EnterpriseArr['ENTERPRISE_ADDRESS'][$i]['NAME_TYPE_ADDRESS'][$j].'</u>: '.GetAddressEnterprise($EnterpriseArr['ENTERPRISE_ADDRESS'][$i]['ID_ENTERPRISE_ADDRESS'][$j],0); ;
}
?> </td>
<?
if(!empty($Fam)){
?>
<td valign="top">
<?
for ( $j = 0; $j < sizeof($EnterpriseArr['ENTERPRISE_EMPLOYEES'][$i]['ID_ENTERPRISE_EMPLOYEE']); $j++ ) {
echo $EnterpriseArr['ENTERPRISE_EMPLOYEES'][$i]['FAM'][$j].' '.substr($EnterpriseArr['ENTERPRISE_EMPLOYEES'][$i]['IMJ'][$j],0,1).'.'
.substr($EnterpriseArr['ENTERPRISE_EMPLOYEES'][$i]['OTCH'][$j],0,1).'. - '.$EnterpriseArr['ENTERPRISE_EMPLOYEES'][$i]['POST'][$j].'<br>';
}
?>
</td>
<?
$SQL_Rep .= " AND upper(Name_Small) like upper('%{$SerchName}%')";
}
if (!empty($Name)) {
$SerchName = str_replace(array(" ", "'"), array("%", "''"), $Name);
$SQL_Rep .= " AND upper(Name_Enterprise) like upper('%{$SerchName}%')";
}
if (!empty($Address)) {
$SerchName = str_replace(array(" ", "'"), array("%", "''"), $Address);
$SQL_Rep .= " AND Enterprise.ID_Enterprise in\r\n (\r\n SELECT ID_Enterprise\r\n\t\t\t FROM Enterprise_Address\r\n\t\t\t WHERE upper(Addr_Text) like upper('%{$SerchName}%')\r\n \t )";
}
$SQL_Rep .= " ORDER BY Name_Call";
$SQL_Rep = "SELECT Enterprise.ID_Enterprise,Name_Call,Callsign, Name_Small,Name_Enterprise\r\n \t FROM Enterprise " . $SQL_From . "\r\n\t \tWHERE Enterprise.Action = 1 \r\n\t \tAND Enterprise.ID_Enterprise > 0 " . $SQL_Rep;
$SQL_Rep = 'SELECT * FROM (' . $SQL_Rep . ') WHERE ROWNUM <= 100';
$Res = Query(0, $SQL_Rep);
while (F_OCIFetch($Res)) {
$EnterpriseID = F_OCIResult($Res, 'ID_ENTERPRISE');
$EnterpriseID_Arr[] = $EnterpriseID;
$EnterpriseNameCall_Arr[] = F_OCIResult($Res, 'NAME_CALL');
$EnterpriseNameSmall_Arr[] = F_OCIResult($Res, 'NAME_SMALL');
$EnterpriseName_Arr[] = F_OCIResult($Res, 'NAME_ENTERPRISE');
$Callsign_Arr[] = F_OCIResult($Res, 'CALLSIGN');
$SQL_Rep = "SELECT ID_Enterprise_Address, Enterprise_address.ID_Type_Address, Name_Type_Address\r\n \t FROM Enterprise_address, Type_Address\r\n\t\t WHERE ID_Enterprise = {$EnterpriseID}\r\n\t\t AND Enterprise_address.ID_Type_Address = Type_Address.ID_Type_Address\r\n\t ORDER BY Enterprise_address.ID_Type_Address\r\n \t\t ";
$Res2 = Query(0, $SQL_Rep);
while (F_OCIFetch($Res2)) {
$EnterpriseAddressID[$EnterpriseID][] = F_OCIResult($Res2, 'ID_ENTERPRISE_ADDRESS');
$EnterpriseAddressIDText[$EnterpriseID][] = GetAddressEnterprise(F_OCIResult($Res2, 'ID_ENTERPRISE_ADDRESS'), 0);
$EnterpriseAddressType[$EnterpriseID][] = F_OCIResult($Res2, 'NAME_TYPE_ADDRESS');
}
}
}
include "SelectEnterprise_.php";
