PHP - Load Php Image Faster Or Cache

I wonder whether someone may be able to help me please.

I'm trying to put together a PHP within Aurigma Image Uploader which will create an image gallery. To do this I need to extract the image from a folder called 'Thumbnails' and image data from a file called 'files.xml'.

The code below is an extract of the default script that performs this functionality and I've tested and it works without any issues.

Code: [Select]
<?php 
   
  //This variable specifies relative path to the folder, where the gallery with uploaded files is located. 
  //Do not forget about the slash in the end of the folder name. 
  $galleryPath = 'UploadedFiles/'; 
    
  $thumbnailsPath = $galleryPath . 'Thumbnails/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR; 
    
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
I have now changed my folder and file structure to the following:

UploadedFiles (Folder)
username (Subfolder containing the 'location' folder) location (Subfolder containing 'Thumbnails folder and image, and 'files.xml') Please note that both the 'username' and 'location' folders are dynamically created when the user initially uploads the images.
To try and accomodate the new file structure I changed my code to:

Code: [Select]
<?php 
   
  //This variable specifies relative path to the folder, where the gallery with uploaded files is located. 
  //Do not forget about the slash in the end of the folder name. 
  $galleryPath = 'UploadedFiles/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR; 
  
  $thumbnailsPath = $galleryPath . 'Thumbnails/'; 
  
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
But when I run this I receive the following error:

Quote

d333603417/htdocs/development/UploadedFiles/files.xml" in /homepages/2/d333603417/htdocs/development/gallery.php on line 14

Line 14 is this line:
Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I've been working on this for days and I just can't seem to find the answer.

I just wondered whether someone could possibly look at this and let me know where I'm going wrong.

If it helps, I've added the upload script below.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php'; 
require_once 'ImageUploaderPHP/UploadHandler.class.php'; 
$galleryPath = 'UploadedFiles/'; 
 
function onFileUploaded($uploadedFile) { 
  global $galleryPath; 
 
  $packageFields = $uploadedFile->getPackage()->getPackageFields(); 
  $username=$packageFields["username"]; 
  $locationid=$packageFields["locationid"]; 
  $username = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']); 
  $location = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']); 
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']); 
 
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $username . DIRECTORY_SEPARATOR . $location . DIRECTORY_SEPARATOR; 
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR; 
 
  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true); 
  chmod($absGalleryPath, 0777); 
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true); 
  chmod($absGalleryPath . $dirName, 0777); 
 
  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0) 
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE); 
 
  $originalFileName = $uploadedFile->getSourceName(); 
  $files = $uploadedFile->getConvertedFiles(); 
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName); 
  $sourceFile = $files[0]; 
 
  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName); 
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName); 
  $thumbnailFile = $files[1]; 
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName); 
  
  $descriptions = new DOMDocument('1.0', 'utf-8'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
  
  $xmlFile = $descriptions->createElement('file'); 
  // <-- please check the following line 
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName); 
  $xmlFile->setAttribute('source', $sourceFileName); 
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize()); 
  $xmlFile->setAttribute('originalname', $originalFileName); 
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName); 
  $xmlFile->setAttribute('description', $uploadedFile->getDescription()); 
  $xmlFile->setAttribute('username', $username); 
  $xmlFile->setAttribute('locationid', $locationid); 
  $xmlFile->setAttribute('folder', $dirName); 
 

  $descriptions->documentElement->appendChild($xmlFile); 
  $descriptions->save($absGalleryPath . 'files.xml'); 
} 
 
$uh = new UploadHandler(); 
$uh->setFileUploadedCallback('onFileUploaded'); 
$uh->processRequest(); 
?>
Many thanks

Hi ppl

got code problem cant get it show users avatar & blank avatar at same time not that good at
php ppl.

avatar box page

Code: [Select]
<style type="text/css">
#name_area{height:20px; padding:3px;};
</style>
<script language="javascript">
<!--
function member_change(id){
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);
if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
?>
document.getElementById('<?php echo mysql_result($allgames, $i, 'game_id'); ?>').style.display = "none";
<?php
$i++;
}
}
?>
document.getElementById(id).style.display = "block";
}
function show_name(name){

document.getElementById('name_area').innerHTML = name;
}
function hide_name(){
document.getElementById('name_area').innerHTML = '';
}
//-->
</script>

<div style="text-align:left;">
Choose Squad: <select name="D1" onchange="member_change(this.options[this.selectedIndex].value)" class="standardforms">
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);

if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
$game = mysql_result($allgames, $i, 'game_title');
$members_total2 = mysql_num_rows(mysql_query("SELECT * FROM members WHERE game = '$game'"));

if($members_total2!=0)
{
?>
<option value="<?php echo mysql_result($allgames, $i, 'game_id'); ?>"><?php echo mysql_result($allgames, $i, 'game_title'); ?></option>
<?php
}
$i++;
}
}
?>
</select><br /><br />
</div>
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);
if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
$game = mysql_result($allgames, $i, 'game_title');
$members = mysql_query("SELECT * FROM members WHERE game = '$game'");
$members_total = @mysql_num_rows($members);

if($allgames_total!=0)
{
?>
<div id="<?php echo mysql_result($allgames, $i, 'game_id'); ?>" style="display: block; text-align:left;">
<?php

if($members_total!=0)
{
$d=0;
while($d<$members_total)
{

?>
<a href="index.php?page=members&amp;id=<?php echo mysql_result($members, $d, 'id'); ?>"><img onmouseover="show_name('<?php echo mysql_result($members, $d, 'username'); ?>')" onmouseout="hide_name()" src="user/<?php

  echo mysql_result($members, $d, 'avatar_link');

$filename = 'avatar_link';

if (file_exists($filename)) {
     echo "avatar_link";
} else {
     echo "avatars/blank.jpg";
}


?>" width="50" height="50" alt="<?php echo mysql_result($members, $d, 'username'); ?>" title="<?php echo mysql_result($members, $d, 'username'); ?>"/></a>
<?php
$d++;
}
}
}
echo "</div>";
$i++;
}
}
?>
<div id="name_area"></div>

I wonder whether someone may be able to help me please.

I've put together the following script which saves user defined images to server folders using the Aurigma Image Uploader software.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php'; 
require_once 'ImageUploaderPHP/UploadHandler.class.php'; 
$galleryPath = 'UploadedFiles/'; 
 
function onFileUploaded($uploadedFile) { 
  global $galleryPath; 
 
  $packageFields = $uploadedFile->getPackage()->getPackageFields(); 
  $username=$packageFields["username"]; 
  $locationid=$packageFields["locationid"]; 
  $usernamefolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']); 
  $locationfolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']); 
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']); 
 
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR; 
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR; 
 
  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true); 
  chmod($absGalleryPath, 0777); 
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true); 
  chmod($absGalleryPath . $dirName, 0777); 
 
  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0) 
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE); 
 
  $originalFileName = $uploadedFile->getSourceName(); 
  $files = $uploadedFile->getConvertedFiles(); 
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName); 
  $sourceFile = $files[0]; 
 
  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName); 
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName); 
  $thumbnailFile = $files[1]; 
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName); 
  
  $descriptions = new DOMDocument('1.0', 'utf-8'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
  
  $xmlFile = $descriptions->createElement('file'); 
  // <-- please check the following line 
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName); 
  $xmlFile->setAttribute('source', $sourceFileName); 
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize()); 
  $xmlFile->setAttribute('originalname', $originalFileName); 
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName); 
  $xmlFile->setAttribute('description', $uploadedFile->getDescription()); 
  $xmlFile->setAttribute('username', $username); 
  $xmlFile->setAttribute('locationid', $locationid); 
  $xmlFile->setAttribute('folder', $dirName); 
 

  $descriptions->documentElement->appendChild($xmlFile); 
  $descriptions->save($absGalleryPath . 'files.xml'); 
} 
 
$uh = new UploadHandler(); 
$uh->setFileUploadedCallback('onFileUploaded'); 
$uh->processRequest(); 
?>
This code saves the files in the following structu

UploadedFiles (Pre-existing folder)
'username' (Subfolder created dynamically on image upload if it doesn't already exist. This folder contains the 'location' folder) 'location' (Subfolder created dynamically on image upload if it doesn't already exist. This contains original image, 'files.xml' and 'Thumbnails' folder) 'Thumbnails' (Subfolder created dynamically on image upload if it doesn't already exist. This contains thumbnail of original image)
I'm now trying to put together a script which creates an image gallery, with those images pertinent to the current user and location. The code below is the piece of my script which deals with the loading of the images.

Code: [Select]
<?php 
  $galleryPath = 'UploadedFiles/'; 
    
  $thumbnailsPath = $galleryPath . 'Thumbnails/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR; 
    
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
The initial problem I had, was resolved from guidance I received on this site, and that was to find the correct 'realpath' of the 'Thumbnails' folder and 'files.xml'
These are as follows: Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1

  and Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1/Thumbnails

with 'IRHM73' being the 'username' value and '1' the 'location' value.

The problem I now have lies within this line of code:

`$absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;`

Because the 'username' and 'location' are dynamic and hence contain different values for each user and location, I've found it impossible to find a way of creating the correct file path to open the 'Thumbnails' folder and 'files.xml'.

I had tried this:

Code: [Select]
<?php 
   
  $galleryPath = 'UploadedFiles/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR; 
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR; 
    
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
But I receive the following error: DOMDocument::load() domdocument.load: I/O warning : failed to load external entity /homepages/2/d333603417/htdocs/development/UploadedFiles/'files.xml'; in /homepages/2/d333603417/htdocs/development/gallery.php on line 13 and line 13 is this:  Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I really am stumped with what to do next to get this to work. I appreciate that this is a fairly lengthy post, but thought it would be better to post all the information.

I just wondered whether someone could perhaps take a look at this and let me know where I'm going wrong and how I can get it to work.

Many thanks and regards

this is my script it gets the values form the database and adds them and saves it to a variable which is then echoed to the user before i typed this code 10 more times changing every variable name i was wondering if their was a more efficient way of doing this
Code: [Select]
<?php
            $adam_view_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' ORDER BY Day_Played DESC";
$adam_view_results = mysql_query($adam_view_query)  or die("Query failed ($adam_view_query) - " . mysql_error());
$adam_view_numrows = mysql_num_rows($adam_view_results);
$adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error());
$adam_gli_row = mysql_fetch_array($adam_gli_results);
$adam_gli = $adam_gli_row['adam_gli'];
$adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error());
$adam_goals_row = mysql_fetch_array($adam_goals_results);
$adam_goals = $adam_goals_row['adam_goals']; 
         $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error());
$adam_saves_row = mysql_fetch_array($adam_saves_results);
$adam_saves = $adam_saves_row['adam_saves'];
$adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error());
$adam_sog_row = mysql_fetch_array($adam_sog_results);
$adam_sog = $adam_sog_row['adam_sog'];
$adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error());
$adam_assists_row = mysql_fetch_array($adam_assists_results);
$adam_assists = $adam_assists_row['adam_assists'];
$adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error());
$adam_ck_row = mysql_fetch_array($adam_ck_results);
$adam_ck = $adam_ck_row['adam_ck'];
$adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error());
$adam_yc_row = mysql_fetch_array($adam_yc_results);
$adam_yc = $adam_yc_row['adam_yc'];
$adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error());
$adam_rc_row = mysql_fetch_array($adam_rc_results);
$adam_rc = $adam_rc_row['adam_rc'];
$adam_goalie = "";
if (isset($_POST['adam_go'])) { 
$adam_view = mysql_real_escape_string($_POST['adam_statview']);
if ($adam_view == "Total"){
$adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error());
$adam_gli_row = mysql_fetch_array($adam_gli_results);
$adam_gli = $adam_gli_row['adam_gli'];
$adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error());
$adam_goals_row = mysql_fetch_array($adam_goals_results);
$adam_goals = $adam_goals_row['adam_goals']; 
         $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error());
$adam_saves_row = mysql_fetch_array($adam_saves_results);
$adam_saves = $adam_saves_row['adam_saves'];
$adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error());
$adam_sog_row = mysql_fetch_array($adam_sog_results);
$adam_sog = $adam_sog_row['adam_sog'];
$adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error());
$adam_assists_row = mysql_fetch_array($adam_assists_results);
$adam_assists = $adam_assists_row['adam_assists'];
$adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error());
$adam_ck_row = mysql_fetch_array($adam_ck_results);
$adam_ck = $adam_ck_row['adam_ck'];
$adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error());
$adam_yc_row = mysql_fetch_array($adam_yc_results);
$adam_yc = $adam_yc_row['adam_yc'];
$adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error());
$adam_rc_row = mysql_fetch_array($adam_rc_results);
$adam_rc = $adam_rc_row['adam_rc'];
$adam_goalie = "";
}else{
$adam_stats_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' AND Day_Played = '$adam_view'";
$adam_stats_results = mysql_query($adam_stats_query) or die ("Query failed ($adam_stats_query) - " . mysql_error());
$adam_stats_row = mysql_fetch_array($adam_stats_results);
$adam_goalie_test = $adam_stats_row['Goalie'];
$adam_gli = $adam_stats_row['GLI'];
$adam_goals = $adam_stats_row['Goals'];
$adam_saves = $adam_stats_row['Saves'];
$adam_sog = $adam_stats_row['SOG'];
$adam_assists = $adam_stats_row['Assists'];
$adam_ck = $adam_stats_row['CK'];
$adam_yc = $adam_stats_row['YC'];
$adam_rc = $adam_stats_row['RC'];
if ($adam_goalie_test == 1){
$adam_goalie = "Yes";
}else{
$adam_goalie = "No";
}
}
}
           ?>

Hi all

I wonder if you could give me some advice.

I basically have a mysql database of staff who work at a college, I have a front which displays details of a staff member, I grab the details using

userdetails.php?id=44 (44 being the ID of the staff member)

One field I have in my MySQL database is "title", which is basically

Mr
Ms
Mrs
Miss
Dr

At the moment, I store the "title" value in the database as "CHAR", so it appears as "Mrs" for example when I print

print $row['title'];

What I want to know is, which is the best method of storing and getting this data.

Is it best to

-----------------------------------------------------

1: Continue as I am and keep text values in the database stored as CHAR[/li][/list]

-----------------------------------------------------

2: Change it so that instead of storing "Mr", "Dr" as CHAR, I would store them as numeric values, so;

2 would be Mr
3 would be Mrs
4 would be Dr

then do a

if($row['title'] == 2) { print "Mr"; } elseif($row['title'] == 3) { print "Mrs"; } elseif($row['title'] == 4) { print "Dr"; }

-----------------------------------------------------

3: Change it so that instead of storing "Mr", "Dr" as CHAR, I would store them as numeric values, but then have another database table which holds what value each number is, so my new database table would be like

--- title_values ----

id   value
2    Mr
3    Mrs
4    Dr

-------------------------

then on the front end, do a SELECT such as

SELECT `value` FROM `title_values` WHERE `id` = "'.$row['id'].'"

I guess the advantage to this one, is that I can modify the list of titles and expand it.

-----------------------------------------------------

which of those is generally considered better? faster? and less server intensive?

or is there a better way to do it?

Thanks very much

my code:
Code: [Select]
echo $Profile['display'];



ECHO's out:

0|1|0|1


Now I want to explode these, which is easy

Code: [Select]
$display = explode("|", $Profile['display']);
But Now I want to use a php function to check if any of the array's = "1" and have the value set to $value= "checked";


I could do this by doing

Code: [Select]
if ($display['0'] == "1"){ $value = "checked"; }
and then 1 2 3 and so on..



but I want a faster way, maybe a for loop, or a simpliar easier way to just check if each array = 1, make $value = checked

Possible right?

Say I have a MySQL table with two fields: "id" (primary key, INT(7)) and "hash" (indexed, VARCHAR(32)), and there will be hundreds of thousands of records in this table. Would it be faster / less CPU intensive to use MySQL to match both the id and hash fields to cleaned / sanitized request vars, or just match the id field with MySQL, and then use PHP to determine whether or not the hash is correct?

So,


mysql_query("SELECT * FROM table WHERE id='" .$id. "' AND hash=' .$hash. '");

or:


$query = mysql_query("SELECT * FROM table WHERE id='" .$id. "'");
$row = mysql_fetch_assoc($query);
if ($row['hash'] == $hash) ..

One scenario you're requiring MySQL to match two things (the hash field would be 32 characters long, like a md5 string), the other way it would only have to find one field (a unique, primary key integer, which should be very fast), but MySQL would need to pull the data and put into an array that PHP can then read to determine if the other field is a match. I'm thinking the all-MySQL way would be faster, but I didn't know about it having to search through hundreds of thousands of records for a string of that size.

Any thoughts? Thanks!

$HEADER = "http://www.google.com";
for($cwb=1; $cwb!=100; $cwb++)
  {
  $repeat = file_get_contents($HEADER);
  $msg = explode('<message>', $repeat);
  $msg = explode('</', $msg[1]);
  echo "#$cwb: ".$msg[0]."\n";
  }





why is this much faster?


$HEADER = "http://www.google.com";
$REPEAT = 100; // times to repeat
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
for($cwb=1; $cwb!=$REPEAT; $cwb++)
  {
  curl_setopt($ch, CURLOPT_URL, $HEADER);
  $msg = explode('<message>', curl_exec($ch));
  $msg = explode('</', $msg[1]);
  echo "#$cwb: ".$msg[0]."\n";
  } while($ch);
curl_close($ch);



is there anything faster than both of these options?

I have a 5000 item array of grocery UPC numbers and prices (here's a snippet): $myarray = array( '3540132662329' => '74.46', '8870132664186' => '63.24',

$ch = curl_init();
////////////////////////////////////
////////////////////////////////////
for($cwb=1; $cwb!=$Amount; $cwb++)
  {
  $action = file_get_contents($Game."refresh_stat_manual?user_id=".$Keys[0]."&auth_key=".$Keys[1]);
  $xml = simplexml_load_string($action);
  foreach($xml->xml->viewer->user as $stats)

    {
    $energy=$stats->energy;
    $level=$stats->level;

}
  if($energy <= 0 || $Stop <= $level) { echo "REACHED EITHER LEVEL $Stop OR... YOU ARE OUT OF ENERGY...\n"; sleep(100000);  }
  $send1 = $Game."send_requests?user_id=".$IDone."&to_user_ids=".$Keys[0]."&auth_key=".$AuthOne;
  curl_setopt($ch, CURLOPT_URL, $send1);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $send2 = $Game."send_requests?user_id=".$IDtwo."&to_user_ids=".$Keys[0]."&auth_key=".$AuthTwo;
  curl_setopt($ch, CURLOPT_URL, $send2);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $accept = $Game."accept_all_mob_requests?user_id=".$Keys[0]."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $accept);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $job = $Game."do_job?user_id=".$Keys[0]."&job_id=7200018&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $job);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $exec1 = curl_exec($ch);
  if(stristr($exec1, 'You gained 6') || stristr($exec1, 'You gained 1') || stristr($exec1, 'ambulance'))
  { echo "#$cwb: <-- You've gained 1 ambulance... Level - ".$level." ::: ENERGY - ".$energy." :::\n"; }
  for($abc =1; $abc!=2; $abc++){
  $remove1 = $Game."remove_mob_member?user_id=".$Keys[0]."&remove_user_id=".$IDone."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $remove1);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);}
  for($abc =1; $abc!=2; $abc++){
  $remove2 = $Game."remove_mob_member?user_id=".$Keys[0]."&remove_user_id=".$IDtwo."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $remove2);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);}
  $sell = $Game."buy_item?user_id=".$Keys[0]."&item_id=32&amount=".$Amount."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $sell);
  $exec2 = curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  if(stristr($exec2, 'sold'))
  { echo "::: You've sold 1 ambulance...\n"; }
  }
curl_close();



Any idea on how I could make this faster or what I could change to make it to more efficient

i need this code to execute faster, is there a faster way?

function all_word_combinations($all_words_unknown,$previous_string=''){

$all_words_2=array();

if(is_array($all_words_unknown)){
$all_words_array=$all_words_unknown;
}else{
$all_words_array=explode(' ',trim($all_words_unknown));
}

$item2remove='the';
$all_words_array=explode(' ',trim(str_replace($item2remove.' ','',str_replace(' '.$item2remove,'',(implode(' ',$all_words_array))))));

if(count($all_words_array)>1){

$previous_array=explode(' ',$previous_string);
foreach($all_words_array as $one_word){
if(!in_array($previous_string.$one_word,$all_words_2) && !in_array($one_word,$previous_array)){
$all_words_2[$previous_string.$one_word]=$previous_string.$one_word;
$all_words_2=array_merge($all_words_2,all_word_combinations($all_words_array,$previous_string.$one_word.' '));
}
}
return $all_words_2;
}else{return $all_words_array;}
}

$one_word_combination='';
foreach(all_word_combinations('cat dog mouse turtle shark whale elephant giraffe lion tiger fish monkey') as $one_word_combination){echo str_replace(' ','-',$one_word_combination).'<br />';}

I'm having a problem and need an answer to why its happening and how to prevent it.

Scenario:

I begin load my home page which starts with a session_start(); .... Before it FULLY completes loading I try to navigate to another page and BOOM, that page will not load and any other page that begins with session_start(); will not load unless I close and restart the entire browser or wait about 10 minutes....

I will note my website makes ajax calls every 5 seconds or so, but I use setTimeout for them.

 

Any help??? Thanks ahead!

Hello,
I'm developing a browser based
chat clients(like the one
facebook and gtalk uses) which
requires an instant generation of
of blocks of html code on clicks.
So, what i'am basically trying to
do is first writes it down the
generated code on a text file
using php fwrite function and
load it immediately into the site
as soon as it is done.
Some disadvantages using this
system of techniques is the
various calculations involved
which i believe will delay in the
deleivery of the code generated.
On the otherhand, this is not so
in the case of mysql database as
all the values are uniquely stored
and determined but the whole
lot process of querying and
reteieving is another factor that i
believe will slow down the
performance.
please tell me which gonna be a
faster one...thanks,

p.s
almost 50percent coding done

I read the tutorial, "Handling XML Data" and created this script from it. Excellent tutorial by the way

Here is my script:
Code: [Select]
<?php
// load SimpleXML
$fx = new SimpleXMLElement('http://www.boj.org.jm/uploads/fxrates.xml', null, true);

echo '<table><tr class="fx_header"><th class="fx_date">';
echo $fx->US[0]->DATE;
echo '</th><th class="fx_buy">Buy</th><th class="fx_sell">Sell</th></tr><tr class="fx_us"><td class="fx_legend">USD (&#38;#36;)</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->US[0]->BUY;
echo '</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->US[0]->SELL;
echo '</td></tr><tr class="fx_cad"><td class="fx_legend">CAD (&#38;#36;)</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->CAD[0]->BUY;
echo '</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->CAD[0]->SELL;
echo '</td></tr><tr class="fx_gbp"><td class="fx_legend">GBP (&#38;#163;)</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->GBP[0]->BUY;
echo '</td><td class="fx_buy_sell">&#38;#36;';
echo $fx->GBP[0]->SELL;
echo '</td></tr></table>';
?>

This is the XML file that the script is reading from: http://www.boj.org.jm/uploads/fxrates.xml

This is the result page (which is just the way it should look): http://projects.wstudiographics.com/ewl/boj/fxrates.php

It works very well, but it take a bit of time to return the result. I think it's because of how the XML file data was set up. The thing is that I have no control over the xml data. I am only allowed to read it. I only need the first or rather latest instance of the data.

Any help on this will be greatly appreciated. Thanks in advanced.

Winchester (WStudio)

I apologize for the length of my script. Is there a better way to do some of what I am doing here? My script is working fine but it works off a lot of data and if I try to query all the results, the response is pretty slow (1500ms). 

I'm concerned about that length of time when it comes to multiple users hitting the server at once. I may have to limit the query with pagination, etc. But, I just have a feeling there's a better way to do what I'm doing without over 1,000 lines....

 

//fetch production data
if( $action == 'fetch_production_data' ) {

	//setup query
	$sql = 'SELECT * FROM production_data ORDER BY enterprise, job_number, TRIM(line_item) ASC';

	//execute SQL transaction
	try {
		//prepare SQL statement & execute
		$stmt = $pdo->prepare($sql);
		$stmt->execute();

		//bind column names to variables
		$stmt->bindColumn('id', $id);
		$stmt->bindColumn('job_number', $job_number);
		$stmt->bindColumn('enterprise', $enterprise);
		$stmt->bindColumn('part_number', $part_number);
		$stmt->bindColumn('description', $description);
		$stmt->bindColumn('qty', $qty);
		$stmt->bindColumn('line_item', $line_item);
		$stmt->bindColumn('as400_ship_date', $as400_ship_date);
		$stmt->bindColumn('date_showed_on_report', $date_showed_on_report);
		$stmt->bindColumn('shipping_method', $shipping_method);
		$stmt->bindColumn('notes', $notes);
		$stmt->bindColumn('date_shown_complete', $date_shown_complete);
		$stmt->bindColumn('actual_ship_date', $actual_ship_date);
		$stmt->bindColumn('qty_shipped', $qty_shipped);
		
		//store user dept code
		$user_dept_code = get_user_dept( $_SESSION[ 'user_id' ], $pdo );
		
		//$button = '';
		
		//output data into spreadsheet view
		while($row = $stmt->fetch(PDO::FETCH_BOUND)) {
			
			//setup vars to store button HTML
			$btn_qc 					= '';
			$btn_thermoforming 			= '';
			$btn_vinylpaint 			= '';
			$btn_finalassm 				= '';
			$btn_crateship 				= '';
			
			//store each dept status query for performance
			$status_qc					= isset( get_order_status( $id, 10, $pdo )[0]['status_id'] ) ? get_order_status( $id, 10, $pdo )[0]['status_id'] : '0';
			$status_thermoforming 		= isset( get_order_status( $id, 6, $pdo )[0]['status_id'] )  ? get_order_status( $id, 6, $pdo )[0]['status_id'] : '0';
			$status_vinylpaint 			= isset( get_order_status( $id, 5, $pdo )[0]['status_id'] ) ? get_order_status( $id, 5, $pdo )[0]['status_id'] : '0';
			$status_finalassm 			= isset( get_order_status( $id, 7, $pdo )[0]['status_id'] )  ? get_order_status( $id, 7, $pdo )[0]['status_id'] : '0';
			$status_crateship 			= isset( get_order_status( $id, 8, $pdo )[0]['status_id'] )  ? get_order_status( $id, 8, $pdo )[0]['status_id'] : '0';	
			
			$status_msg = 'Order ' . $id .' ';
			
			//echo $status_vinylpaint . '<br>';
			
			//build view based on user's department code
			switch ( $user_dept_code ) {
				
				//Design or AMS View
				case '4':
				case '9':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//Vinyl & Paint View
				case '5':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5">Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//Thermoforming View
				case '6':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6">Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//Derrick Donnel's View
				case '7,8':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order for qc dept
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for qc dept
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for qc dept
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Not Started</button>';
							break;
					}
					
					//determine status of order for qc dept
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//Final Assembly View
				case '7':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7">Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//Crating & Shipping View'
				case '8':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10" disabled>Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8">Not Started</button>';
							break;
					}
					
					//break parent switch
					break;
					
				//Quality Control View'
				case '10':
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10">Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_qc = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10">Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_qc = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10">Not Started</button>';
							break;
							
					}
					
					//determine status of order thermoforming
					switch ( $status_thermoforming ) {
						
						//order in progress
						case '1':
							
							$btn_thermoforming = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_thermoforming = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_thermoforming = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_thermoforming = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="6" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for vinyl & paint
					switch ( $status_vinylpaint ) {
						
						//order in progress
						case '1':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_vinylpaint = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_vinylpaint = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_vinylpaint = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="5" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order final assembly
					switch ( $status_finalassm ) {
						
						//order in progress
						case '1':
							
							$btn_finalassm = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_finalassm = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_finalassm = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_finalassm = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="7" disabled>Not Started</button>';
							break;
					}
					
					//determine status of order for crating & shipping
					switch ( $status_crateship ) {
						
						case '1':
							
							$btn_crateship = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_crateship = '<button type="button" class="btn btn-danger btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Delayed</button>';
							break;
							
						//order finished
						case '3':
							
							$btn_crateship = '<button type="button" class="btn-success btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Finished</button>';
							break;
						
						//order not started
						case '0':
						default:
							
							$btn_crateship = '<button type="button" class="btn btn-secondary btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="8" disabled>Not Started</button>';
							break;
					}
					
					//break parent switch
					break;

				//SU/Op. Mngt/Prod. Mngt View
				case '1':
				case '2':
				case '3':
					
					//determine status of order for qc dept
					switch ( $status_qc ) {
						
						//order in progress
						case '1':
							
							$btn_qc = '<button type="button" class="btn btn-warning btn-sm btn_change_order_status_dialog" style="margin:0; width: 100px; height:100%; font-weight: bold;" data-order-id="'. $id . '" data-order-number="'. $job_number . '" data-order-enterprise="'. $enterprise . '" data-dept-code="10">In Progress</button>';
							break;
						
						//order delayed
						case '2':
							
							$btn_qc = '<button type="button" cla