private function fun_NWMLS_InsertData($DataType, $arInsert)
{
//import db vars
$tmp_DB = $this->tmp_DB;
$tmp_Table = $this->tmp_Table_forProcess;
$ID_Name = $this->fun_NWMLS_getUniqueIDName($DataType);
//unique id for tmp table for retrieve data
//my db vars MY TABLE
$My_Table = $this->fun_NWMLS_getMyTable($DataType);
$My_DB = $this->My_DB;
$CountTotal = count($arInsert);
$Count = $CountTotal;
//insert records
foreach ($arInsert as $ID) {
echo "({$Count} of {$CountTotal}).Inserting[[ID:({$ID})";
//get the data to insert from the tmp table
$arData = fun_SQLQuery_InArray($tmp_DB, $tmp_Table, $ID, $OtherDBConn = "", $ID_Name);
//add DateCreated
$arData['DateCreated'] = strtotime("now");
unset($arData['ImportID']);
//don't need this field
//debug
//print_r($arData);
//Insert the data NOW
fun_MySQL_Insert_Data($My_DB, $My_Table, $arData, $New_Table_ID = "");
echo "]]Inserting\n";
$Count--;
}
return TRUE;
}
/**
* compare records - compares Table1 against Table2 like NWMLS_tables to My_tables
* @param string $DB1
* @param string $Table1
* @param string $TableID
* @param string $DB2
* @param string $Table2
* @param string $Table2ID
* @param string $OtherDBConn
*
* @returns mixed $arData3 which is a list of arData[Field] = Value, these are differences of the records
*/
function fun_Mysql_compareRecords($DB1, $Table1, $Table1ID, $ID_Name1, $DB2, $Table2, $Table2ID, $ID_Name2, $OtherDBConn = "")
{
//debug
//echo "\nfun_Mysql_compareRecords:[[DB1($DB1), Table1($Table1), Table1ID($Table1ID), IDName1($ID_Name1) - DB2($DB2), Table1($Table2), Table1ID($Table2ID), IDName2($ID_Name2)\n ";
$arData1 = fun_SQLQuery_InArray($DB1, $Table1, $Table1ID, $OtherDBConn, $ID_Name1);
//NwmlsData
$arData2 = fun_SQLQuery_InArray($DB2, $Table2, $Table2ID, $OtherDBConn, $ID_Name2);
//MyData
//debug
//print_r($arData1);
//print_r($arData2);
//die("\n\nWORKY????\n");
foreach ($arData1 as $Field => $Value) {
//debug
//echo "checking arData2[$Field]({$arData2[$Field]}) = $Value\n";
//is it different
if ($arData2[$Field] != $Value) {
$arData3[$Field] = $Value;
//debug
//echo "value1({$arData2[$Field]}) != value2($Value)\n";
}
unset($arData1[$Field]);
unset($arData2[$Field]);
}
//?? (backwards) compare the keys to see if any exists in my table that don't exist in table1?
//debug
//die("\nfun_Mysql_compareRecords: early death\n");
return $arData3;
}
