List of Repairs

query("SELECT r.*,CONCAT(c.firstname,', ',c.contact,' ',c.lastname,' ',c.email,' ',c.middlename) as client from `repair_list` r inner join client_list c on r.client_id = c.id order by unix_timestamp(r.`date_created`) desc "); while($row = $qry->fetch_assoc()): ?>
# Received Date Complain ID Customer Info RMA Status Deliverey Date Assigned Engineer Name Repair Eng Status Repair Date Total Bill Issuing Branch Issuing Branch Incharge Action

In-Progress'; break; case 1: echo 'Approved'; break; case 2: echo 'Under Diagnosis'; break; case 3: echo 'QC Pending'; break; case 4: echo 'QC Passed'; break; case 5: echo 'Repair OK'; break; case 6: echo 'Same Back Delivery'; break; case 7: echo 'Repair Fail'; break; case 8: echo 'Delivered'; break; case 9: echo 'Delivered-Payment Due'; break; } ?> None'; break; case 14: echo 'SK-SAYED HOSAIN-(MP)'; break; case 15: echo 'Alomgiar NITC-(MP)'; break; case 16: echo 'Saiful Islam-(MP)'; break; case 17: echo 'Pulak Sukul-Panel Dept-(Banani)'; break; case 25: echo 'AQ Tusher-MSI Dept-(Banani)'; break; case 32: echo 'Tanvir Hossen-MSI Dept-(Banani)'; break; case 33: echo 'SK-Alomgir-Acer Dept-(Banani)'; break; case 35: echo 'SHAWON_ACER Dept-(Banani)'; break; case 34: echo 'Md Hridoy Howlader-MSI Dept-(Banani)'; break; case 36: echo 'MD Shoel Rana-Inch MSI Dept-(Banani)'; break; case 27: echo 'MD.GIASH UDDIN HOWLADER'; break; } ?> Under Diagnosis'; break; case 3: echo 'QC Pending'; break; case 4: echo 'QC Passed'; break; case 5: echo 'Repair OK'; break; case 7: echo 'Repair Fail'; break; } ?>

BDT-

None'; break; case 10: echo '(Dhaka) Multiplan Center Br'; break; case 11: echo '(Dhaka) Banani Br'; break; case 12: echo '(Sylhet) Westworld Shopping Complex Br'; break; case 13: echo '(Dhaka) Banani Head Office'; break; } ?> (None)'; break; case 18: echo 'Tanjina Urmi-RMA-(MP)'; break; case 19: echo 'Alomgiar-NITC-(MP)'; break; case 20: echo 'Saiful Islam-ENG-(MP)'; break; case 21: echo 'Yousuf Ashru-RMA-(Banani)'; break; case 22: echo 'Shibly Nomani-RMA-(Banani)'; break; case 23: echo 'zahidul Islam-RMA-(Banani)'; break; case 24: echo 'MD.GIASH UDDIN HOWLADER (MP/BAN)'; break; case 30: echo 'Samaed-RMA-(Sylhet)'; break; } ?>