Copyright (c) 2006-2013 osTicket
http://www.osticket.com
Released under the GNU General Public License WITHOUT ANY WARRANTY.
See LICENSE.TXT for details.
vim: expandtab sw=4 ts=4 sts=4:
**********************************************************************/
require('staff.inc.php');
require_once(INCLUDE_DIR.'class.ticket.php');
require_once(INCLUDE_DIR.'class.dept.php');
require_once(INCLUDE_DIR.'class.filter.php');
require_once(INCLUDE_DIR.'class.canned.php');
require_once(INCLUDE_DIR.'class.json.php');
require_once(INCLUDE_DIR.'class.dynamic_forms.php');
require_once(INCLUDE_DIR.'class.export.php'); // For paper sizes
$page='';
$ticket = $user = null; //clean start.
$redirect = false;
//LOCKDOWN...See if the id provided is actually valid and if the user has access.
if($_REQUEST['id'] || $_REQUEST['number']) {
if($_REQUEST['id'] && !($ticket=Ticket::lookup($_REQUEST['id'])))
$errors['err']=sprintf(__('%s: Unknown or invalid ID.'), __('ticket'));
elseif($_REQUEST['number'] && !($ticket=Ticket::lookup(['number' => $_REQUEST['number']])))
$errors['err']=sprintf(__('%s: Unknown or invalid number.'), __('ticket'));
elseif(!$ticket->checkStaffPerm($thisstaff)) {
$errors['err']=__('Access denied. Contact admin if you believe this is in error');
$ticket=null; //Clear ticket obj.
}
}
if ($_REQUEST['uid']) {
$user = User::lookup($_REQUEST['uid']);
}
if($_GET['a'] != 'print')
require_once(STAFFINC_DIR.'header.inc.php');
error_reporting(E_ALL);
$sql = "SELECT
t.ticket_id,t.number,t.created,
GROUP_CONCAT(CONCAT(fev.field_id,'!',fev.value) SEPARATOR '|') as field_id,
ue.address,
uc.post_address,uc.post_city, uc.post_zip, uc.post_state,uc.post_business,
u.name
FROM
`pelican_form_entry` fe,
`pelican_form_entry_values` fev,
`pelican_ticket` t,
`pelican_user` u,
`pelican_user__cdata` uc,
`pelican_user_email` ue
WHERE
t.ticket_id = fe.object_id AND
fe.id = fev.entry_id AND
t.user_id = ue.user_id AND
uc.user_id = ue.user_id AND
u.id = uc.user_id AND
t.ticket_id='".$_GET['id']."'
group by
t.ticket_id,t.number,t.created,
ue.address,
uc.post_address,uc.post_city, uc.post_zip, uc.post_state,uc.post_business,
u.name";
$res=db_query($sql);
while($row=db_fetch_array($res))
{
$ticket_id = $row['ticket_id'];
$ticket_number = $row['number'];
$ticket_date_created = date("m/d/Y",strtotime($row['created']));
$ticket_field_ids = $row['field_id'];
$ticket_address = $row['address'];
$ticket_post_address = $row['post_address'];
$ticket_post_city = $row['post_city'];
$ticket_post_zip = $row['post_zip'];
$ticket_post_state = $row['post_state'];
$ticket_post_business = $row['post_business'];
$ticket_name = preg_replace('/\d/', '', $row['name']);
$ticket_name = str_replace('-', '', $ticket_name);
$ticket_name = trim($ticket_name);
$field_id_array = explode("|",$ticket_field_ids);
foreach($field_id_array as $key=>$val)
{
$splt = explode("!",$val);
${"field_id_".$splt[0]} = $splt[1];
}
$totallabor=$field_id_38*40;
$total=$totallabor+$field_id_41+$field_id_43+$field_id_45;
$date=date("m/d/Y");
$totallabor=number_format((float)$totallabor, 2, '.', '');
$total=number_format((float)$total, 2, '.', '');
echo "Unit No : ".$field_id_36."
";
echo "Labor Hour : ".$field_id_38."
";
echo "Labor Desc : ".$field_id_39."
";
echo "W/O Subject : ".$field_id_20."
";
echo "Mat 1 Desc : ".$field_id_40."
";
echo "Mat 1 Price : ".$field_id_41."
";
echo "Mat 2 Desc : ".$field_id_42."
";
echo "Mat 2 Price : ".$field_id_43."
";
echo "Mat 3 Desc : ".$field_id_44."
";
echo "Mat 3 Price: ".$field_id_45."
";
echo "W/O Number : ".$ticket_number."
";
echo "Ticket Date : ".$ticket_date_created."
";
echo "Email : ".$ticket_address."
";
echo "Address : ".$ticket_post_address."
";
echo "City : ".$ticket_post_city."
";
echo "Zip : ".$ticket_post_zip."
";
echo "State : ".$ticket_post_state."
";
echo "Business : ".$ticket_post_business."
";
echo "Name : ".$ticket_name."
";
echo "Total : ".$total."
";
}
if($_GET['a'] != 'print')
require_once(STAFFINC_DIR.'footer.inc.php');