Custom Badge Document

Report Printing document

SELECT
(CASE
   WHEN Status IS NULL  > '' THEN 'Not Review'

             WHEN Status = 1 THEN 'Printed'
             WHEN Status = 2 THEN 'Reject'
           
       END) AS Status,
IF(Status IS NULL, 'N/A', Status) AS Status1,
 IF(DocNumber IS NULL, 'N/A', DocNumber) DocNumber,

`Comp name`,
`Person Name`,
`Issuing Date`,
Profession,
ExpDate,
   IF(Payment IS NULL, 'N/A', Payment) Payment,
 IF(Amount IS NULL, 'N/A', Amount) Amount,

Photo
FROM badge
WHERE (Idb ='1222')