$ord_id = $toggle_id[0]['order_id']; ?> <tr class="toggle test_<?php echo $ord_id; ?> "> <td colspan="4" align="center"> <table width="755" align="center" cellspacing="0" cellpadding="0" style="margin:10px 0px; padding: 10px; border: 2px solid #F99B3E;"> <?php $sql_id = mysql_query("SELECT id,order_id,created_date,order_number,customer_name FROM sohorepro_order_master WHERE id = '" . $ord_id . "'"); $object = mysql_fetch_assoc($sql_id); $Order_id = $object['order_id']; $ref_serial = $object['id']; $Order_number = $object['order_number']; $cust_dtls = customerName($object['customer_name']); $cus_name = $cust_dtls[0]['cus_fname'] . $cust_dtls[0]['cus_lname']; $cus_phone = $cust_dtls[0]['cus_contact_phone']; $cus_mail = $cust_dtls[0]['cus_contact_email']; $current_timne = $object['created_date']; $dateF = new DateTime($current_timne, new DateTimeZone('America/New_York')); date_default_timezone_set('America/New_York'); $temp_time1 = date("Y-m-d h:iA", $dateF->format('U')); $Date = date("m-d-Y", strtotime($object['created_date'])) . ' ' . date("h:iA", strtotime("-180 minutes", strtotime($temp_time1))); //$Date = date("m-d-Y h:m A", strtotime($object['created_date'])); ?> <tr> <td> <table width="755" align="center" cellspacing="0" cellpadding="0" > <tr align="left"> <td><table align="center" cellspacing="0" cellpadding="0" >
foreach ($Orders as $order) { $rowColor = ($i % 2 != 0) ? '#dfdfdf' : '#eeeeee'; $rowColor1 = ($i % 2 != 0) ? '#eeeeee' : '#f6f2f2'; $id = $order['id']; $customer = $order['customer_company_name']; $order_numer = $order['order_sequence']; $cas_customer = $order['cash_customer']; $current_time = $order['created_date']; $datew = new DateTime($current_time, new DateTimeZone('America/New_York')); date_default_timezone_set('America/New_York'); $temp_times = date("Y-m-d h:iA", $datew->format('U')); $date = date("m/d/Y", strtotime($order['created_date'])) . ' ' . date("h:iA", strtotime("-0 minutes", strtotime($temp_times))); $entered_needed_sets = ServiceSets($id); $cust_dtls = customerName($order['user_id']); $customer_name = $cust_dtls[0]['cus_contact_name']; $customer_phone = $cust_dtls[0]['cus_contact_phone']; $customer_mail = $cust_dtls[0]['cus_email']; ?> <tr class="trigger" id="<?php echo $id; ?>"> <td width="210" height="36" align="center" bgcolor="<?php echo $rowColor; ?>" valign="middle"><?php echo $order_numer; ?></td> <td width="176" height="36" align="center" bgcolor="<?php echo $rowColor1; ?>" valign="middle"><?php echo $date; ?></td> <td width="109" height="36" align="center" bgcolor="<?php echo $rowColor; ?>" valign="middle"><span id="customer_name_<?php echo $id; ?>"><?php echo $customer; ?></span></td> <td width="210" height="36" align="center" bgcolor="<?php echo $rowColor1; ?>" valign="middle"><span class="refj_<?php echo $id; ?>" id="<?php echo $id; ?>"><?php echo $order['reference']; ?></span></td> </tr> <tr class="toggle test_<?php echo $id; ?>"> <td colspan="4"> <div style="width:99%;float:left;margin:4px 0px;border: 2px solid #F99B3E;">