<?php
define("PROTECTED", "OFF");
include "../../../../include/security.php";
include "../../../../include/utils.php";
if (!$_SESSION["acc_kanc"]) {
die("<script>alert('Только для канцелярии!');window.history.go(-1);</script>");
}
if (isset($act)) {
$SQL_Rep = "INSERT INTO Enterprise ( id_enterprise, name_enterprise,name_small,phone,fax,url,action,email,\r\n\t\t\t\t\t\t\t\t\t\tname_call,callsign,id_enterprise_parent, note,id_ent_last_incarnation ) \r\n VALUES ( seq_id_enterprise.NEXTVAL,'{$name_enterprise}','{$name_small}','{$phone}','{$fax}','{$url}','1','{$email}',\r\n\t\t\t\t\t\t\t \t\t\t'{$name_call}','{$callsign}','{$id_enterprise_parent}', '{$note}','{$id_ent_last_incarnation}' )";
$Res = Query(0, $SQL_Rep);
$Res = Query(1, "SELECT seq_id_enterprise.currval id_enterprise FROM dual");
$id_enterprise = F_OCIResult($Res, "ID_ENTERPRISE");
F_OCICommit();
/*die("<script>alert('Запись добавлена!');window.location.href='../../../SearchEnterprise/SearchEnterprise.php?Name=".$name_enterprise."'</script>");*/
die("<script>alert('Запись добавлена!');window.location.href='../ViewEnterprise/ViewEnterprise.php?id_enterprise={$id_enterprise}';</script>");
}
$SQL_Rep = "SELECT *\r\n \t\tFROM form_owner\r\n\t\tWHERE action=1\r\n\t\tORDER BY name_form_small";
$form_owner = QueryA($SQL_Rep);
include "AddEnterprise_.php";
$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";
