public static function joinTables($table1Data, $table2Data, $key = "")
{
$indexes = ZuoraAPIHelper::getTableJoinKeyIndexes($table1Data, $table2Data, $key);
return ZuoraAPIHelper::joinTablesWithIndexes($table1Data, $table2Data, $indexes[1], $indexes[2]);
/*
$index1 = -1;
$counter1 = 0;
$index2 = -1;
foreach($table1Data[0] as $header1) {
$counter2 = 0;
if (strlen($key) > 0) {
if (strcasecmp($key,$header1) != 0) {
// print "Key Found: " . $key . " != " . $header1 . "<br/>\n";
$counter1++;
continue;
}
// print "Key Found: " . $key . " == " . $header1 . "<br/>\n";
}
foreach ($table2Data[0] as $header2) {
// print "Header compare: " . $header1 . " == " . $header2 . "<br/>\n";
if (strcasecmp($header1,$header2) == 0) {
$key = $header1;
$index1 = $counter1;
$index2 = $counter2;
// print "Found Key: " . $key . ", index1: " . $index1 . ", index2: " . $index2 . "<br/>\n";
break;
}
$counter2++;
}
if ($index1 >= 0) {
break;
}
$counter1++;
}
$line = array();
// Create the header.
foreach($table1Data[0] as $header1) {
$line[] = $header1;
}
$counter = 0;
foreach ($table2Data[0] as $header2) {
$line[] = $header2;
$counter++;
}
$output[] = $line;
for ($i = 1; $i < count($table1Data); $i++) {
// Start the line
$line = array();
foreach($table1Data[$i] as $data1) {
$line[] = $data1;
}
$key1 = "";
if ($index1 >= 0) {
$key1 = $table1Data[$i][$index1];
}
for ($j = 1; $j < count($table2Data); $j++) {
$key2 = "";
if ($index2 >= 0) {
$key2 = $table2Data[$j][$index2];
}
$completeLine = $line;
// print "Data key compare: " . $key1 . " == " . $key2 . "<br/>\n";
if (strcasecmp($key1,$key2) == 0) {
// print "Data key found: " . $key1 . "<br/>\n";
$counter = 0;
foreach ($table2Data[$j] as $data2) {
$completeLine[] = $data2;
$counter++;
}
$output[] = $completeLine;
}
}
}
return $output;
*/
}
