$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;