<?php
session_start();
if(empty($_SESSION['db_name'])) {
	die('Login Expired');
}
include_once($_SERVER['DOCUMENT_ROOT'].'/php/mysql.php');

$store = $_SESSION['store_id'];
$storeDbName = $_SESSION['db_name'];

if(!empty($_POST['worker'])) {
	$employeeData = $db->get_results("SELECT * FROM $storeDbName.employees WHERE employee = '".$db->clean($_POST['worker'])."'");
	$managerData = $db->get_results("SELECT * FROM $storeDbName.managers WHERE id = '".$db->clean($_POST['manager'])."'");
	
	$db->query("INSERT INTO $storeDbName.write_ups
				(
					store_id
					,employee
					,manager
					,severity
					,description
					,datetime_recorded
				) VALUES (
					'".$db->clean($store)."'
					,'".$db->clean($employeeData[0]->worker)."'
					,'".$db->clean($managerData[0]->name)."'
					,'".$db->clean($_POST['severity'])."'
					,'".$db->clean($_POST['description'])."'
					,NOW()
				)");
				
				
	
	if(!empty($employeeData[0]->email)) {
		include_once($_SERVER['DOCUMENT_ROOT'].'/php/mailgun.php');
		$to = $employeeData[0]->email;
		$from = 'NoReply@ylreports.com';
		$subject = 'Employee Write Up '.date('m/d/Y');
		$body = $employeeData[0]->worker.' has been written up by '.$managerData[0]->name.' with a '.$_POST['severity'].' ticket.<br /><br />Reason: '.$_POST['description'];
		mailgun_send_message($to,$from,$subject,$body,1,$subject,$managerData[0]->email,'','',0,array(),'',0);
	}
}


include($_SERVER['DOCUMENT_ROOT'].'/php/save_debug.php');