<?php

include "db.php";
include "table.php";

$query = "SELECT * FROM schools WHERE status = 'Active' ORDER BY school_name";
$schools = db_query($query);

$Schools = array();

while ($row = db_fetch_assoc($schools)) {
   $school_num = $row['record_num'];
   $entry = $row;

   $entry['name'] = $row['school_name'];
   $entry['work_phone'] = $row['phone'];
   $entry['web_address'] = $row['url'];

   $query = "SELECT * FROM school_contact_list WHERE school_num = $school_num ORDER BY sequence";
   $contacts = db_query($query);

   $schoolContacts = array();
   while ($row = db_fetch_assoc($contacts)) {
      $name = $row['contact_name'];
      list($row['first_name'],$row['name']) = explode(" ", $name, 2);
      $row['email'] = $row['contact_email'];
      $row['work_phone'] = $row['contact_phone'];
      $row['cell_phone'] = $row['contact_cell'];

      $schoolContacts[] = $row;
   }

   $entry['contacts'] = $schoolContacts;
   $Schools[] = $entry;
}

db_close($_DB);
$_DB = mysql_connect("web2-db",$db_uname,$db_pass);
db_query("USE crm_db");

$customer_num = 9;

$contactTable = new Table("contact");

echo(count($Schools)."\n");
for ($i = 0; $i < count($Schools); $i++) {
   $entry = $Schools[$i];

   $business_num = 0;
   $entry['customer_num'] = $customer_num;
   $entry['business_num'] = $business_num;
   $entry['contact_type'] = 'Business';
   $entry['user_num'] = 0;
   $entry['data_source_reference'] = $entry['record_num'];
   $entry['date_added'] = $entry['start_date'];
   $entry['public_private_flag'] = "Public";
   $entry['entry_status'] = "Active";

   $query = $contactTable->BuildInsert($entry);
   db_query($query);
   $business_num = db_insert_id();

   $schoolContacts = $entry['contacts'];
   for ($j = 0; $j < count($schoolContacts); $j++) {
      $entry = $schoolContacts[$j];

      $entry['customer_num'] = $customer_num;
      $entry['business_num'] = $business_num;
      $entry['contact_type'] = 'Contact';
      $entry['user_num'] = 0;
      $entry['data_source_reference'] = $entry['record_num'];
      $entry['date_added'] = $entry['start_date'];
      $entry['public_private_flag'] = "Public";
      $entry['entry_status'] = "Active";

      $query = $contactTable->BuildInsert($entry);
      db_query($query);
   }
}

?>