function convertfield ($result, $ISCcolumnname, $reserved) {
switch ($ISCcolumnname) {
case "ZVTH":
switch (conv(_odbc_result($result, 'ZVTH'))) {
case "-" : $housetype= 1; break;
case "Хру" : $housetype= 2; break;
case "МС" : $housetype= 3; break;
case "Улу" : $housetype= 4; break;
case "Ста" : $housetype= 5; break;
case "Эли" : $housetype= 6; break;
case "Гос" : $housetype= 7; break;
case "Мал" : $housetype= 8; break;
case "Лен" : $housetype= 9; break;
case "Ком" : $housetype=10; break;
case "Стф" : $housetype=11; break;
case "НС" : $housetype=12; break;
case "90" : $housetype=13; break;
default : $housetype= 1; break;
}
return $housetype;
break;
case "ZVMATER":
case "ZVMATERWALL":
switch (conv(_odbc_result($result, 'ZVMATER'))) {
case "-" : $wallsmaterial= 1; break;
case "Кир" : $wallsmaterial= 2; break;
case "Пан" : $wallsmaterial= 3; break;
case "Дер" : $wallsmaterial= 4; break;
case "Ком" : $wallsmaterial= 5; break;
case "Шла" : $wallsmaterial= 6; break;
case "Мон" : $wallsmaterial= 7; break;
case "Бре" : $wallsmaterial= 8; break;
case "Кар" : $wallsmaterial= 9; break;
case "ПБ" : $wallsmaterial=10; break;
default : $wallsmaterial= 1; break;
}
return $wallsmaterial;
break;
case "ZCONDITION":
case "ZCONDITIONID":
if ($t=="RoomsSell") {
$condition=1;
} else {
switch (conv(_odbc_result($result, 'ZCONDITION'))) {
case ('1303'): $condition=2; break;
case ('1304'): $condition=3; break;
case ('1305'): $condition=4; break;
case ('1306'): $condition=5; break;
case ('1307'): $condition=6; break;
case ('812' ): $condition=1; break;
case ('823' ): $condition=2; break;
case ('822' ): $condition=3; break;
case ('813' ): $condition=4; break;
case ('824' ): $condition=5; break;
case ('928' ): $condition=6; break;
case ('929' ): $condition=7; break;
case ('-1' ): $condition=1; break;
default : $condition=1; break;
}
}
return $condition;
break;
case "ZVPHONE":
switch (conv(_odbc_result($result, 'ZVPHONE'))) {
case ('-' ): $landline=2; break;
case ('+' ): $landline=3; break;
case ('IP'): $landline=4; break;
default : $landline=1; break;
}
return $landline;
break;
case "ZVWC":
switch (conv(_odbc_result($result, 'ZVWC'))) {
case ('-' ): $toilettype=1; break;
case ('Р' ): $toilettype=2; break;
case ('С' ): $toilettype=3; break;
case ('Т' ): $toilettype=4; break;
case ('2C'): $toilettype=5; break;
default : $toilettype=1; break;
}
return $toilettype;
break;
case "ZVPLAN":
switch (_odbc_result($result, 'ZVPLAN')) {
case('Изол.'): $layouttype=4; break;
case('Смежн'): $layouttype=3; break;
case('Трамв'): $layouttype=2; break;
default : $layouttype=1; break;
}
break;
case "ZVSELLTYPE":
switch (conv(_odbc_result($result, 'ZVSELLTYPE'))) {
case "-" : $selltypeid=1; break;
case "А" : $selltypeid=2; break;
case "П" : $selltypeid=3; break;
case "О" : $selltypeid=4; break;
case "Ч" : $selltypeid=5; break;
case "С" : $selltypeid=6; break;
case "ПО": $selltypeid=7; break;
default : $selltypeid=1; break;
}
return $selltypeid;
break;
case "ZVDOCS":
switch (conv(_odbc_result($result, 'ZVDOCS'))) {
case "Экскл." : $relationship=1; break;
case "Откр." : $relationship=2; break;
case "Без дог." : $relationship=3; break;
default : $relationship=4; break;
}
return $relationship;
break;
case "ZDOCSID":
switch (conv(_odbc_result($result, 'ZDOCSID'))) {
case "15" : $relationship=1; break;
case "16" : $relationship=2; break;
case "17" : $relationship=3; break;
default : $relationship=4; break;
}
return $relationship;
break;
case "ZVFROM":
switch (conv(_odbc_result($result, 'ZVFROM'))) {
case "Продавца" : $source=1; break;
case "АН" : $source=2; break;
case "Эксклюз." : $source=3; break;
case "Застройщик" : $source=4; break;
default : $source=5; break;
}
return $source;
break;
case "ZFROMID":
switch (conv(_odbc_result($result, 'ZFROMID'))) {
case "341" : $source=1; break;
case "342" : $source=2; break;
case "343." : $source=3; break;
case "344" : $source=4; break;
default : $source=5; break;
}
return $source;
break;
case "ZVSALETYPE":
$offertypeid = 0;
switch (conv(_odbc_result($result, 'ZVSALETYPE'))) {
case "Продаю" : $offertypeid=2; break;
case "Продажа" : $offertypeid=2; break;
case "Сдам в аренду" : $offertypeid=4; break;
case "Аренда" : $offertypeid=4; break;
case "Сдам в субаренду" : $offertypeid=6; break;
case "Меняю" : $offertypeid=7; break;
case "Аренда ПВ" : $offertypeid=8; break;
default : $offertypeid=1; break;
}
if ($offertypeid==0) echo "Unknown offertypeid: "._odbc_result($result, 'ZVSALETYPE');
return $offertypeid;
break;
case "ZVGARAGE":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVGARAGE'))) {
case "Нет" : $ret=2; break;
case "Встроенный" : $ret=3; break;
case "Отдельный" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVGARAGE result: "._odbc_result($result, 'ZVGARAGE');
return $ret;
break;
case "ZVBANIA":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVBANIA'))) {
case "Нет" : $ret=2; break;
case "Есть" : $ret=3; break;
case "Сауна" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVGARAGE result: "._odbc_result($result, 'ZVBANIA');
return $ret;
break;
case "ZVFLOOR":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVFLOOR'))) {
case "-" : $ret=1; break;
case "Бет" : $ret=2; break;
case "Дер" : $ret=3; break;
case "Гру" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVFLOOR result: "._odbc_result($result, 'ZVFLOOR');
return $ret;
break;
case "ZVROOF":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "Кир" : $ret=2; break;
case "Жел" : $ret=3; break;
case "Жл1" : $ret=4; break;
case "Бет" : $ret=5; break;
case "Залитая" : $ret=6; break;
case "Смешанная" : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVWHAT":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "Гараж" : $ret=2; break;
case "Участок" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVPOD":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "Асфальт" : $ret=2; break;
case "Грунт" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZCONDITIONID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "839" : $ret=2; break;
case "840" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZRIGHTBUILDID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "835" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZPROPISKAID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "837" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZTARGET":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "1047" : $ret=2; break;
case "1048" : $ret=3; break;
case "1049" : $ret=4; break;
case "1050" : $ret=5; break;
case "1051" : $ret=6; break;
case "1052" : $ret=7; break;
case "1053" : $ret=8; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVOWNING":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "частная" : $ret=2; break;
case "Фед." : $ret=4; break;
case "Мун." : $ret=5; break;
case "Вед." : $ret=6; break;
case "Ар.с пр.вык." : $ret=7; break;
case "Суб КУГИ" : $ret=8; break;
case "БСП" : $ret=9; break;
case "Не оф." : $ret=17; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZOTDELID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "209" : $ret=2; break;
case "210" : $ret=3; break;
case "211" : $ret=4; break;
case "212" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWALLSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "214" : $ret=2; break;
case "215" : $ret=3; break;
case "216" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZFLOORID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "218" : $ret=2; break;
case "219" : $ret=3; break;
case "220" : $ret=4; break;
case "221" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWCID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "230" : $ret=2; break;
case "231" : $ret=3; break;
case "232" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZGASID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "234" : $ret=2; break;
case "235" : $ret=3; break;
case "236" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZDOORSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "226" : $ret=2; break;
case "227" : $ret=3; break;
case "228" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWINDOWSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "223" : $ret=2; break;
case "224" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVHEAT":
case "ZVHEATING":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "нет" : $ret=2; break;
case "АГВ" : $ret=3; break;
case "котельная" : $ret=4; break;
case "паровое" : $ret=5; break;
case "комбинир." : $ret=6; break;
case "центр." : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZSECURITYID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "818" : $ret=3; break;
case "292" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZTYPEOWNINGID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "52" : $ret=2; break;
case "53" : $ret=3; break;
case "310" : $ret=1; break;
case "311" : $ret=4; break;
case "312" : $ret=5; break;
case "313" : $ret=6; break;
case "314" : $ret=7; break;
case "315" : $ret=8; break;
case "316" : $ret=9; break;
case "317" : $ret=17; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZSTANDID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "809" : $ret=2; break;
case "810" : $ret=3; break;
case "811" : $ret=4; break;
case "930" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZPLACEPUBLICID": // this list field in ISC to be converted to 1/0 in sl.
$ret = -1;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "819" : $ret=0; break;
case "820" : $ret=1; break;
default : $ret=0; break;
}
if ($ret==-1) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZINTERNETID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "804" : $ret=1; break;
case "805" : $ret=2; break;
case "806" : $ret=4; break;
case "807" : $ret=3; break;
case "808" : $ret=6; break;
case "825" : $ret=5; break;
case "827" : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZINSERTIONID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "814" : $ret=1; break;
case "815" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
default:
return (conv(_odbc_result($result, $ISCcolumnname)));
break;
}
}
function getagent($result) { // look for desired agent and return its ID. if not found then create one and return its ID. also manage company ID in similar way.
global $ca;
$debug = 0;
if ($debug) echo $sql_ag."<hr>";
$ret=new stdClass();
$zvagent = conv(_odbc_result($result, 'ZVAGENT'));
$zvagph = conv(_odbc_result($result, 'ZVAGPH'));
$zvcomp = conv(_odbc_result($result, 'ZVCOMP'));
$sql_ag="
SELECT `ID`
FROM `agentinfo`
WHERE
(`FirstName`='".$zvagent."') AND
( `Phone`='".$zvagph."')
LIMIT 0, 1
;
";
if ($debug) echo $sql_ag."<br>";
$row=$this->db->query_first($sql_ag);
$ret->lastid_agent = -1; // $row['ID'];
if ($debug) echo "Row: ".print_r($row,true)."<br>";
// if ($debug) echo "Row: ".print_r($row,true)."<br>";
if (!$row->ID) { // desired agent not found - we will create the new agent
if ($debug) echo "Adding agentinfo record.<br>";
// echo "MySQL Agent C: ".$row['ID'].", ";
// echo "MS Access zagentc: "._odbc_result($result, 'ZAGENTC')."<br>";
// find corresponding company
$sql_ag="SELECT `ID` FROM `companies` WHERE `Name`='".$zvcomp."' ; ";
$row=$this->db->query_first($sql_ag);
// echo "Company ID: ".$row['ID']."<br>";
if (!$row->ID) { // if not found then create
$sql_ag="INSERT INTO `companies` (`Name`, `IsTemplate`) VALUES ('".$zvcomp."','0') ; ";
if ($debug) echo $sql_ag."<br>";
$row=$this->db->exec($sql_ag);
$mar=$row->rowsAffected;
if ($debug) echo "Result: ".$mar."<br>";
// if ($debug) echo "Result: ".print_r($row,true)."<br>";
$ret->lastid_company=$row->lastInsertID;
} else { // if found then use it
$ret->lastid_company = $row->ID;
}
// echo "Company ID to insert to agentinfo: ".$lastid_company."<br>";
// $ret->lastid_agent = (int)_odbc_result($result, 'ZAGENTC');
if (!$ca) $ca=0;
$sql_ag="INSERT INTO `agentinfo`
(
".(($ret->lastid_agent==-1)?"":"`ID`,")."
`FirstName`,
`LastName`,
`Phone`,
`Email`,
`AuxPhone`,
`CompanyID`,
`Username`,
`Password`,
`LastAccess`
) VALUES (
".(($ret->lastid_agent==-1)?"":"'".$ret->lastid_agent."',")."
'".$zvagent."',
'',
'".$zvagph."',
'',
'',
'".$ret->lastid_company."',
'User_".$ca."',
'".md5("User_".$ca)."',
'".(date("Y-m-d H:i:s"))."'
) ;
";
// ajax_echo ($sql_ag."<br>");
if ($debug) echo $sql_ag."<br>";
$r=$this->db->exec($sql_ag);
// if ($debug) echo "Result: ".print_r($r,true)."<br>";
$mar=$r->rowsAffected;
if ($debug) echo "Result: ".$mar."<br>";
$ret->lastid_agent = $r->lastInsertID;
if ($mar>0) {
$ca++;
} else {
echo_r ("Cannot execute SQL statement: ".$sql_ag);
}
} else {
$ret->lastid_agent = $row->ID;
}
return $ret;
}
