PageRenderTime 66ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/PO/detail_yui2.php

https://github.com/tlezotte/ePOS
PHP | 1308 lines | 1069 code | 81 blank | 158 comment | 153 complexity | 99efd069406de8e9f8312e4f65947246 MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * Request System
    4. 

  4.  *
    5. 

  5.  * detail.php displays detailed information on PO.
    6. 

  6.  *
    7. 

  7.  * @version 1.5
    8. 

  8.  * @link http://www.yourdomain.com/go/Request/
    9. 

  9.  * @author	Thomas LeZotte (tom@lezotte.net)
    10. 

  10.  *
    11. 

  11.  * @package PO
    12. 

  12.  * @filesource
    13. 

  13.  *
    14. 

  14.  * PHP Debug
    15. 

  15.  * @link http://phpdebug.sourceforge.net/
    16. 

  16.  * PDF Toolkit
    17. 

  17.  * @link http://www.accesspdf.com/
    18. 

  18.  */
    19. 

  19. 

  20. 

  21. /**
    22. 

  22.  * - Forward BlackBerry users to BlackBerry version
    23. 

  23.  */
    24. 

  24. require_once('../include/BlackBerry.php');
    25. 

  25.  
    26. 

  26. /**
    27. 

  27.  * - Start Page Loading Timer
    28. 

  28.  */
    29. 

  29. include_once('../include/Timer.php');
    30. 

  30. $starttime = StartLoadTimer();
    31. 

  31. /**
    32. 

  32.  * - Set debug mode
    33. 

  33.  */
    34. 

  34. $debug_page = false;
    35. 

  35. include_once('debug/header.php');
    36. 

  36. $Dbg->DatabaseName = "Request";
    37. 

  37. 

  38. /**
    39. 

  39.  * - Database Connection
    40. 

  40.  */
    41. 

  41. require_once('../Connections/connDB.php');
    42. 

  42. /**
    43. 

  43.  * - Config Information
    44. 

  44.  */
    45. 

  45. require_once('../include/config2.php'); 
    46. 

  46. /**
    47. 

  47.  * - Check User Access
    48. 

  48.  */
    49. 

  49. require_once('../security/check_user.php');
    50. 

  50. /**
    51. 

  51.  * - Form Validation
    52. 

  52.  */
    53. 

  53. //include('vdaemon/vdaemon.php');
    54. 

  54. 

  55.  
    56. 

  56.  
    57. 

  57. /* -------------------------------------------------------------				
    58. 

  58.  * ------------- START FINANCE PROCESSING -------------------
    59. 

  59.  * -------------------------------------------------------------
    60. 

  60.  */
    61. 

  61. if ($_POST['action'] == 'finance_update') {
    62. 

  62. 	$changePlant = false;
    63. 

  63. 	$changeDepartment = false;
    64. 

  64. 	
    65. 

  65. 	/* ----- Controller changes Plant ----- */
    66. 

  66. 	if ($_POST['currentPlant'] != $_POST['plant']) {
    67. 

  67. 		$plant_sql = "UPDATE PO SET plant='" . $_POST['plant'] . "' WHERE id=" . $_POST['type_id'];					// Update Bill to Plant
    68. 

  68. 		$dbh->query($plant_sql);
    69. 

  69. 		
    70. 

  70. 		// Record transaction for history
    71. 

  71. 		debug_capture($_SESSION['eid'], $_POST['id'], $default['debug_capture'], $_SERVER['PHP_SELF'], addslashes(htmlentities($plant_sql)));
    72. 

  72. 		
    73. 

  73. 		$changePlant = true;
    74. 

  74. 	}
    75. 

  75. 	
    76. 

  76. 	/* ----- Controller changes Department ----- */
    77. 

  77. 	if ($_POST['currentDepartment'] != $_POST['department']) {
    78. 

  78. 		$dept_sql = "UPDATE PO SET department='" . $_POST['department'] . "' WHERE id=" . $_POST['type_id'];			// Update Department
    79. 

  79. 		$dbh->query($dept_sql);
    80. 

  80. 		
    81. 

  81. 		// Record transaction for history
    82. 

  82. 		debug_capture($_SESSION['eid'], $_POST['id'], $default['debug_capture'], $_SERVER['PHP_SELF'], addslashes(htmlentities($dept_sql)));		
    83. 

  83. 		
    84. 

  84. 		$changeDepartment = false;	// Turned off because we are not checking for departments now (HQ)
    85. 

  85. 	}														
    86. 

  86. 

  87. 	/* ----- Forward to new Controller ----- */	
    88. 

  88. 	if ($changePlant OR $changeDepartment) {
    89. 

  89. 		$forward = "router.php?type_id=" . $_POST['type_id'] . "&approval=controller&plant=" . $_POST['plant'] . "&department=" . $_POST['department'];		// Check Controler
    90. 

  90. 		header("Location: ".$forward);
    91. 

  91. 		exit();
    92. 

  92. 	}
    93. 

  93. 	
    94. 

  94. 	/* ----- Cycle through items ----- */
    95. 

  95. 	for ($x=1; $x <= $_POST['items_count']; $x++) {
    96. 

  96. 		$item = "item" . $x;					// Item ID
    97. 

  97. 		$item_COA = $item . "_newCOA";			// COA value 
    98. 

  98. 		$item_COAid = $item_COA . "id";			// COA value ID
    99. 

  99. 		
    100. 

  100. 		if (strlen($_POST[$item_COAid]) > 0) {
    101. 

  101. 			$item_sql = "UPDATE Items SET cat='" . $_POST[$item_COAid] . "' WHERE id=" . $_POST[$item];
    102. 

  102. 			$dbh->query($item_sql);
    103. 

  103. 			
    104. 

  104. 			// Record transaction for history
    105. 

  105. 			debug_capture($_SESSION['eid'], $_POST['id'], $default['debug_capture'], $_SERVER['PHP_SELF'], addslashes(htmlentities($item_sql)));			
    106. 

  106. 		}
    107. 

  107. 	}
    108. 

  108. 	
    109. 

  109. 	/* ----- Update CER numbers and Credit Card ----- */
    110. 

  110. 	$po_sql = "UPDATE PO SET cer='" . $_POST['cer'] . "', 
    111. 

  111. 							 creditcard='" . $_POST['creditcard'] . "' 
    112. 

  112. 				 WHERE id=" . $_POST['type_id'];
    113. 

  113. 	$dbh->query($po_sql);					 
    114. 

  114. 				 
    115. 

  115. 	// Record transaction for history
    116. 

  116. 	debug_capture($_SESSION['eid'], $_POST['id'], $default['debug_capture'], $_SERVER['PHP_SELF'], addslashes(htmlentities($po_sql)));		 	
    117. 

  117. }
    118. 

  118. /* -------------------------------------------------------------				
    119. 

  119.  * ------------- END FINANCE PROCESSING -------------------
    120. 

  120.  * -------------------------------------------------------------
    121. 

  121.  */
    122. 

  122.  
    123. 

  123.  
    124. 

  124.  
    125. 

  125. /* -------------------------------------------------------------
    126. 

  126.  * ---------- START DENIAL PROCESSING -------------------------- 
    127. 

  127.  * -------------------------------------------------------------
    128. 

  128.  */
    129. 

  129. if (substr($_POST['auth'],0,3) == 'app' OR $_POST['auth'] == 'controller') {
    130. 

  130. 	if (array_key_exists('yes_x', $_POST)) { $yn = "yes"; }					// Set approval button pressed
    131. 

  131. 	if (array_key_exists('no_x', $_POST)) { $yn = "no"; }					// Set approval button pressed
    132. 

  132. 

  133. 	/* ---------------- Check to see if a Comment was provided ---------------- */
    134. 

  134. 	if (empty($_POST['Com']) AND $yn == 'no') {
    135. 

  135. 		$_SESSION['error'] = "A denied Requisition requires you to enter a Comment.";
    136. 

  136. 		$_SESSION['redirect'] = "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
    137. 

  137. 		
    138. 

  138. 		header("location: ../error.php");
    139. 

  139. 		exit();		
    140. 

  140. 	}
    141. 

  141. 		
    142. 

  142. 	/* ---------------- Change status for non approved request ---------------- */
    143. 

  143. 	if ($yn == 'no') {
    144. 

  144. 	  setRequestStatus($_POST['type_id'], 'X');		// Update PO status
    145. 

  145. 	}
    146. 

  146. 

  147. 	/* ---------------- Update the approvals for the PO ---------------- */
    148. 

  148. 	$auth_sql = "UPDATE Authorization 
    149. 

  149. 				 SET ".$_POST['auth']."yn='" . $yn . "', 
    150. 

  150. 					 ".$_POST['auth']."Date=NOW(), 
    151. 

  151. 					 ".$_POST['auth']."Com='" . htmlentities($_POST['Com'], ENT_QUOTES, 'UTF-8') . "'
    152. 

  152. 				 WHERE id = ".$_POST['auth_id'];
    153. 

  153. 	$dbh->query($auth_sql);
    154. 

  154. 				 
    155. 

  155. 	// Record transaction for history
    156. 

  156. 	debug_capture($_SESSION['eid'], $_POST['id'], $default['debug_capture'], $_SERVER['PHP_SELF'], addslashes(htmlentities($auth_sql)));
    157. 

  157. 

  158. 	if ($_POST['auth'] == 'controller') {
    159. 

  159. 		$forward = "router.php?type_id=" . $_POST['type_id'] . "&approval=app0";									// Forward to Approver 1
    160. 

  160. 	} else {
    161. 

  161. 		$forward = "router.php?type_id=" . $_POST['type_id'] . "&approval=" . $_POST['auth'] . "&yn=" . $yn;		// Record Controllers Approval
    162. 

  162. 	}
    163. 

  163. 	
    164. 

  164. 	header("Location: ".$forward);
    165. 

  165. 	exit();
    166. 

  166. }
    167. 

  167. /* -------------------------------------------------------------
    168. 

  168.  * ---------- END DENIAL PROCESSING ----------------------------
    169. 

  169.  * -------------------------------------------------------------
    170. 

  170.  */
    171. 

  171. 

  172.  
    173. 

  173. 

  174. /* -------------------------------------------------------------				
    175. 

  175.  * ------------- START UPDATE PROCESSING -----------------------
    176. 

  176.  * -------------------------------------------------------------
    177. 

  177.  */
    178. 

  178. if ($_POST['stage'] == "update") {
    179. 

  179. 	/* -------------------------------------------------------------
    180. 

  180. 	 * ---------- START REQUESTER PROCESSING ----------------------- 
    181. 

  181. 	 * -------------------------------------------------------------
    182. 

  182. 	 */
    183. 

  183. 	if ($_POST['auth'] == "req") {
    184. 

  184. 		/* ---------------- START CANCEL PURCHASE ORDER -------------- */ 
    185. 

  185. 		if ($_POST['cancel'] == 'yes') {
    186. 

  186. 			setRequestStatus($_POST['type_id'], 'C');		// Update PO status
    187. 

  187. 			
    188. 

  188. 			header("location: list.php?action=my&access=0");
    189. 

  189. 			exit();
    190. 

  190. 		}
    191. 

  191. 		/* ---------------- END CANCEL PURCHASE ORDER -------------- */
    192. 

  192. 

  193. 

  194. 		/* ------------- Adding tracking information ------------- */
    195. 

  195. 		if (array_key_exists('addTracking_x',$_POST)) {									   
    196. 

  196. 			$tracking=new Tracking();
    197. 

  197. 			$tracking->add();
    198. 

  198. 		}
    199. 

  199. 		
    200. 

  200. 		/* ------------- Update tracking information ------------- */
    201. 

  201. 		if (array_key_exists('updateTracking_x',$_POST)) {
    202. 

  202. 			$tracking=new Tracking();
    203. 

  203. 			$tracking->update(); 
    204. 

  204. 		}
    205. 

  205. 

  206. 		
    207. 

  207. 		/* ---------------- START RESEND PURCHASE ORDER ---------------- */ 		
    208. 

  208. 		if (array_key_exists('restorerequest_x',$_POST)) {
    209. 

  209. 			setRequestStatus($_POST['type_id'], 'N');											// Update PO status
    210. 

  210. 					
    211. 

  211. 			header("location: router.php?type_id=" . $_POST['type_id'] . "&approval=app0");		// Forward to router as new Request
    212. 

  212. 			exit();	
    213. 

  213. 		}
    214. 

  214. 		/* --------- END RESEND PURCHASE ORDER ----------------------- */		
    215. 

  215. 	}
    216. 

  216.     /* -------------------------------------------------------------
    217. 

  217. 	 * ---------- END REQUESTER PROCESSING ----------------------- 
    218. 

  218. 	 * -------------------------------------------------------------
    219. 

  219. 	 */
    220. 

  220. }
    221. 

  221. /* -------------------------------------------------------------				
    222. 

  222.  * ------------- END UPDATE PROCESSING -----------------------
    223. 

  223.  * -------------------------------------------------------------
    224. 

  224.  */
    225. 

  225. 

  226. 

  227. 

  228. /* -------------------------------------------------------------				
    229. 

  229.  * ------------- START PURCHASING PROCESSING -------------------
    230. 

  230.  * -------------------------------------------------------------
    231. 

  231.  */
    232. 

  232. if ($_POST['action'] == 'purchasing_update') {
    233. 

  233. 	/* ------------- Adding supplier contact information ------------- */
    234. 

  234. 	if (array_key_exists('sendPO_x',$_POST)) {
    235. 

  235. 		print_r($_POST);
    236. 

  236. 		exit();	
    237. 

  237. 	}
    238. 

  238. 	
    239. 

  239. 	/* ------------- Adding supplier contact information ------------- */
    240. 

  240. 	if (array_key_exists('addContact_x',$_POST)) {
    241. 

  241. 		$purchasing=new Purchasing();
    242. 

  242. 		$purchasing->addContact();
    243. 

  243. 	}
    244. 

  244. 

  245. 	/* ================== PAYMENTS =========================== */	
    246. 

  246. 	/* ------------- Adding payment information ------------- */
    247. 

  247. 	if (array_key_exists('addPayment_x',$_POST)) {									   
    248. 

  248. 		$payment=new Payment();
    249. 

  249. 		$payment->add();
    250. 

  250. 		$sql="select";
    251. 

  251. 		$mysql=new Mysql();
    252. 

  252. 		$mysql->capture($sql);		
    253. 

  253. 	}
    254. 

  254. 

  255. 	/* ------------- Update payment information ------------- */
    256. 

  256. 	if (array_key_exists('updatePayments_x',$_POST)) {
    257. 

  257. 		$payment=new Payment();
    258. 

  258. 		$payment->update();
    259. 

  259. 	}	
    260. 

  260. 	/* ================== PAYMENTS =========================== */
    261. 

  261. 	
    262. 

  262. 		
    263. 

  263. 	/* ------------- Purchaser marks Request as Complete ------------- */
    264. 

  264. 	if (array_key_exists('completed_x',$_POST)) {
    265. 

  265. 		$purchasing=new Purchasing();
    266. 

  266. 		$purchasing->vendorKickoff();
    267. 

  267. 	}
    268. 

  268. 	
    269. 

  269. 	/* ------------- Add Vendor and change Terms when Purchasing changes Vendor ------------- */
    270. 

  270. 	$purchasing=new Purchasing();
    271. 

  271. 	if (strlen($_POST['vendSearch']) > 0) {
    272. 

  272. 		$purchasing->update(true);
    273. 

  273. 	} else {
    274. 

  274. 		$purchasing->update();
    275. 

  275. 	}
    276. 

  276. }
    277. 

  277. /* -------------------------------------------------------------				
    278. 

  278.  * ------------- END PURCHASING PROCESSING -------------------
    279. 

  279.  * -------------------------------------------------------------
    280. 

  280.  */
    281. 

  281. 

  282. 

  283. /* -------------------------------------------------------------				
    284. 

  284.  * ------------- START DATABASE CONNECTIONS -------------------
    285. 

  285.  * -------------------------------------------------------------
    286. 

  286.  */
    287. 

  287. /* ------------- Getting PO information ------------- */
    288. 

  288. $PO = $dbh->getRow("SELECT *, DATE_FORMAT(reqDate,'%M %d, %Y') AS _reqDate
    289. 

  289. 				    FROM PO
    290. 

  290. 				    WHERE id = ?",array($_GET['id']));
    291. 

  291. /* ------------- Getting Authoriztions for above PO ------------- */
    292. 

  292. $AUTH = $dbh->getRow("SELECT * FROM Authorization WHERE type_id = ? and type = 'PO'",array($PO['id']));
    293. 

  293. /* ------------- Get Employee names from Standards database ------------- */
    294. 

  294. $EMPLOYEES = $dbh->getAssoc("SELECT eid, CONCAT(fst,' ',lst) AS name
    295. 

  295. 							 FROM Standards.Employees");
    296. 

  296. /* ------------- Getting Vendor information from Standards ------------- */							  
    297. 

  297. $VENDOR = $dbh->getAssoc("SELECT BTVEND, BTNAME FROM Standards.Vendor");
    298. 

  298. /* ------------- Getting Plant information from Standards ------------- */	
    299. 

  299. $plant_sql = "SELECT id, name FROM Standards.Plants WHERE status = '0'";
    300. 

  300. $PLANTS = $dbh->getAssoc($plant_sql);
    301. 

  301. $plant_query = $dbh->prepare($plant_sql);
    302. 

  302. $PLANT = $dbh->getRow("SELECT * FROM Standards.Plants WHERE id=" . $PO['plant']);
    303. 

  303. /* ------------- Getting Department information from Standards ------------- */	
    304. 

  304. $dept_sql = "SELECT id, CONCAT('(',id,') ',name) AS fullname FROM Standards.Department WHERE status='0' ORDER BY name";
    305. 

  305. $DEPARTMENT = $dbh->getAssoc($dept_sql);
    306. 

  306. $dept_query = $dbh->prepare($dept_sql);	
    307. 

  307. /* ------------- Getting Category information from Standards ------------- */	
    308. 

  308. $COA = $dbh->getAssoc("SELECT CONCAT(coa_account,'-',coa_suffix) AS id, coa_description AS name 
    309. 

  309. 					   FROM Standards.COA 
    310. 

  310. 					   WHERE coa_plant=" . $PLANT['conbr']);
    311. 

  311. /* ------------- Getting CER numbers from CER ------------- */							 						 
    312. 

  312. $cer_sql = "SELECT id, cer FROM CER WHERE cer IS NOT NULL ORDER BY cer+0";	
    313. 

  313. $CER = $dbh->getAssoc($cer_sql);	
    314. 

  314. $cer_query = $dbh->prepare($cer_sql);
    315. 

  315. /* ------------- Getting Vendor terms from Standards ------------- */
    316. 

  316. $terms_sql = "SELECT terms_id AS id, terms_name AS name FROM Standards.VendorTerms ORDER BY name";
    317. 

  317. $TERMS = $dbh->getAssoc($terms_sql);
    318. 

  318. $terms_query = $dbh->prepare($terms_sql);	
    319. 

  319. /* ------------- Get Purchase Request users ------------- */
    320. 

  320. $purchaser_sql  = $dbh->prepare("SELECT U.eid, E.fst, E.lst, E.email 
    321. 

  321. 								 FROM Users U
    322. 

  322. 								   INNER JOIN Standards.Employees E ON U.eid = E.eid
    323. 

  323. 								 WHERE  U.role = 'purchasing' 
    324. 

  324. 								   AND E.status = '0'
    325. 

  325. 								   AND U.eid <> '08745'
    326. 

  326. 								 ORDER BY E.lst ASC");
    327. 

  327. /* ------------- Get Purchase Request users ------------- */
    328. 

  328. $financer_sql  = $dbh->prepare("SELECT U.eid, E.fst, E.lst, E.email 
    329. 

  329. 								 FROM Users U
    330. 

  330. 								   INNER JOIN Standards.Employees E ON U.eid = E.eid
    331. 

  331. 								 WHERE  U.role = 'financing' 
    332. 

  332. 								   AND E.status = '0'
    333. 

  333. 								   AND U.eid <> '08745'
    334. 

  334. 								 ORDER BY E.lst ASC");								 
    335. 

  335. /* ------------- Get Vendor Payments ------------- */
    336. 

  336. $payments = $dbh->query("SELECT * FROM Payments WHERE request_id=" . $PO['id'] . " AND pay_status='0' ORDER BY pay_date ASC");
    337. 

  337. $payments_count = $payments->numRows();
    338. 

  338. /* ------------- Get Tracking Information ------------- */
    339. 

  339. $TRACKING = getTrackingInformation($PO['id']);
    340. 

  340. /* ------------- Getting Comments Information ------------- */
    341. 

  341. $post_sql = "SELECT * FROM Postings 
    342. 

  342. 			 WHERE request_id = ".$_GET['id']." 
    343. 

  343. 			   AND type = 'global'
    344. 

  344. 			 ORDER BY posted DESC";
    345. 

  345. $LAST_POST = $dbh->getRow($post_sql);		// Get the last posted comment
    346. 

  346. $post_query = $dbh->prepare($post_sql);						   
    347. 

  347. $post_sth = $dbh->execute($post_query);
    348. 

  348. $post_count = $post_sth->numRows();							 																	 				  	
    349. 

  349. /* -------------------------------------------------------------				
    350. 

  350.  * ------------- END DATABASE CONNECTIONS -------------------
    351. 

  351.  * -------------------------------------------------------------
    352. 

  352.  */
    353. 

  353. 

  354. 

  355. /* -------------------------------------------------------------				
    356. 

  356.  * ------------- START VARIABLES -------------------------------
    357. 

  357.  * -------------------------------------------------------------
    358. 

  358.  */
    359. 

  359. /* ------------- Check current level and current user ------------- */
    360. 

  360. if (array_key_exists('approval', $_GET)) {
    361. 

  361. 	if ($AUTH[$AUTH['level']] != $_SESSION['eid']) {
    362. 

  362. 		$message="<img src=\"/Common/images/nochange.gif\" align=\"absmiddle\" /> You are not authorized to approve this requisition.";
    363. 

  363. 		unset($_GET['approval']);
    364. 

  364. 	} elseif ($_GET['approval'] != $AUTH['level']) {
    365. 

  365. 		$message="<img src=\"/Common/images/nochange.gif\" align=\"absmiddle\" /> This Requisition is currently not at your approval level.";
    366. 

  366. 		unset($_GET['approval']);
    367. 

  367. 	}
    368. 

  368. } elseif ($PO['status'] == 'N') {
    369. 

  369. 	$message="<div class=\"appJump\"<img src=\"/Common/images/action.gif\" align=\"absmiddle\" /> This requisition is waiting for action from " . caps($EMPLOYEES[$AUTH[$AUTH['level']]] . "</div>");
    370. 

  370. }
    371. 

  371. 

  372. /* ------------- Get who denied the Requisition ------------- */
    373. 

  373. if ($PO['status'] == 'X') {
    374. 

  374. 	$who = array_search('no', $AUTH);
    375. 

  375. 	$canceled = '#' . substr($who,0,4) . 'Status';
    376. 

  376. }
    377. 

  377. 

  378. $disableSendPO = (!empty($PO['po']) AND $PO['reqType'] == 'blanket') ? '' : ' class="disabled"';	
    379. 

  379. $phone_char=array('(', ')', ' ', '-', '.');
    380. 

  380. $format_phone="(000)000-0000";
    381. 

  381. /* -------------------------------------------------------------				
    382. 

  382.  * ------------- END VARIABLES -------------------------------
    383. 

  383.  * -------------------------------------------------------------
    384. 

  384.  */
    385. 

  385. ?>
    386. 

  386. 

  387. 

  388. 

  389. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
    390. 

  390. <html>
    391. 

  391. <head>
    392. 

  392.     <title><?= $default['title1']; ?></title>
    393. 

  393.     <meta http-equiv="imagetoolbar" content="no">
    394. 

  394.     <meta name="copyright" content="2004 Your Company" />
    395. 

  395.     <meta name="author" content="Thomas LeZotte" />
    396. 

  396.     
    397. 

  397.     <link type="text/css" rel="stylesheet" href="/Common/js/yahoo/reset-fonts-grids/reset-fonts-grids.css" />   	<!-- CSS Grid -->
    398. 

  398.     <link type="text/css" rel="stylesheet" href="/Common/js/yahoo/fonts/fonts-min.css" />							<!-- Datatable, TabView -->
    399. 

  399.     <link type="text/css" rel="stylesheet" href="/Common/js/yahoo/assets/skins/sam/datatable.css" />				<!-- Datatable -->
    400. 

  400. 	<link type="text/css" rel="stylesheet" href="/Common/js/yahoo/assets/skins/sam/tabview.css" /> 					<!-- TabView -->
    401. 

  401.     <link type="text/css" rel="stylesheet" href="/Common/js/yahoo/assets/skins/custom/menu.css">  					<!-- Menu -->  
    402. 

  402.     
    403. 

  403.     <link type="text/css" rel="stylesheet" href="/Common/Print.css" media="print" />
    404. 

  404.     <link type="text/css" rel="stylesheet" href="../default_yui.css" />
    405. 

  405.     <link type="text/css" rel="alternate stylesheet" title="seasonal" href="/Common/themes/christmas/default.css" />
    406. 

  406.     <link type="text/css" rel="alternate stylesheet" title="night" href="/Common/themes/night/default.css" />
    407. 

  407. 

  408.     <?php if ($default['rss'] == 'on') { ?>
    409. 

  409.     <link rel="alternate" type="application/rss+xml" title="<?= $default['title1']; ?> Announcements" href="<?= $default['URL_HOME']; ?>/data/<?= $default['rss_file']; ?>">
    410. 

  410.     <link rel="alternate" type="application/rss+xml" title="Capital Acquisition Announcements" href="<?= $default['URL_HOME']; ?>/data/<?= $default['rss_file']; ?>">
    411. 

  411.     <?php } ?>
    412. 

  412. 

  413. 	<script type="text/javascript" src="/Common/js/styleswitcher.js"></script>
    414. 

  414.     
    415. 

  415.     <script type="text/javascript" src="/Common/js/jquery/jquery-min.js"></script>
    416. 

  416.     <script type="text/javascript" src="/Common/js/jquery/ui/ui.datepicker-min.js"></script>
    417. 

  417. </head>
    418. 

  418. <body class="yui-skin-sam">
    419. 

  419.   <div id="doc3" class="yui-t7">
    420. 

  420.     <div id="hd">
    421. 

  421.       <div class="yui-gb">
    422. 

  422.           <div class="yui-u first">
    423. 

  423.             <img src="/Common/images/CompanyPrint.gif" name="Print" width="437" height="61" id="Print" />
    424. 

  424.             <a href="../home.php" title="<?= $default['title1']; ?>|Home Page"><img src="/Common/images/Company.gif" width="300" height="50" border="0" id="CompanyLogo"></a> 
    425. 

  425.           </div>
    426. 

  426.           <div class="yui-u" id="centerTitle"><!-- Center Title Area -->&nbsp;<?php if ($_SESSION['request_access'] >= 2) { ?><span style="text-align:center"><a href="<?= $default['URL_HOME']; ?>/PO/detail.php?<?= $_SERVER['QUERY_STRING']; ?>" class="DarkHeaderSubSub">Switch to original</a></span><?php } ?></div>
    427. 

  427. <div class="yui-u">
    428. 

  428.               <div id="applicationTitle" style="font-weight:bold;font-size:115%;text-align:right"><?= $language['label']['title1']; ?>&nbsp;</div>
    429. 

  429.               <div id="loggedInUser" class="loggedInUser" style="text-align:right"><strong><a href="../Administration/user_information.php" class="loggedInUser" title="User Task|Edit your user information"><?= caps($_SESSION['fullname']); ?></a></strong>&nbsp;<a href="../logout.php" class="loggedInUser" title="User Task|Selecting [logout] will Log you out of the <?= $default[title1]; ?> and stop automatic cookie login">[logout]</a>&nbsp;</div>
    430. 

  430.               <div id="styleSwitcher" style="text-align:right">Themes: <span id="defaultStyle" class="style" title="Theme Selector|Default Theme"><a href="#" onclick="setActiveStyleSheet('default'); return false;"><img src="/Common/images/spacer.gif" width="14" height="10" border="0" /></a></span><span id="seasonalStyle" class="style" title="Theme Selector|Seasonal Theme - Christmas Season"><a href="#" onclick="setActiveStyleSheet('seasonal'); return false;"><img src="/Common/images/spacer.gif" width="14" height="10" border="0" /></a></span><span id="nightStyle" class="style" title="Theme Selector|Night Scape Theme"><a href="#" onclick="setActiveStyleSheet('night'); return false;"><img src="/Common/images/spacer.gif" width="14" height="10" border="0" /></a></span>&nbsp;</div>
    431. 

  431.           </div>
    432. 

  432.       </div>		      
    433. 

  433.     </div>
    434. 

  434.    <div id="bd">
    435. 

  435. 	<div class="yui-g" id="mm"><?php include('../include/main_menu.php'); ?></div>
    436. 

  436. 	<div class="yui-g">
    437. 

  437.         <form action="<?= $_SERVER['PHP_SELF']; ?>" method="POST" enctype="multipart/form-data" name="Form" id="Form" style="padding-top:10px" runat="vdaemon">
    438. 

  438.           <div id="requestStatusContainer" style="width:800px;margin-left: auto;margin-right:auto;">
    439. 

  439.             <div id="requestStatusTitle">Status Indicator</div>
    440. 

  440.             <div id="requestStatus" title="User Task|Click the Requisition Status window to jump to approvals panel"><?= reqStatus($PO['status']); ?><input type="hidden" name="status" value="<?= $PO['status']; ?>" /></div>
    441. 

  441.           </div>             
    442. 

  442.           <div id="minimantle" class="md minimantle" style="width:800px;margin-left: auto;margin-right:auto;">
    443. 

  443.             <div id="maincontent" class="md-sub">
    444. 

  444.               <div class="hd" style="height:25px"><h2>Purchase Order Requisition...</h2></div>
    445. 

  445.               <!-- Start Panel One -->
    446. 

  446.               <div id="information_panel" class="md-sub2">
    447. 

  447.                 <p id="information_title">Information</p>
    448. 

  448.                 <div id="information_content" style="margin:10px">
    449. 

  449.                   <table width="100%" align="center" border="0">
    450. 

  450.                     <tr>
    451. 

  451.                       <td nowrap="nowrap">Requisition Number:</td>
    452. 

  452.                       <td class="label"><?= $_GET['id']; ?></td>
    453. 

  453.                       <td nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    454. 

  454.                         <tr>
    455. 

  455.                           <td nowrap="nowrap">Blanket Order:</td>
    456. 

  456.                           <td width="35" align="right"><a href="blanket_list.php" rel="gb_page_center[700, 600]" title="Blanket Order List|Click here to get a list of approved Blanket Orders"><img src="../images/detail.gif" width="18" height="20" border="0" align="absmiddle" /></a></td>
    457. 

  457.                         </tr>
    458. 

  458.                       </table></td>
    459. 

  459.                       <td class="label"><table border="0" cellspacing="0" cellpadding="0">
    460. 

  460.                         <tr>
    461. 

  461.                           <td class="label"><a href="../CER/detail.php?id=<?= $PO['cer']; ?>" class="dark" rel="gb_page_fs[]">
    462. 

  462.                             <?= $CER[$PO['cer']]; ?>
    463. 

  463.                           </a></td>
    464. 

  464.                           <td><?php if (!empty($PO['cer'])) { ?>
    465. 

  465.                               <a href="<?= $default['URL_HOME']; ?>/CER/print.php?id=<?= $PO['cer']; ?>" title="Print Center|Click here to print this Capital Acquisition Request"><img src="../images/printer.gif" border="0" align="absmiddle" /></a>
    466. 

  466.                               <?php } ?></td>
    467. 

  467.                         </tr>
    468. 

  468.                       </table></td>
    469. 

  469.                     </tr>
    470. 

  470.                     <tr>
    471. 

  471.                       <td width="12%" nowrap="nowrap">Purchase Order  Number:</td>
    472. 

  472.                       <td width="45%" class="label"><?= ($PO['creditcard'] == 'yes') ? "Credit Card" : $PO['po']; ?></td>
    473. 

  473.                       <td width="13%" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    474. 

  474.                           <tr>
    475. 

  475.                             <td nowrap="nowrap">CER Number:</td>
    476. 

  476.                             <td width="35" align="right"><a href="cer_list.php" rel="gb_page_center[700, 600]" title="Capital Acquistion List|Click here to get a list of approved Capital Acquisition Requests"><img src="../images/detail.gif" width="18" height="20" border="0" align="absmiddle" /></a></td>
    477. 

  477.                           </tr>
    478. 

  478.                       </table></td>
    479. 

  479.                       <td width="26%" class="label"><table border="0" cellspacing="0" cellpadding="0">
    480. 

  480.                           <tr>
    481. 

  481.                             <td class="label"><a href="../CER/detail.php?id=<?= $PO['cer']; ?>" class="dark" rel="gb_page_fs[]">
    482. 

  482.                               <?= $CER[$PO['cer']]; ?>
    483. 

  483.                             </a></td>
    484. 

  484.                             <td><?php if (!empty($PO['cer'])) { ?>
    485. 

  485.                                 <a href="<?= $default['URL_HOME']; ?>/CER/print.php?id=<?= $PO['cer']; ?>" title="Print Center|Click here to print this Capital Acquisition Request"><img src="../images/printer.gif" border="0" align="absmiddle" /></a>
    486. 

  486.                                 <?php } ?></td>
    487. 

  487.                           </tr>
    488. 

  488.                       </table></td>
    489. 

  489.                     </tr>
    490. 

  490.                     <tr>
    491. 

  491.                       <td>Requisitioner:</td>
    492. 

  492.                       <td class="label"><?= caps($EMPLOYEES[$PO['req']]); ?></td>
    493. 

  493.                       <td nowrap="nowrap">Requisition Date:</td>
    494. 

  494.                       <td class="label"><?= $PO['_reqDate']; ?></td>
    495. 

  495.                     </tr>
    496. 

  496.                     <?php if (!empty($PO['incareof']) AND $PO['req'] != $PO['incareof']) { ?>
    497. 

  497.                     <tr>
    498. 

  498.                       <td><img src="/Common/images/menupointer2.gif" width="4" height="7" align="absmiddle" /> In Care Of:</td>
    499. 

  499.                       <td class="label"><?= caps($EMPLOYEES[$PO['incareof']]); ?></td>
    500. 

  500.                       <td>&nbsp;</td>
    501. 

  501.                       <td>&nbsp;</td>
    502. 

  502.                     </tr>
    503. 

  503.                     <?php } ?>
    504. 

  504.                     <tr>
    505. 

  505.                       <td height="5" colspan="4"><img src="../images/spacer.gif" width="5" height="5" /></td>
    506. 

  506.                     </tr>
    507. 

  507.                     <?php if (strlen($PO['sup2']) == 6) { ?>
    508. 

  508.                     <tr>
    509. 

  509.                       <td nowrap="nowrap">Final Vendor: </td>
    510. 

  510.                       <td nowrap="nowrap" class="label"><?= caps($VENDOR[$PO['sup2']]) . " (" . strtoupper($PO['sup2']) . ")"; ?>
    511. 

  511.                       <?php
    512. 

  512. 					  /* Getting suppliers from Suppliers */						 
    513. 

  513. 					  $SUPPLIER = $dbh->getRow("SELECT BTVEND AS id, BTNAME AS name, BTADR1 AS address, BTADR3 AS city, BTPRCD AS state, BTPOST AS zip5, BTWPAG AS web
    514. 

  514. 												FROM Standards.Vendor
    515. 

  515. 												WHERE BTVEND = '".$PO['sup2']."'");		
    516. 

  516. 					  ?>                      <span class="padding"><a href="../Common/vendor_map.php?id=<?= strtoupper($SUPPLIER['id']); ?>&amp;name=<?= caps($SUPPLIER['name']); ?>&amp;address=<?= $SUPPLIER['address']; ?> <?= $SUPPLIER['city']; ?>, <?= $SUPPLIER['state']; ?> <?= $SUPPLIER['zip5']; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?>'s Location" rel="gb_page_center[602, 602]"><img src="/Common/images/map.gif" width="20" height="20" border="0" align="absmiddle" /></a>
    517. 

  517.                       <?php if (!empty($SUPPLIER['web'])) { ?>
    518. 

  518.                       &nbsp;<a href="http://<?= $SUPPLIER['web']; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?>'s website." rel="gb_page_fs[]"><img src="/Common/images/globe.gif" width="18" height="18" border="0" align="absmiddle" /></a>
    519. 

  519.                       <?php } ?>
    520. 

  520.                       <a href="../Administration/vendor_details.php?id=<?= $SUPPLIER[id]; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?> information" rel="gb_page[400, 511]"><img src="../images/detail.gif" width="18" height="20" border="0" align="absmiddle" /></a>&nbsp;<a href="fax.php?id=<?= $PO['sup']; ?>&amp;company=<?= $PO['company']; ?>" title="Fax Center|Generate a fax cover sheet" target="_blank"><img src="../images/printer.gif" border="0" align="absmiddle" /></a></span></td>
    521. 

  521.                       <td>Kickoff Date:</td>
    522. 

  522.                       <td class="label"><?= ($AUTH['issuerDate'] == '0000-00-00 00:00:00' OR is_null($AUTH['issuerDate'])) ? $blank : date("F j, Y", strtotime($AUTH['issuerDate'])); ?></td>
    523. 

  523.                     </tr>
    524. 

  524.                     <?php } ?>
    525. 

  525.                     <tr>
    526. 

  526.                       <td nowrap="nowrap"><?= (empty($PO['po'])) ? Recommended : Final; ?>
    527. 

  527.                         Vendor:</td>
    528. 

  528.                       <td nowrap="nowrap" class="label"><?= caps($VENDOR[$PO['sup']]) . " (" . strtoupper($PO['sup']) . ")"; ?>
    529. 

  529.                           <?php
    530. 

  530. 					  /* Getting suppliers from Suppliers */						 
    531. 

  531. 					  $SUPPLIER = $dbh->getRow("SELECT BTVEND AS id, BTNAME AS name, BTADR1 AS address, BTADR3 AS city, BTPRCD AS state, BTPOST AS zip5, BTWPAG AS web
    532. 

  532. 												FROM Standards.Vendor
    533. 

  533. 												WHERE BTVEND = '".$PO['sup']."'");		
    534. 

  534. 					  ?><span class="padding"><a href="../Common/vendor_map.php?id=<?= strtoupper($SUPPLIER['id']); ?>&amp;name=<?= caps($SUPPLIER['name']); ?>&amp;address=<?= $SUPPLIER['address']; ?> <?= $SUPPLIER['city']; ?>, <?= $SUPPLIER['state']; ?> <?= $SUPPLIER['zip5']; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?>'s Location" rel="gb_page_center[602, 602]"><img src="/Common/images/map.gif" width="20" height="20" border="0" align="absmiddle" /></a>
    535. 

  535.                           <?php if (!empty($SUPPLIER['web'])) { ?>
    536. 

  536.                             &nbsp;<a href="http://<?= $SUPPLIER['web']; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?>'s website." rel="gb_page_fs[]"><img src="/Common/images/globe.gif" width="18" height="18" border="0" align="absmiddle" /></a>
    537. 

  537.                             <?php } ?>
    538. 

  538.                             <a href="../Administration/vendor_details.php?id=<?= $SUPPLIER[id]; ?>" title="Information Center|<?= caps($SUPPLIER['name']); ?> information" rel="gb_page[400, 511]"><img src="../images/detail.gif" width="18" height="20" border="0" align="absmiddle" /></a>&nbsp;<a href="fax.php?id=<?= $PO['sup']; ?>&amp;company=<?= $PO['company']; ?>" title="Fax Center|Generate a fax cover sheet" target="_blank"><img src="../images/printer.gif" border="0" align="absmiddle" /></a></span></td>
    539. 

  539.                       <?php if (strlen($PO['sup2']) != 6 AND !empty($PO['po'])) { ?>
    540. 

  540.                       <td>Kickoff Date:</td>
    541. 

  541.                       <td class="label"><?= ($AUTH['issuerDate'] == '0000-00-00 00:00:00' OR is_null($AUTH['issuerDate'])) ? $blank : date("F j, Y", strtotime($AUTH['issuerDate'])); ?></td>
    542. 

  542.                       <?php } else { ?>
    543. 

  543.                       <td>&nbsp;</td>
    544. 

  544.                       <td>&nbsp;</td>
    545. 

  545.                       <?php } ?>
    546. 

  546.                     </tr>
    547. 

  547.                     <!--          <tr>
    548. 

  548.                 <td>Company:</td>
    549. 

  549.                 <td class="label"><?= caps($COMPANY[$PO[company]]); ?></td>
    550. 

  550.                 <td nowrap>&nbsp;</td>
    551. 

  551.                 <td>&nbsp;</td>
    552. 

  552.               </tr>-->
    553. 

  553.                     <tr>
    554. 

  554.                       <td>Bill to Plant: </td>
    555. 

  555.                       <td class="label"><?= caps($PLANTS[$PO['plant']]); ?>
    556. 

  556.                           <input type="hidden" name="currentPlant" id="currentPlant" value="<?= $PO['plant']; ?>" /></td>
    557. 

  557.                       <td>Deliver to Plant: </td>
    558. 

  558.                       <td class="label"><?= caps($PLANTS[$PO['ship']]); ?></td>
    559. 

  559.                     </tr>
    560. 

  560.                     <tr>
    561. 

  561.                       <td>Department:</td>
    562. 

  562.                       <td class="label"><?= caps($DEPARTMENT[$PO['department']]); ?>
    563. 

  563.                           <input type="hidden" name="currentDepartment" id="currentDepartment" value="<?= $PO['department']; ?>" /></td>
    564. 

  564.                       <td>Job Number: </td>
    565. 

  565.                       <td class="label"><?= $PO['job']; ?></td>
    566. 

  566.                     </tr>
    567. 

  567.                     <tr>
    568. 

  568.                       <td height="5" colspan="4"><img src="../images/spacer.gif" width="5" height="5" /></td>
    569. 

  569.                     </tr>
    570. 

  570.                     <tr>
    571. 

  571.                       <td valign="top" nowrap="nowrap">Purpose / Usage:</td>
    572. 

  572.                       <td colspan="3" class="label"><?= caps(stripslashes($PO['purpose'])); ?></td>
    573. 

  573.                     </tr>
    574. 

  574.                   </table>
    575. 

  575.                 </div>
    576. 

  576.               </div>
    577. 

  577.               <!-- End Panel One -->
    578. 

  578.               <!-- Start Panel Two -->
    579. 

  579.               <div id="itemInformation" class="md-sub2">
    580. 

  580.                 <p id="itemInformation_title">Item Information</p>
    581. 

  581.                 <div id="itemInformation_content" style="margin:10px">
    582. 

  582.                 <div id="taskBar"><a href="comments.php?request_id=<?= $_GET['id']; ?>&eid=<?= $_SESSION['eid']; ?>" title="Actions Menu|View All Details" rel="gb_page_center[675,325]"><img src="/Common/images/menu-collapsed.gif" border="0" align="absmiddle">&nbsp;View All Details&nbsp;</a></div>
    583. 

  583.                   <div id="itemsTable"></div>
    584. 

  584.                 </div>
    585. 

  585.               </div>
    586. 

  586.               <!-- End Panel Two -->
    587. 

  587.               <!-- Start Panel Three -->
    588. 

  588.               <div id="track_panel" class="md-sub2">
    589. 

  589.                 <p id="track_title">Track Shipments</p>
    590. 

  590.                 <div id="track_content" style="margin:10px">
    591. 

  591.                   <div id="taskBar"><div id="addTracking" style="display:none; text-align:left;">Tracking number: <input name="track_number" type="text" id="track_number" size="30" maxlength="30" /> <input name="addTracking" type="image" src="../images/button.php?i=w90.png&l=Add" alt="Add Tracking Number" border="0"><hr color="#FFFFFF" size="1px" noshade></div><div id="addTrackingToggle"><img src="../images/add.gif" width="12" height="12" border="0" align="absmiddle">&nbsp;Tracking Number&nbsp;</div>
    592. 

  592.                   </div>
    593. 

  593.                   <div id="track_tabs">
    594. 

  594.                     <ul class="ui-tabs-nav">
    595. 

  595.                       <li><a href="#track_tabs-main"><span>List</span></a></li>
    596. 

  596.                       <?php for ($t=0; $t < count($TRACKING); $t++) { ?>
    597. 

  597.                       <li><a href="#track_tabs-<?= $t; ?>"><span><?= $TRACKING[$t][track_number]; ?></span></a></li>
    598. 

  598.                       <?php } ?>
    599. 

  599.                     </ul>
    600. 

  600.                     <div id="track_tabs-main" class="ui-tabs-panel">
    601. 

  601.                     	<div id="shipmentListTable"></div>
    602. 

  602.                     </div>
    603. 

  603.                     <?php for ($t=0; $t < count($TRACKING); $t++) { ?>
    604. 

  604.                     <div id="track_tabs-<?= $t; ?>" class="ui-tabs-panel" >
    605. 

  605.                       <div id="<?= $TRACKING[$t][track_number]; ?>Table"></div>
    606. 

  606.                     </div>
    607. 

  607.                     <?php } ?>
    608. 

  608.                   </div>
    609. 

  609.                 </div>
    610. 

  610.               </div>              
    611. 

  611.               <!-- End Panel Three -->
    612. 

  612.               <!-- Start Panel Four -->
    613. 

  613.               <div id="attachments_panel" class="md-sub2">
    614. 

  614.                 <p id="attachments_title">Attachments</p>
    615. 

  615.                 <div id="attachments_content" style="margin:10px">
    616. 

  616.                   <div id="taskBar"><div id="uploadFile" style="display:none; text-align:left">Choose a file to upload: <input name="file" type="file" size="38"> <input name="submitUpload" type="image" src="../images/button.php?i=w90.png&l=Upload" alt="Upload File" border="0"><hr color="#FFFFFF" size="1px" noshade></div><div id="uploadToggle"><img src="/Common/images/upload.gif" width="16" height="16" border="0" align="absmiddle">&nbsp;Upload File&nbsp;</div>
    617. 

  617.                   </div>
    618. 

  618.                   <div id="attachmentsTable"></div>
    619. 

  619.                 </div>
    620. 

  620.               </div>
    621. 

  621.               <!-- End Panel Four -->
    622. 

  622.               <!-- Start Panel Five -->
    623. 

  623.               <div id="comments_panel" class="md-sub2">
    624. 

  624.                 <p id="comments_title">Comments</p>
    625. 

  625.                 <div id="comments_content" style="margin:10px">
    626. 

  626.                   <div id="taskBar"><a href="comments.php?request_id=<?= $_GET['id']; ?>&eid=<?= $_SESSION['eid']; ?>" title="Actions Menu|Post a new comment" rel="gb_page_center[675,325]"><img src="../images/add.gif" width="12" height="12" border="0" align="absmiddle">&nbsp;New Comment&nbsp;</a></div>
    627. 

  627.                 <?php if ($post_count > 0) { ?>  
    628. 

  628.                   <div id="commentsCounter">
    629. 

  629.                     There <?= ($post_count > 1) ? are : is; ?> currently <strong><?= $post_count; ?></strong> comment<?= ($post_count > 1) ? s : ''; ?>. 
    630. 

  630.                       The last comment was posted on <strong><?= date('F d, Y \a\t H:i A', strtotime($LAST_POST['posted'])); ?></strong>.
    631. 

  631.                       <br>
    632. 

  632.                       <br>
    633. 

  633.                       <div class="clickToView">Click to view all Comments.</div>
    634. 

  634.                   </div>
    635. 

  635.                   <?php } else { ?>
    636. 

  636.                   <div id="commentsCounter">There are currently <strong>NO</strong> comments.</div>
    637. 

  637.                   <?php } ?>
    638. 

  638.                   <div width="95%" border="0" align="center" id="commentsArea" style="display:none"> <br>
    639. 

  639.                   <?php
    640. 

  640. 					$count=0;
    641. 

  641. 					while($post_sth->fetchInto($POST)) {
    642. 

  642. 						$count++;
    643. 

  643. 				  ?>
    644. 

  644.                       <div class="comment">
    645. 

  645.                         <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
    646. 

  646.                           <tr>
    647. 

  647.                             <td width="55" rowspan="3" valign="top" class="comment_datenum"><div class="comment_month">
    648. 

  648.                                 <?= date("M", strtotime($POST['posted'])); ?>
    649. 

  649.                               </div>
    650. 

  650.                                 <div class="comment_day">
    651. 

  651.                                   <?= date("d", strtotime($POST['posted'])); ?>
    652. 

  652.                                 </div>
    653. 

  653.                               <div class="comment_year">
    654. 

  654.                                   <?= date("y", strtotime($POST['posted'])); ?>
    655. 

  655.                               </div></td>
    656. 

  656.                             <td class="comment_wrote"><?= caps($EMPLOYEES[$POST[eid]]); ?> wrote... </td>
    657. 

  657.                           </tr>
    658. 

  658.                           <tr>
    659. 

  659.                             <td class="commentbody"><?= caps(stripslashes($POST['comment'])); ?></td>
    660. 

  660.                           </tr>
    661. 

  661.                           <tr>
    662. 

  662.                             <td class="comment_date"><?= date("h:i A", strtotime($POST['posted'])); ?></td>
    663. 

  663.                           </tr>
    664. 

  664.                         </table>
    665. 

  665.                       </div>
    666. 

  666.                     <br>
    667. 

  667.                     <?php } ?>
    668. 

  668.                   </div>
    669. 

  669.                 </div>
    670. 

  670.               </div>
    671. 

  671.               <!-- End Panel Five -->
    672. 

  672.               <!-- Start Panel Six -->
    673. 

  673.               <?php if ($_SESSION['request_role'] == 'controller' OR $_SESSION['request_role'] == 'executive') { ?>
    674. 

  674.               <div id="financeDepartment_panel" class="md-sub2">
    675. 

  675.                 <p id="financeDepartment_title">Finance Department</p>
    676. 

  676.                 <div id="financeDepartment_content" style="margin:10px">
    677. 

  677.                     <!-- ===================== START BILLING TAB ===================== -->
    678. 

  678.                     <table width="100%" border="0" cellspacing="5" cellpadding="0" id="financeInfo">
    679. 

  679.                       <tr>
    680. 

  680.                         <td width="194" nowrap>CER Number:</td>
    681. 

  681.                     <td width="150" class="label"><a href="../CER/detail.php?id=<?= $PO['cer']; ?>" class="dark" rel="gb_page_fs[]">
    682. 

  682.                       <?= $CER[$PO['cer']]; ?>
    683. 

  683.                       </a></td>
    684. 

  684.                     <td nowrap><!--Credit Card Purchase:--></td>
    685. 

  685.                     <td width="187"><!--<select name="creditcard" id="creditcard" >
    686. 

  686.                                         <option value="no" <?= ($PO['creditcard'] == 'no') ? selected : $blank; ?>>No</option>
    687. 

  687.                                         <option value="yes" <?= ($PO['creditcard'] == 'yes') ? selected : $blank; ?>>Yes</option>
    688. 

  688.                                       </select>--></td>
    689. 

  689.                   </tr>
    690. 

  690.                   <tr>
    691. 

  691.                     <td nowrap><table width="100%" border="0" cellspacing="0" cellpadding="0">
    692. 

  692.                         <tr>
    693. 

  693.                           <td nowrap>Change CER Number:</td>
    694. 

  694.                           <td width="35" align="right"><a href="cer_list.php" rel="gb_page_center[700, 600]" title="Capital Acquision List|Click here to get a list of approved Capital Acquisition Requests"><img src="../images/detail.gif" width="18" height="20" border="0" align="absmiddle"></a></td>
    695. 

  695.                         </tr>
    696. 

  696.                         </table></td>
    697. 

  697.                     <td><select name="cer" id="cer">
    698. 

  698.                       <option value="0">Select One</option>
    699. 

  699.                       <?php
    700. 

  700.                         $cer_sth = $dbh->execute($cer_query);	
    701. 

  701.                         while($cer_sth->fetchInto($DATA)) {
    702. 

  702.                             echo "  <option value=\"".$DATA['id']."\">".caps($DATA['cer'])."</option>\n";
    703. 

  703.                         }
    704. 

  704.                         ?>
    705. 

  705.                       </select></td>
    706. 

  706.                     <td nowrap><!--In Budget:--></td>
    707. 

  707.                     <td><!--<select name="inBudget" id="inBudget">
    708. 

  708.                                         <option value="no" <?= ($PO['inBudget'] == 'no') ? selected : $blank; ?>>No</option>
    709. 

  709.                                         <option value="yes" <?= ($PO['inBudget'] == 'yes') ? selected : $blank; ?>>Yes</option>
    710. 

  710.                                       </select>--></td>
    711. 

  711.                   </tr>
    712. 

  712.                   <tr>
    713. 

  713.                     <td height="5" colspan="4" nowrap><img src="../images/spacer.gif" width="5" height="5"></td>
    714. 

  714.                   </tr>
    715. 

  715.                   <tr>
    716. 

  716.                     <td nowrap>Bill to Plant: </td>
    717. 

  717.                     <td class="label"><?= caps($PLANTS[$PO['plant']]); ?></td>
    718. 

  718.                     <td nowrap>Department:</td>
    719. 

  719.                     <td nowrap class="label"><?= caps($DEPARTMENT[$PO['department']]); ?></td>
    720. 

  720.                   </tr>
    721. 

  721.                   <tr>
    722. 

  722.                     <td nowrap>Change Bill to Plant: </td>
    723. 

  723.                     <td><select name="plant" id="plant">
    724. 

  724.                       <option value="0">Select One</option>
    725. 

  725.                       <?php
    726. 

  726.                         $plant_sth = $dbh->execute($plant_query);	
    727. 

  727.                         while($plant_sth->fetchInto($DATA)) {
    728. 

  728.                             $selected = ($PO['plant'] == $DATA['id']) ? selected : $blank;
    729. 

  729.                             echo "  <option value=\"".$DATA['id']."\" ".$selected.">".caps($DATA['name'])."</option>\n";
    730. 

  730.                         }
    731. 

  731.                         ?>
    732. 

  732.                       </select></td>
    733. 

  733.                     <td nowrap>Change Department:</td>
    734. 

  734.                     <td><select name="department" id="department">
    735. 

  735.                       <option value="0">Select One</option>
    736. 

  736.                       <?php
    737. 

  737.                         $dept_sth = $dbh->execute($dept_query);	
    738. 

  738.                         while($dept_sth->fetchInto($DEPT)) {
    739. 

  739.                             $selected = ($PO['department'] == $DEPT['id']) ? selected : $blank;
    740. 

  740.                             echo "  <option value=\"".$DEPT['id']."\" ".$selected.">".caps($DEPT['fullname'])."</option>\n";
    741. 

  741.                         }
    742. 

  742.                         ?>
    743. 

  743.                       </select></td>
    744. 

  744.                   </tr>
    745. 

  745.                   <tr>
    746. 

  746.                     <td height="5" colspan="4" nowrap><img src="../images/spacer.gif" width="5" height="5"></td>
    747. 

  747.                   </tr>
    748. 

  748.                   <tr>
    749. 

  749.                     <td>&nbsp;</td>
    750. 

  750.                     <td>&nbsp;</td>
    751. 

  751.                     <td>&nbsp;</td>
    752. 

  752.                     <td><!--<input name="updaterequest" type="image" src="../images/button.php?i=w130.png&l=Update Request" alt="Update Request" border="0">-->
    753. 

  753.                       <input name="action" type="hidden" id="action" value="finance_update">
    754. 

  754.                       &nbsp;</td>
    755. 

  755.                   </tr>
    756. 

  756.                  </table>
    757. 

  757.                  <!-- ===================== END BILLING TAB ===================== -->
    758. 

  758.                 </div>
    759. 

  759.               </div>
    760. 

  760.               <?php } ?>
    761. 

  761.               <!-- End Panel Six -->
    762. 

  762.               <!-- Start Panel Seven -->
    763. 

  763.               <div id="approvals_panel" class="md-sub2">
    764. 

  764.                 <p id="approvals_title">Approvals</p>
    765. 

  765.                 <div id="approvals_content" style="margin:10px">
    766. 

  766.                   <table border="0">
    767. 

  767.                     <tr class="hd">
    768. 

  768.                       <td height="25" nowrap>&nbsp;</td>
    769. 

  769.                       <td width="30" nowrap>&nbsp;</td>
    770. 

  770.                       <td nowrap><h2>Name</h2></td>
    771. 

  771.                       <td nowrap><h2>Date</h2></td>
    772. 

  772.                       <td width="30" align="center" nowrap><a href="javascript:void(0);" title="Requestion Metrics|Days between Approvals"><img src="/Common/images/clock.gif" width="16" height="16" border="0"></a></td>
    773. 

  773.                       <td width="30" align="center" nowrap><a href="javascript:void(0);" title="Message Center|Number of comments submitted by each Approver"><img src="../images/comments.gif" width="19" height="16" border="0"></a></td>
    774. 

  774.                       <td width="400" ><h2>Comments</h2></td>
    775. 

  775.                       <td>
    776. 

  776.                         <?= (array_key_exists('approval', $_GET)) ? '<h2>Approval</h2>' : $blank; ?></td>
    777. 

  777.                     </tr>
    778. 

  778.                     <tr id="reqStatus">
    779. 

  779.                       <td nowrap><img src="/Common/images/spacer.gif" width="22" height="20" align="absmiddle">Requester:</td>
    780. 

  780.                       <td align="center" nowrap><a href="comments.php?eid=<?= $PO['req']; ?>&request_id=<?= $PO['id']; ?>&type=private" title="Message Center|Send a private message to <?= caps($EMPLOYEES[$PO['req']]); ?>" rel="gb_page_center[675,325]"><img src="../images/comments.gif" border="0"></a></td>
    781. 

  781.                       <td nowrap class="label"><?= caps($EMPLOYEES[$PO['req']]); ?></td>
    782. 

  782.                       <td nowrap class="label"><?= $PO['_reqDate']; ?></td>
    783. 

  783.                       <td align="center" nowrap class="TrainActive">-</td>
    784. 

  784.                       <td align="center" nowrap class="TrainActive"><a href="javascript:void(0);" class="checkComments"><?= checkComments($_GET['id'], $PO['req']); ?></a></td>
    785. 

  785.                       <td nowrap>&nbsp;</td>
    786. 

  786.                       <td nowrap>&nbsp;</td>
    787. 

  787.                     </tr>
    788. 

  788.                     <!-- END REQUESTER -->
    789. 

  789.                     <?php if (strlen($AUTH['controller']) == 5) { ?>
    790. 

  790.                     <!-- START CONTROLLER -->
    791. 

  791.                     <tr id="controllerStatus">
    792. 

  792.                       <td nowrap><img src="/Common/images/spacer.gif" width="22" height="20" align="absmiddle">Controller:</td>
    793. 

  793.                       <td align="center" nowrap><?php if ($AUTH['level'] == 'controller') { ?>
    794. 

  794.                           <img src="../images/resend_email.gif" title="Message Center|Email approvel request to <?= caps($EMPLOYEES[$AUTH['controller']]); ?>">
    795. 

  795.                           <?php } else { ?>
    796. 

  796.                           <a href="comments.php?eid=<?= $AUTH['controller']; ?>&request_id=<?= $PO['id']; ?>&type=private" title="Message Center|Send a private message to <?= caps($EMPLOYEES[$AUTH['controller']]); ?>" rel="gb_page_center[675,325]"><img src="../images/comments.gif" border="0"></a>
    797. 

  797.                           <?php } ?>                      </td>
    798. 

  798.                       <td nowrap class="label"><?= caps($EMPLOYEES[$AUTH['controller']]); ?></td>
    799. 

  799.                       <td nowrap class="label"><?php if (isset($AUTH['controllerDate'])) { echo date("F d, Y", strtotime($AUTH['controllerDate'])); } ?></td>
    800. 

  800.                       <td align="center" nowrap class="TrainActive"><?php if (isset($AUTH['controllerDate'])) { echo abs(ceil((strtotime($PO['reqDate']) - strtotime($AUTH['controllerDate'])) / (60 * 60 * 24))); } ?></td>
    801. 

  801.                       <td align="center" nowrap class="TrainActive"><a href="javascript:void(0);" class="checkComments">
    802. 

  802.                         <?= checkComments($_GET['id'], $AUTH['controller']); ?>
    803. 

  803.                       </a></td>
    804. 

  804.                       <td nowrap class="label"><?= displayAppComment('controller', $_GET['approval'], $AUTH['controller'], $AUTH['controllerCom'], $AUTH['controllerDate']); ?></td>
    805. 

  805.                       <td nowrap><?= displayAppButtons($_GET['id'], $_GET['approval'], 'controller', $AUTH['controller'], $AUTH['controllerDate']); ?></td>
    806. 

  806.                     </tr>
    807. 

  807.                     <?php } ?>
    808. 

  808.                     <!-- END CONTROLLER -->
    809. 

  809.                     
    810. 

  810.                     <!-- START APPROVER 1 -->
    811. 

  811.                     <tr id="app1Status">
    812. 

  812.                       <td nowrap><img src="/Common/images/spacer.gif" width="22" height="20" align="absmiddle"><?= $language['label']['app1']; ?>:</td>
    813. 

  813.            	    	  <td align="center" nowrap><?php if ($AUTH['level'] == 'app1') { ?>
    814. 

  814.                           <img src="../images/resend_email.gif" title="Email approvel request to <?= caps($EMPLOYEES[$AUTH['app1']]); ?>">
    815. 

  815.                           <?php } else { ?>
    816. 

  816.                           <a href="comments.php?eid=<?= $AUTH['app1']; ?>&request_id=<?= $PO['id']; ?>&type=private" title="Message Center|Send a private message to <?= caps($EMPLOYEES[$AUTH['app1']]); ?>" rel="gb_page_center[675,325]"><img src="../images/comments.gif" border="0"></a>
    817. 

  817.                           <?php } ?>                      </td>
    818. 

  818.                       <td nowrap class="label"><?= displayApprover($_GET['id'], 'app1', $AUTH['app1'], $AUTH['app1Date']); ?></td>
    819. 

  819.                       <td nowrap class="label"><?php if (isset($AUTH['app1Date'])) { echo date("F d, Y", strtotime($AUTH['app1Date'])); } ?></td>
    820. 

  820.                       <td align="center" nowrap class="TrainActive"><?php if (isset($AUTH['app1Date'])) { echo abs(ceil((strtotime($PO['reqDate']) - strtotime($AUTH['app1Date'])) / (60 * 60 * 24))); } ?></td>
    821. 

  821.                       <td align="center" nowrap class="TrainActive"><a href="javascript:void(0);" class="checkComments">
    822. 

  822.                         <?= checkComments($_GET['id'], $AUTH['app1']); ?>
    823. 

  823.                       </a></td>
    824. 

  824.                       <td nowrap class="label"><?= displayAppComment('app1', $_GET['approval'], $AUTH['app1'], $AUTH['app1Com'], $AUTH['app1Date']); ?></td>
    825. 

  825.                       <td nowrap><?= displayAppButtons($_GET['id'], $_GET['approval'], 'app1', $AUTH['app1'], $AUTH['app1Date']); ?></td>
    826. 

  826.                     </tr>
    827. 

  827.                     <!-- END APPROVER 1 -->
    828. 

  828.                     
    829. 

  829.                     <?php if (strlen($AUTH['app2']) == 5 OR $PO['status'] == 'N') { ?>
    830. 

  830.                     <!-- START APPROVER 2 -->
    831. 

  831.                     <tr id="app2Status">
    832. 

  832.                       <td nowrap><img src="/Common/images/spacer.gif" width="22" height="20" align="absmiddle"><?= $language['label']['app2']; ?>:</td>
    833. 

  833.     <td align="center" nowrap><?php if ($AUTH['level'] == 'app2') { ?>
    834. 

  834.                           <img src="../images/resend_email.gif" title="Email approvel request to <?= caps($EMPLOYEES[$AUTH['app2']]); ?>">
    835. 

  835.                           <?php } else { ?>
    836. 

  836.                           <a href="comments.php?eid=<?= $AUTH['app2']; ?>&request_id=<?= $PO['id']; ?>&type=private" title="Message Center|Send a private message to <?= caps($EMPLOYEES[$AUTH['app2']]); ?>" rel="gb_page_center[675,325]"><img src="../images/comments.gif" border="0"></a>
    837. 

  837.                           <?php } ?>                      </td>
    838. 

  838.                       <td nowrap class="label"><?= displayApprover($_GET['id'], 'app2', $AUTH['app2'], $AUTH['app2Date']); ?></td>
    839. 

  839.                       <td nowrap class="label"><?php if (isset($AUTH['app2Date'])) { echo date("F d, Y", strtotime($AUTH['app2Date'])); } ?></td>
    840. 

  840.                       <td align="center" nowrap class="TrainActive"><?php if (isset($AUTH['app2Date'])) { echo abs(ceil((strtotime($AUTH['app1Date']) - strtotime($AUTH['app2Date'])) / (60 * 60 * 24))); } ?></td>
    841. 

  841.              …
    842.

Large files files are truncated, but you can click here to view the full file