$f = fopen($file, "w");
fwrite($f, serialize($array));
fclose($f);
}
$f = fopen("cuda_result_log", "r");
$i = 0;
while (!feof($f)) {
$str = fgets($f);
list($val_time, $rec_time, $resultid, $hostid, $userid, $teamid, $claimed, $granted, $desc) = sscanf($str, "%d %d %d %d %d %d %f %f %s");
add_to_array($hosts, $hostid, $granted);
add_to_array($users, $userid, $granted);
add_to_array($teams, $teamid, $granted);
add_to_array($descs, $desc, $granted);
if ($rec_time) {
$day = date("Y n j", $rec_time);
add_to_array($days, $day, $granted);
}
$i++;
if ($i % 10000 == 0) {
echo "{$i}\n";
}
}
uasort($hosts, "compare");
uasort($users, "compare");
uasort($teams, "compare");
uasort($descs, "compare");
write_array($hosts, "cuda_hosts.dat", 100);
write_array($users, "cuda_users.dat", 100);
write_array($teams, "cuda_teams.dat", 100);
write_array($descs, "cuda_models.dat", 0);
write_array($days, "cuda_days.dat", 0);
function get_expanded_data_for_supplier_list($ids)
{
global $db;
$ids_string = implode(',', $ids);
//echo $ids_string;
//exit;
$query = "SELECT relate_tbl.supplier_id supplier_id, activities_tbl.name name FROM `" . RELATE_SUPPLIERS_ACTIVITIES_TBL . "` relate_tbl \n\t\t INNER JOIN `" . SUPPLIERS_ACTIVITIES_TBL . "` activities_tbl\n\t\t\t\t ON relate_tbl.activity_id = activities_tbl.id\n\t\t\t\t WHERE relate_tbl.supplier_id IN (" . $ids_string . ")";
$result = mysql_query($query, $db);
if (mysql_num_rows($result) > 0) {
while ($item = mysql_fetch_assoc($result)) {
$arr[$item['supplier_id']]['activities'][] = $item['name'];
}
}
###################################################
function add_to_array($val, $type, &$array)
{
$val = trim($val);
if ($val == '') {
return;
}
if (!isset($array[$type])) {
$array[$type][] = $val;
} else {
if (in_array($val, $array[$type])) {
return;
}
$array[$type][] = $val;
}
}
###################################################
$query = "SELECT suppliers_tbl.id supplier_id, suppliers_tbl.phone phone, suppliers_tbl.email email, suppliers_tbl.web_site web_site, cont_faces_tbl.name name , cont_faces_tbl.phone phone2 , cont_faces_tbl.email email2 , cont_faces_tbl.isq_skype isq_skype FROM `" . SUPPLIERS_TBL . "` suppliers_tbl \n\t\t INNER JOIN `" . SUPPLIERS_CONT_FACES_TBL . "` cont_faces_tbl\n\t\t\t\t ON suppliers_tbl.id = cont_faces_tbl.supplier_id\n\t\t\t\t WHERE suppliers_tbl.id IN (" . $ids_string . ")";
$result = mysql_query($query, $db) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
while ($item = mysql_fetch_assoc($result)) {
$web_site = trim($item['web_site']) != '' ? '<a href="' . (strpos($item['web_site'], 'http://') === false ? 'http://' : '') . $item['web_site'] . '" target="_blank">' . $item['web_site'] . '</a>' : '';
//$web_site = $item['web_site'];
add_to_array($item['phone'], 'phones', $arr[$item['supplier_id']]);
add_to_array($item['phone2'], 'phones', $arr[$item['supplier_id']]);
add_to_array($item['email'], 'emails', $arr[$item['supplier_id']]);
add_to_array($item['email2'], 'emails', $arr[$item['supplier_id']]);
add_to_array($item['name'], 'contacts', $arr[$item['supplier_id']]);
add_to_array($item['isq_skype'], 'dop_data', $arr[$item['supplier_id']]);
add_to_array($web_site, 'dop_data', $arr[$item['supplier_id']]);
}
}
/**/
return $arr;
}
<?php
require 'PHPMailer-master/PHPMailerAutoload.php';
$conn = mysqli_connect('localhost', 'comauguste', 'Journey1', 'inventory_system');
if ($conn->connect_error) {
die('Error : (' . $conn->connect_errno . ')' . $conn->connect_error);
} else {
echo "Connected Successfully <br><br>";
}
$results = $conn->query("SELECT * FROM inventory_system.inventory_items where QUANTITY_IN_STOCK <= REORDER_LEVEL;");
if ($results == true) {
$array = array();
while ($row = $results->fetch_assoc()) {
add_to_array($array, $row['FK_USER_ID'], $row['PK_ITEM_ID']);
}
$keys = array_keys($array);
foreach ($keys as $key) {
$message = "The following product(s) are running low:<br>";
$mail = "";
$value = $array[$key];
$inner_keys = array_keys($value);
foreach ($inner_keys as $inner_key) {
$item_id = $value[$inner_key];
//print "Key : $key Value: $item_id <br>";
$result2 = $conn->query("SELECT * FROM inventory_system.inventory_items where PK_ITEM_ID = {$item_id} ");
$row = $result2->fetch_assoc();
$message2 = "Item Name:" . $row['ITEM_NAME'] . "| Remaining Stocks: " . $row['QUANTITY_IN_STOCK'] . "|Defined Reordering Treshold:" . $row['REORDER_LEVEL'] . "<br>";
$mail .= $message2;
}
echo $mail;
$message .= $mail;
