82 lines
2.2 KiB
PHP
82 lines
2.2 KiB
PHP
<?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);
|
|
}
|
|
}
|
|
|
|
?>
|