/**
* Generate age data for age widget
*
* @author AvB
**/
function age()
{
// Authenticate
if (!$this->authorized()) {
die('Authenticate first.');
// Todo: return json?
}
$out = array();
$warranty = new Warranty_model();
// Time calculations differ between sql implementations
switch ($warranty->get_driver()) {
case 'sqlite':
$agesql = "CAST(strftime('%Y.%m%d', 'now') - strftime('%Y.%m%d', purchase_date) AS INT)";
break;
case 'mysql':
$agesql = "TIMESTAMPDIFF(YEAR,purchase_date,CURDATE())";
break;
default:
// FIXME for other DB engines
$agesql = "SUBSTR(purchase_date, 1, 4)";
}
$sql = "SELECT count(1) as count, \n\t\t\t\t{$agesql} AS age \n\t\t\t\tFROM warranty\n\t\t\t\tGROUP by age \n\t\t\t\tORDER BY age DESC";
$cnt = 0;
foreach ($warranty->query($sql) as $obj) {
$obj->age = $obj->age ? $obj->age : '<1';
$out[] = array('label' => $obj->age, 'data' => array(array(intval($obj->count), $cnt++)));
}
$obj = new View();
$obj->view('json', array('msg' => $out));
}
<div class="col-lg-4 col-md-6">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"><i class="fa fa-umbrella"></i> Warranty status</h3>
</div>
<div class="list-group scroll-box">
<?php
$warranty = new Warranty_model();
$sql = "SELECT count(id) as count, status from warranty group by status ORDER BY count DESC";
$class_list = array('Expired' => 'danger');
?>
<?php
foreach ($warranty->query($sql) as $obj) {
?>
<?php
$status = array_key_exists($obj->status, $class_list) ? $class_list[$obj->status] : 'default';
?>
<a href="<?php
echo url('show/listing/warranty#' . $obj->status);
?>
" class="list-group-item list-group-item-<?php
echo $status;
function get_gsx_stats(&$gsx_model)
{
// Error message
$error = '';
// Import gsxlib - https://github.com/filipp/gsxlib
// Set up variables
include_once conf('application_path') . 'lib/gsxlib/gsxlib.php';
$_ENV['GSX_CERT'] = conf('gsx_cert');
$_ENV['GSX_KEYPASS'] = conf('gsx_cert_keypass');
$sold_to = conf('gsx_sold_to');
$username = conf('gsx_username');
// Pull from gsxlib
$gsx = GsxLib::getInstance($sold_to, $username);
try {
$result = $gsx->warrantyStatus($gsx_model->serial_number);
} catch (Exception $e) {
// If obsolete, process and run stock warranty lookup
if ($e->getMessage() === "The serial number entered has been marked as obsolete. If you feel this is in error, please verify and re-enter the serial number.") {
// Load warranty_helper and run stock warranty functions
require_once conf('application_path') . 'helpers/warranty_helper.php';
$gsx_model->productdescription = model_description_lookup($gsx_model->serial_number);
$gsx_model->warrantystatus = 'Obsolete';
$gsx_model->warrantymod = 'Expired';
$gsx_model->partcovered = 'No';
$gsx_model->laborcovered = 'No';
$gsx_model->daysremaining = '0';
$gsx_model->isloaner = 'No';
$gsx_model->isobsolete = 'Yes';
$gsx_model->isvintage = 'No';
// Don't overwrite actual GSX data with guessed data
// For recently obsoleted machines
if (is_null($gsx_model->estimatedpurchasedate) || $gsx_model->estimatedpurchasedate === "") {
$gsx_model->estimatedpurchasedate = estimate_manufactured_date($gsx_model->serial_number);
}
if (is_null($gsx_model->coveragestartdate) || $gsx_model->coveragestartdate === "") {
$gsx_model->coveragestartdate = $gsx_model->estimatedpurchasedate;
}
if (is_null($gsx_model->registrationdate) || $gsx_model->registrationdate === "") {
$gsx_model->registrationdate = $gsx_model->estimatedpurchasedate;
}
if (is_null($gsx_model->coverageenddate) || $gsx_model->coverageenddate === "") {
$gsx_model->coverageenddate = date("Y-m-d", strtotime(date("Y-m-d", strtotime($gsx_model->estimatedpurchasedate)) . " + 365 day"));
}
$gsx_model->save();
$error = 'GSX Lookup failed - machine is Obsolete - running stock warranty lookup';
//check_status();
return $error;
} else {
return $e->getMessage();
}
}
// Catch GSX lookup fails
if ($result === FALSE) {
// Load warranty_helper and run stock warranty functions
require_once conf('application_path') . 'helpers/warranty_helper.php';
$gsx_model->warrantystatus = 'GSX lookup failed';
$gsx_model->productdescription = model_description_lookup($gsx_model->serial_number);
$gsx_model->warrantymod = "Lookup failed";
// Don't overwrite actual GSX data with guessed data
if (is_null($gsx_model->estimatedpurchasedate) || $gsx_model->estimatedpurchasedate === "") {
$gsx_model->estimatedpurchasedate = estimate_manufactured_date($gsx_model->serial_number);
}
if (is_null($gsx_model->coveragestartdate) || $gsx_model->coveragestartdate === "") {
$gsx_model->coveragestartdate = $gsx_model->estimatedpurchasedate;
}
if (is_null($gsx_model->registrationdate) || $gsx_model->registrationdate === "") {
$gsx_model->registrationdate = $gsx_model->estimatedpurchasedate;
}
if (is_null($gsx_model->coverageenddate) || $gsx_model->coverageenddate === "") {
$gsx_model->coverageenddate = date("Y-m-d", strtotime(date("Y-m-d", strtotime($gsx_model->estimatedpurchasedate)) . " + 365 day"));
}
$gsx_model->save();
$error = 'GSX Lookup failed - running stock warranty lookup';
return $error;
} else {
// Rename warranty status for stock warranty stuff
$local_warrantyStatus = str_replace(array('AppleCare Protection Plan', 'Out Of Warranty (No Coverage)', 'Apple Limited Warranty'), array('Supported', 'Expired', 'No Applecare'), $result->warrantyStatus);
// Coverage Status
if (empty($result->contractType)) {
$gsx_model->contracttype = "";
} else {
$gsx_model->contracttype = str_replace(array('LI', 'LP', 'RP', 'IR', 'LS', 'CC', 'CS', 'DO', 'MU', 'OO', 'PA', 'QP', 'RE', 'G9', 'RA', 'PP', 'C1', 'C2', 'C3', 'C4', 'C5', 'TC', 'PT', 'EC', 'CL', 'CP', 'CI', 'CW', 'VW', 'VP', 'RI', 'RW'), array('Apple Limited Warranty', 'Apple Limited Warranty', 'Repeat Service', 'Internal Repairs', 'Lost Shipments (Coverage)', 'Custom Bid Contracts', 'Customer Satisfaction (CS) Code', 'DOA Coverage', 'Missing Upon 1st Use', 'Out Of Warranty (No Coverage)', 'AppleCare Parts Agreement', 'Quality Program', 'Repeat Service', 'Pending Coverage Check', 'AppleCare Repair Agreement', 'AppleCare Protection Plan', 'AppleCare Protection Plan', 'AppleCare Parts Agreement', 'AppleCare Repair Agreement', 'Custom Bid Contracts', 'Extended Contract', 'Edu/Govt Warranty (Australia)', 'Additional Part Coverage', 'Additional Service Coverage', 'Consumer Law Coverage', 'Consumer Law Coverage', 'Consumer Law Repeat Coverage', 'Consumer Law Repeat Coverage', 'Variable Warranty', 'Variable Warranty', 'Variable Warranty Repeat', 'Variable Warranty Repeat'), $result->contractType);
}
// Fix for non-AppleCare machines
if (empty($result->contractCoverageEndDate)) {
$gsx_model->contractcoverageenddate = '';
} else {
$gsx_model->contractcoverageenddate = date('Y-m-d', strtotime($result->contractCoverageEndDate));
}
if (empty($result->contractCoverageStartDate)) {
$gsx_model->contractcoveragestartdate = '';
} else {
$gsx_model->contractcoveragestartdate = date('Y-m-d', strtotime($result->contractCoverageStartDate));
}
if (empty($result->laborCovered)) {
$gsx_model->laborcovered = 'No';
} else {
$gsx_model->laborcovered = str_replace(array('Y', 'N'), array('Yes', 'No'), $result->laborCovered);
}
if (empty($result->partCovered)) {
$gsx_model->partcovered = 'No';
} else {
$gsx_model->partcovered = str_replace(array('Y', 'N'), array('Yes', 'No'), $result->partCovered);
}
// Update the stock machine tables
$machine = new Machine_model($gsx_model->serial_number);
//$machine->img_url = $matches[1]; Todo: get image url for VM
$machine->machine_desc = $result->productDescription;
$machine->save();
// Translate gsxlib to MunkiReport DB
$gsx_model->warrantymod = $local_warrantyStatus;
$gsx_model->warrantystatus = $result->warrantyStatus;
$gsx_model->daysremaining = $result->daysRemaining;
$gsx_model->estimatedpurchasedate = date('Y-m-d', strtotime($result->estimatedPurchaseDate));
$gsx_model->purchasecountry = $result->purchaseCountry;
$gsx_model->registrationdate = date('Y-m-d', strtotime($result->registrationDate));
$gsx_model->productdescription = $result->productDescription;
$gsx_model->configdescription = $result->configDescription;
$gsx_model->isloaner = str_replace(array('Y', 'N'), array('Yes', 'No'), $result->isLoaner);
$gsx_model->isobsolete = 'No';
// Check if Vintage and write flag
$vintageCheck = substr($gsx_model->configdescription, 0, 3);
if ($vintageCheck === "VIN") {
$gsx_model->isvintage = 'Yes';
} else {
$gsx_model->isvintage = 'No';
}
// Fix for non-obsolete and out of warranty machines
if (empty($result->coverageEndDate)) {
if ($result->warrantyStatus === "Out Of Warranty (No Coverage)") {
if (empty($result->contractCoverageEndDate)) {
$gsx_model->coverageenddate = date("Y-m-d", strtotime(date("Y-m-d", strtotime($result->registrationDate)) . " + 365 day"));
} else {
$gsx_model->coverageenddate = date('Y-m-d', strtotime($result->contractCoverageEndDate));
}
} else {
$gsx_model->coverageenddate = date("Y-m-d", strtotime(date("Y-m-d", strtotime($result->registrationDate)) . " + 365 day"));
}
} else {
$gsx_model->coverageenddate = date('Y-m-d', strtotime($result->coverageEndDate));
}
if (empty($result->coverageStartDate)) {
if ($result->warrantyStatus === "Out Of Warranty (No Coverage)") {
$gsx_model->coveragestartdate = date('Y-m-d', strtotime($result->registrationDate));
} else {
$gsx_model->coveragestartdate = '';
}
} else {
$gsx_model->coveragestartdate = date('Y-m-d', strtotime($result->coverageStartDate));
}
// Service Level Agreement
// Fix for different warranty type returns from GSX
if (empty($result->warrantyReferenceNo)) {
$gsx_model->warrantyreferenceno = $result->slaGroupDescription;
} else {
$gsx_model->warrantyreferenceno = $result->warrantyReferenceNo;
}
// Update the stock warranty tables
$warranty = new Warranty_model($gsx_model->serial_number);
$warranty->purchase_date = $gsx_model->estimatedpurchasedate;
$warranty->end_date = $gsx_model->contractcoverageenddate;
$warranty->status = $local_warrantyStatus;
$warranty->save();
// Save that stuff :D
$gsx_model->save();
$error = 'GSX data processed';
return $error;
}
return $error;
}
