<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";
    require_once 'dompdf/autoload.inc.php';
    use Dompdf\Dompdf;

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $logo = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAzgAAADiCAYAAACCwWJWAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAACAsSURBVHhe7d2xrvXKed5x30RuIW2QVneQOwiQKp07VS5TqEgbtypUuTUUIIWKqEgRuAhcCDDcCC4CF64MOIY7d1/wHh9C29+ZxUVyPUMOh78/8AcEnf2tzcUZzrzPcMj9R98AAAAAYBIEHAAAAADTIOAAAAAAmAYBBwAAAMA0CDgAAAAApkHAAQAAADANzYDzl3/1999++xd/R5IkSZLD+Q//+M8/Jpef0gw4/+FPfvvtj/7Tn5MkSZLkcFbIeYWAQ5IkSfJWCjgkSZIkp1HAIUmSJDmNAg5JkiTJaRRwSJIkSU6jgEOSJElyGgUckiRJktMo4JAkSZKcRgGHJEmS5DQKOCRJkiSnUcAhSZIkOY0CDkmSJMlpFHBIkiRJTqOAQ5IkSXIaBRySJEmS0yjgkCRJkpxGAYckSZLkNAo4JEmSJKdRwCFJkiQ5jQIOSZIkyWkUcEiSJElOo4BDkiRJchqHCjg/+/lvfjggkiRJknP6p3/2180skLJ+xytODzj12QAAAADmpQJIKwukFHAAAAAAnIaAAwAAAGAaBBwAAAAA0yDgAAAAAJgGAQcAAADANAg4AAAAAKZBwAEAAAAwDQIOAAAAgGkQcAAAAABMg4ADAAAAYBoEHAAAAADTIOAAAAAAmAYBBwAAAMA0CDgAAAAApkHAAQAAADANAg4AAACAaRBwAAAAAEyDgAMAAABgGgQcAAAAANMg4AAAAACYBgEHAAAAwDQIOAAAAACmQcABAAAAMA0CDgAAAIBpEHAAAAAATIOAAwAAAGAaBBwAAAAA0yDgAAAAAJgGAQcAAADANAg4AAAAAKZBwAEAAAAwDQIOAAAAgGkQcAAAAABMg4ADAAAAYBoEHAAAAADTIOAAAAAAmAYBBwAAAMA0CDiI8Jd/9fc/NPaa//CP//zjTwMAAAB9qLqzlQVS1ue/QsC5GRVQqkF/8cvfffuP/+V/HW6rf/Of//sP//aP/+v//uGzhB8AAACkEHCwyp//z//77U/+2//59rOf/6Z5TpP+2z/+Hz+Enl/9+vff/uZv/+nHI+hD3XGq/nAH6/wvQfCpVD9snZuk1SdGo9q+dax7rfM3AnVtt45vr0dIncuEyzVd58MCT5uR2mtUt5C65u5mfe+9pOqCqmNGoXV8ez1yLkdAwMFPqEarC7TutLTO41lWqPrTP/vrLmGnd8fvafXjXudlVOqOYetcJK2CajRS42EtHoxQRFdR3zq+vR6h59ySsNqo+vnTFzMWRm+vEdxC6pq7m/W995KsC0ZZVGod216PnMsR6F3nrY3TAs5AVPFTKb0m2da5u9pqu+Qqwp0DzlerIJq9GKq+2fruaavvj0ZyPBwhwAk4260Fprq+a9x74h2eu7XXFW5BwNlOsi6o63eE67Z1bHsVcNoKOINTF2B13qvv1my1itA63k8HjlkCzmL17RG3WCWoAq/1nXs42jlMj4dXf79UsXWEOxfMNT7XXfXZFzO+cuf2OsstpK65u3mkKE/XBSNsVWsd116PnMsREHAeTBWOdwk231vHXdu0jjJbwFmsVfrZVnvP2J62ONo2tfR4WNs+r0TA+dz6Hsm72aMyS3v1dAsCznZ61AVrRfAZtI5prwJOWwFnQGoV94yXBpxhfY8jq9KzBpzy6DkZkQprre/Yy9G2qfUYD6+crAScnHWdX1089UTAee8WBJzt9KgLak65ctGxdUx7FXDaCjiDMetgt/cCnDnglHWHa5SHHD/hzO1piyOFwx7jYfWNq15QkRp/jjBrwVx3OGd84YiA894tzDrnv/NIUd6rLjhyLClax7PXK4//EwSch1AT4Cx3bV5ZE/3WlZLZA87i3beynLk9bXGkbWq9xsOrxkIBp4+fbtkdkZnbK+UWBJzt9KwLrlo4ax3LXgWctgLOAFQj3PVZmz3WdxRwfupdQ87Z29MWR9qm1nM8vKJfCDh93bPIMzoCznu3IOBsp2ddcFX92TqWvQo4bQWci7lii89V7rkInxRwKvjd8ZmcK/vuKOer53i4Z0EghYDT31mewXtKe33iFgSc7fSuC664y9o6jr0KOG0FnAupi6l1HmZ0b7H2pIBTXv2g4xGu2J62OMo2td5F3tmvMRVwzvGuixpfEXDeuwUBZzu964K6Ls9+Xq51HHsVcNoKOBdRhUvrHMzq3gvwaQGnHO0VyGtctT1tcZRtamcUeWuDdBoB5zzvHnIEnPduQcDZzhl1QS3cnUnrGPYq4LQVcC7gSXduyiNbbZ4YcMozi9lPGGFr5QjF4RlF3pl39wScc71zyBFw3rsFAWc7Z9UFZ77htPX79yrgtBVwTuZJz9wsjjyQjeZdroErt6ctjnDH66wi76wJLFVsHeGpBfORBaAReGp77XELqWvubo5cF5x5TbZ+/17Pmh/SCDgTMUrRXivCda7LujAWq2it/6/+e+vfHfHoQJE6Vz2oY6u7cMnz9NW1i3IEqj1bx322I2xT6zkefu8ZK/01DrR+916PcOa5HM168cDdeHJ7bXULqWvubtb33suZNdRZC2it373XI+dyBHq351otJeAEqaKwiv3W9+5tBZcqyPcUznW89fN14Xzy93mOXnipjt+bupWdDjqjXwcj3YW8envPmUXeGUVwqtg6Qupc1ufscZS/P3anZ/CKuvZqnD7D1Lbueva19fm93ELqmmv17ZGteWQvdU5b372XW9vwE1q/d68CTtu19hNwgvQ8by2XASR1m7XeLFKTzJ5i4JPbvKmOfwb1HdMvjRj5L58ntqelwv7VReHZ13Vdgz2ZIeB8Qo07dY7reu51h3bNMwqqO5KaD0YsBK+85u5Gqh9s9YxdAq3fu1cBp+3aeCrghEgNYFusibl3cVwrd1sK+k8uulTHP5NkyOldyB6lwlzrePda5yoRlK7epnZ2wKlg2PP6vrLYGiHgfE+d6zonZ4Wd+j2pRamZEHDe+wTODjhl7z7T+p17HbFfb0HAuTk1Qba+a9oqFs9e9a/f96qo/+TuTXHHgFMkivZy1GshtT2ttvalPuvKbWpnB5yyZ9+4sthKncteVJ89o73vWqz0RMB57xO4IuCUPWur1u/bq4DTVsDpTO8JsVb81hrxDOri//57fnrBpTr+2VSoS22/GpHU9rQidTfoym1qZxS8LXu9xvTKYit1LntTwTx1jb/y7MWq0UnNBwLOveldEL+yZ23a+n17FXDartXGAs6HVBHS+p4pq9gcaTvDMvF/evemuGvAKVJ3JtYuzitIBZK667dw921qVwWcxDXWQsDZRp371N3all+vEQg4W3wCvQviNXttG2/9rr0KOG3XaigB50N67tsetUPXdqEq8D8l1fGvIrHCmziPSVLB7evdh9RnXrVN7aqAU/a4cyXg7KPaoHUMCd3F+QMCznufwJUBp9eiUut37VXAaSvgdCJVuLUcrfDtwd0DTuKFA6MNWsntaQupu0JXbVO7MuCUawP4EQSc/fQa669+Q+BIpOYDAefe9C6I31lzYJrW79mrgNN2bX4UcD6g192bJ4SbItXxryJR9IxU4PTYnrZw521qVwec9PcWcI7R407O94sBT0bAee8TuDrglOnnH1u/Y68CTlsBpwO9nr15Srgp7h5wEsc/0vWQWqVuTQ6pz75im9rVAadMTm4CznF69IUnjflrpOYDAefe9C6It1iLSsmtaq3fsVcBp219/isEnIP0OEdPe+g01fGvInH8I10PPbanLdSzBq2f3+sVd7x6jod7TIU7Aec4VfQknr37ao8tMXckNR8IOPemd0G81eRc0/r8vQo4bevzXyHgHCBVrH31Zz//zY+f/hxSHf8qEsc/yvXQc3vaQvXx1r/Z4xXb1EYJOKm+IuB8Rr1pqXVMn5hcLb4rqflAwLk3vQviPa4Vz3toffZeBZy2a20k4BygxwR35R8yvIpUx7+KxDbFUZ7B6bk9bSF13Zx9rYwScMrEa0wFnM9JP3+Z3vN/R1LzgYBzb3oXxHtMLTy3PnuvAk5bASdMYiX6q3ftuJ9y94CTeOh4lLbvuT1t4a7b1EYKOHWOP3218JXF1iwBJ7UgsOhv4gg4W3wCIwWcMtGfWp+71xH79RYEnBuR3p5WBctTtyfcPeAkVnFHeMD4jO1pC3fcpjZSwCk/fWZDwMmQfBbniq2XoyHgvPcJjBZwEotKrc/dq4DTVsAJkl65u2unTXDngJM69hG2Jp6xPW3hjtvURgs45SdbmgScDBXoW8d21Kc/h5MaUwWce9O7ID7ip3Vr6zP3KuC0rc9/hYCzk+Sk9uS7N0Wq41+BQu1fW315C3fcppZq68Q2wMVa8T86dgg4GRLP4H11baJ+Aqn5QMC5N8l+0Pr/j/rJbovW5+1VwGm7Nm4KODtJPlw6ygPmV5Hq+GeTugsxyuthE1tt9jxDcLdtaqnxsAJJclvT0fFDwMnROraj3rWASSHgvPcJpPpBfU7iOdnFTxakW5+3VwGnbX3+KwScHVTnbn2noz7xzWlfSXX8M6k2SxWpIzx/k1qF3rNl6m7b1JJFeXqL69rg/goBJ0dyrrTgJeC8sz5nFD99LuUVqX5Qn1M1W3JR+uiiZOuz9lrn/I6k2vOVa3OggLODZEN5qPR+AScZbsqjq0FJztyetnC3bWrpojw5vh55jWlNlK3P2usR0ufyalLnsrzz3JggNR+MWAgm+8korhWWn5DqB8vxjbCVtPU5exVw2q61h4Czg+Tq654tPbOS6vhnkJ6gRmn/RGA78l3utE0tXZRXwEsG5b0TX6ovH2G2gJMsno6E1ZlIzQcjFoLp+WMEjxT6W0j1g6/Hd/Xzj63P2euI/XoLqfZ85Vo/FHB2kBykRtiedDWpjt+LKkRrO1XyFvdir9v7e7hie9rCnbap9SjKU99/cU9/EnBypCfvJ5M6lwLOOa4Vlp+Q6gdfj68CSXJRae/ugdZn7FXAabvWDwWcHSS28yz2LMzqs+s8X+XW75bq+HXhp6w2ru+QuMPwylHu3iT6897taQt32qZW/aH1u/f6PanPLeuztlL9vPUZez1Cr3N5FennMp9Mcj4YjdQ1N5JrheUnpPrB98eX3qq2p4Zr/fu9jtivt5Bqz1eu9UMBZwfJ89KT3h3qnWsd7itXH+cVViAY4e5NcdX2tIW7bFPrVZTXBNn6uaPWXaEtCDhZWsd31CeTmg8EnHPcOs/vJdUPWseXrOH2bClt/fu9Cjht1/qhgLOD1Hk5uuq9ld4d6p1rHe4rVx/nFW4tQntz5fa0hbtsU+tZlCcLnxpXtuwNF3CytI7vqL378sik5gMB5xy3zvN7SfWD1vHV4mJiYW9x63ze+rd7FXDarvVDAWcHqfPS+xz07lDvXOtwX7n6OM92pL5/5fa0hdQ2td4Df+q6f0VyO+SW15gKOFlax3fUrWPnjKTmAwHnHHv11VQ/eHV8yecfaw7csiOj9W/3KuC0XeuHAs4OUuel9zno3aHeudbhvnL1cZ5pFbEjvBZ6IbGKlXiWKFHc79kqcITeRXl6q9q760/AydI6vqNuHTtnJDUfCDjn2KuvpvrB2vGlxqFySz3X+nd7FXDarrWzgLOD1HnpfQ56d6h3rnW4r1x9nGdZYWKkrScjbE9bSK2m9XyuKXXdr5H8i9vvXmMq4GRpHd9Rt46dM5KaDwScc+zVV1P9YO34UrsHFt/Nha1/s1cBp+1aOws4O0idl97noHeHeudah/vK1cd5hqOFm2KE7WkLqYmm57NNZxTlFUiSryNfe7ucgJOldXxH7RnURyc1Hwg457h1nt9Lqh+8O75km9R8uLao1Po3exVw2q61s4Czg9R56b2lpneHeue7gWXh6uPs7Wjb0hZG2Z62MPo2tbOK8vT18CpYCzhZWsd31CeT6v8Czjlunef3kuoHW44vMfcsrs2JrZ/fq4DTdq2dBZwdJM9LT3p3qHduGViKq4+zp7WCPmK4GWl72sLo29TOLMqTW9VehT4BJ0dd463jO+qTSc0HAs45bp3n95LqB1uO76znH1s/u1cBp+1aOws4O6g3FLW+0xF70rtDvXPLwFJcfZw9rKJy6/e/gpG2py2Mvk3tzKK8CubEHbbF1qQo4ORIjmHp6+pupM6lgHOOvea5VD/YenzJtnn1/GPrZ/c6Yr/eQnKMbLnWzgLODpIXQq/Boejdod659btdfZxJq1//6te///Gbjcto29MWRt6mdnZRnrrLVlZ7f39nKzWOHWG2gFPXfOv4jnjnuTFBaj4YsRBMXXP1OaPY6455qh9srUMqkCSff6xz8z2tn9tr63PvQO86b62dBZwdVAdrfacj9iyGe3eod24dWK4+zpSjvUTgFSNuT1sYeZvaFUV58m7x92Nuahw7whXnsifJLYVb/obRzKTmgxELwSuvubuR6gdb65AiXYt8XxO0fmavAk7btXYWcHaQbKgeq+ALvTvUO9c63FeuPs6Udxl4EtvTRrfHNrUrivL0VrWvCyoCTo7kQ8p3LWBSpOaDEc/jldfc3Uj1g611yEJyseL7Orf1M3u96/jQu85ba2cBZwepZwXKuiXai1o9qPN8xERRtXVg6d3xz7K1DWhEkgXzqPbYplbXRet37XUvye1P1fbL3nABJ0Odz9axHbXHndE7kZoPBJx7k+oHW+uQhfRWta+Lba3/vlcBp+1aOws4O0kWiSNubUq0/daBJdXxj5IsIEffXpJ8rmN002HzyqI8ORYvd40FnAzpa+oOiyQ9Sc0HAs69SfWDrXXIV5LX9NeFz9Z/36uA03atnQWcnSTPzdof47uKxPfbOrCkOv4nJNtz5BXYJ2xPW0xvU0v1kSPUBJlcVKlrTsDJkLymet7Rvwup+UDAuTepfrC1Dvme5POPy8Jn67/tVcBpu9bOAs5OUgNVOeKklmj7rQNLquN/QvLiq/ZctgGNxhO2py2mt6ldXZSnXsBQVh9N7TU/wiwBJ709reczmXchNRYLOPcm1Q+21iHfU9d2cr5M3RUScNqutbOAs5P0H4bq+Ta1Izwt4BTJldgRB6EnbU9bTG73GaEoT47Jqcn7CCOcywTJ0FmONg9cQWo+EHDuTaofbK1DWqS3qrX+/70KOG3X2lnAOUAy3Y92PhJtv3VgSXX8T0lvAxptL/2TtqctJrepjVCUpxdWEh5hhHOZIPkwcjnqnd8zSc0HAs69SfWDrXXIK1JjVUoBp+1aOws4B0gXjCOt3iXafuvAkur4CVITUDlaH0+Gt7uY3KaWGg8/JdlHEx5hlHP5Cel2ePrfv1lIzQcjFoKpPvMEUv1gax3yivTC56eO2K+3kGrPV661s4BzgHSDjfTsRqLttw4sqfOYoM5/clV2lBcOPHF72mLqTtpIRXny76586hHuHnDS+/NL29P+hdR8IODcm1Q/2FqHrJHeivqJAk7btXYWcA6S3qIwykOmTw04RXrf7Qih9Ynb0xZT29RGKspH2qp2hLsHnOQblspRxokRSM0HAs69SfWDrXXIO3rWw3sUcNqutbOAc5AeyX6ElbxE228dWFIdP0my74/wGvAnbk9bTG1TS/WJFMm/uP2JRxjtXO6hx5g/4p8KuIrUfCDg3JtUP9hah7yjdgK0Pv9sBZy2a+0s4Bykx1aF+ryr//hnou23Diypjp8kvUJ+ZXs+eXvaYmKb2mhFeXo75VGPcNeA0+taGu2FJFeSmg8EnHuT6gdb65AtpNrvEwWctmvtLOB8QI9Of3XIeXrAKZLbuq7s70/enraY2KY2YlHee9LY4hFGPJfvqPG4x53QUbYlj0KqTws49ybVD7bWIVu5+vlHAaftWjsLOB/Q4y5OeWXISbT91oEl1fHTpNv1qq2HPfrm3UxsUxu1KL96q9oR7hZw6trtdR25e/OvSc0HAs69SfWDrXXIVtK7O/Yq4LRda2cB50NSA1fLKwpjAedfSLZrFUhnP0hse9of/LSQHLUo77XAstUj3Cng9BzbPXvzU1LzwYiFYKovPYFUP9hah+yh55jwzhH79RZS7fnKtXYWcD6k9374emvPmcWxgPMHku16dkGT2p525d/oSJ3/T7epjVyUXxlkj3CHgFMrtT3nwCsWPO5Aaj4QcO5Nqh9srUP20LveW1PAabvWzgJOgN5FRk2IZ93NSbT91oEl1fF7kW7XHgPuK1Ir+1e+2S+1BevTbWqjF+XpVxdv9Qgjn8u603fGc2s1ruCnpOYDAefepPpBr/k2dXx7FXDarrWzgBPijCKjVg56Fpyp1YmtA0uq4/ckeS2kXlv8jmQwu3KluQrO1jEd8ZNtaqMHnGqjK7aqHWHEc1nXy1kv5LjyjujopOYDAefepPrB1jrkCFc8/yjgtF1rZwEnxJm3Luv31AWWfEi1JvlUkbR1YEl1/J4ki+wy9ccn10gVayO85Sn15ppPzvvoAaeohY/W7+zpEUY4l3VN1/mq/n1mMKzfdeWCweik5gMB596k+sHWOuQIZ9Z7iwJO27V2FnCCXPGWjSXsVEDZO3nWz9dEn27vrQNLquP3Jrlac0aRkyraRthKk/rjip/cPbtDwCl6jtstj5A6xprst1rXb/3es8/P9/YsuGYgNR9Um49GHVPrWPf6tV/fwSN9PtUPel9vyZ0SW6zzeUdS7fnKtXYWcMJcsZL61Spu6xzX6uTXgaYuxioW638vE37r3yfcOrCkOn5vKpAkV3p73hlJDbr1fUegzn3r+I549I5n6lrpTX2/ZD995xF6jjsj23Nr8Syk5oMRC8E6ptaxzu6Rtkj1g611yCec+fzjiP16C6n2fOVaOws4HUiu+N/RrQNLquOfQepOwmKvwXem7WkLqUnk6Da1uwScIt1P1zzCEwPOSNfSyKTmAwFnHGcPOOnFzzUFnLZr7SzgdCJVaN7RrQNLquOfRXLPbX1WD1KD7Qjb0xZSd0WPblO7U8ApzgoRR3hawBFutpOaDwSccZw94BRnbVUTcNqutbOA05GnhpytA0uq459F+kJND1ipgbZX+DpKcpXsyDa1uwWcs54FPMKTAo5ws4/U+CrgjOMTAk5xxrgm4LRda2cBpzNPDDlbB5ZUxz+T5LVRRfvR50JapPpabbEcjdR3O7JNLdXmZ3JGQXWEMwqBERRu9pOaDwSccXxKwDnj+UcBp+1aOws4J3D1iwfOduvAkur4Z1IDWesYjpr8uxipAbbuAIxG6u7UkW1qdww4ReoV2688whMCjhcKHCM1Hwg44/iUgFP0fv5RwGm71s4CzklUI/RO+CO4565EquOfTXqySgzEs25P+0rq+tl71+yuAaf3VrUjzBxwqn8mruWnkpoPBJxxfFLAKXqObwJO27V2FnBOpJ4lmH2C37P6n+r4Z5N+c0qFivrMT5h5e9pC6u2Ee7eppa7ZK+j5RscjzDr+1Z3YT6/hp5OaDwSccXxawEnv8PiqgNN2rZ0FnAuoAitZII9gteveCT7V8a8gve3w08HrqrsbZ5K6I7F3m9qdA05dk8m3/331CLMFnLruRnrj4J1JzQcCzjg+LeAUvdp6xH69hVR7vnKtnQWci6hC8sw/EtXLmuCPPLhdpDr+VaSfcTgaLq58PuVsUsX6nnN954BT9JpgjjBTwKm7Y+7a5Ej1UwFnHJ8YcIoezz8KOG3X2lnAuZhqnLtO+rUt6pMJPtXxryJ94R69Nq58w9jZpAqFPd81dX1eSY+take461j31breRr7TeVdS46mAM45PDTg9nn8UcNqutbOAMwjVSHeZ/FMTfKrjX0n6LtyR7S5P2J62UMfYOva97rlbNUPAqYWI9LbYI9w14NS5q5Ao2PQjNR8IOOP41IBTpNtcwGm71s4CzmBU8q8AkS5GPrXHBJ/q+FeSKrgX975wILU97U7XZer2/9a+PEPAKVJ9ZfEIdws4tYDhtc/nkJoPBJxxfHLAST//KOC0XWtnAWdQ6uKoifXq53SqmKzj+GQr2itSHf9q0pNXBcmtpLan3amIq+1lre+w163b1GYJOEVyPDnC6AGnxru6/rw44HxS84GAM45PDjhF6ruUAk7btXYWcG5AhYuacKuY7fVGpK/WJF/FX+/tGKmOfzXplZpy6+u2U3f6egTYXtSxtr7DXreORTMFnDp3qT5zhBECTn3/Oo6ywkyNdSMUQ08nNR8IOOP49IBT1BjTOr69Cjht19pZwLkhVaRUo1aHrxXZT9trmegrRJ1Z6C7f41NHoMJg69iO2jtcAgAA9KTqmVbdmbI+/xUCzmR8LZIrALWs7Uj13/f8UU4AAABgK1VrtrJAyvr8Vwg4AAAAAKIIOAAAAACmQcABAAAAMA0CDgAAAIBpEHAAAAAATIOAAwAAAGAaBBwAAAAA0yDgAAAAAJgGAQcAAADANAg4AAAAAKZBwAEAAAAwDQIOAAAAgGkQcAAAAABMg4ADAAAAYBoEHAAAAADTIOAAAAAAmAYBBwAAAMA0CDgAAAAApkHAAQAAADANAg4AAACAaRBwAAAAAEyDgAMAAABgGgQcAAAAANMg4AAAAACYBgEHAAAAwDQIOAAAAACmQcABAAAAMA0CDgAAAIBp+Ju//advv/jl77pZn/8KAQcAAADANAg4AAAAAKZBwAEAAAAwDQIOAAAAgGkQcAAAAABMg4ADAAAAYBoEHAAAAADTIOAAAAAAmAYBBwAAAMA0CDgAAAAApkHAAQAAADANpwcckiRJkvfzF7/83Y9p4T3/79//u+6+QsAhSZIk+VYBhyRJkuQ0CjgkSZIkp1HAIUmSJDmNAg5JkiTJaRRwSJIkSU6jgEOSJElyGgUckiRJktMo4JAkSZKcRgGHJEmS5DQKOCRJkiSnUcAhSZIkOY0CDkmSJMlpFHBIkiRJTqOAQ5IkSXIaBRySJEmS0yjgkCRJkpxGAYckSZLkNAo4JEmSJKdRwCFJkiQ5jQIOSZIkyWkUcEiSJElO460Dzq9+/fsfvgBJkiRJlr/9i7/7MS28pxVI0r6iGXAAAAAA4I4IOAAAAACmQcABAAAAMA0CDgAAAIBpEHAAAAAATIOAAwAAAGASvn37/2MmVVbM1N0bAAAAAElFTkSuQmCC";
    
    if (!empty($data->docid)) {
        $sql = " SELECT a.id, c.customer_name AS customer, d.brand_name AS brand, cust_order_no,
                        regexp_substr(a.ref_no, '[^*]*') ref_no, a.irrd, a.serial_no, a.total_ctn, 
                        to_char(a.carton_w, 'fm99D0') carton_w, 
                        to_char(a.carton_l, 'fm99D0') carton_l, to_char(a.carton_h, 'fm99D0') carton_h, a.gamma_batch_no, 
                        a.blank_batch_no, a.product_valid_code, a.loading_pattern, a.dose_required, 
                        a.maximum_acc_dose, a.minimum_acc_dose, a.carton_w1, a.carton_w2, a.carton_w3, 
                        a.carton_w4, a.carton_w5, 
                        a.total_weight, a.avg_weight, rtrim(to_char(a.carton_density, 'FM990D000'), '.') carton_density,
                        rtrim(to_char(a.tote_pack_density, 'FM990D000'), '.') tote_pack_density,
                        a.dose_mapping, a.routine_irrd, a.prod_pack_eval, a.dose_verification, 
                        a.min_dose_read, a.min_dose_status, a.max_dose_read, a.max_dose_status, 
                        e.employee_name prepared_by, to_char(a.jobc_prepared_date,'DD/MM/RR') prepared_date, 
                        f.employee_name checked_by, to_char(a.jobc_checked_date, 'DD/MM/RR') checked_date, 
                        g.employee_name dosimeter_insp_by, to_char(a.jobc_insp_date,'DD/MM/RR') dosimeter_insp_date, 
                        h.employee_name approved_by, to_char(a.jobc_approved_date, 'DD/MM/RR') approved_date,
                        i.employee_name verified_by, to_char(a.jobc_verified_date, 'DD/MM/RR') verified_date
                   FROM ytycustom.xx_yty_incoming_outgoing_inspection_tbl a,
                        apps.xxyty_cust_gth_v c,
                        ytycustom.gth_customer_brand_master d,
                        production.employee_master e,
                        production.employee_master f,
                        production.employee_master g,
                        production.employee_master h,
                        production.employee_master i
                  WHERE a.customer = c.customer_id
                    AND a.brand = d.brand_id
                    AND a.jobc_prepared_by = e.emp_id(+)
                    AND a.jobc_checked_by = f.emp_id(+)
                    AND a.jobc_insp_by = g.emp_id(+)
                    AND a.jobc_approved_by = h.emp_id(+)
                    AND a.jobc_verified_by = i.emp_id(+)
                    AND a.id = :insp_id";
        
        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':insp_id', $data->docid);
        $r = oci_execute($sqlarr);
        if (!$r) {
            $e = oci_error($sqlarr);
            goto finalStep;
        }
        oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);

        //Generate HTML
        $htmlStr = "<style>
                        @page { size: auto; size: A4 portrait; margin:25px 15px 20px 15px; }
                        body { font-family: Helvetica; }
                        .wtcol { display:inline-block; border-bottom:1px solid; width:75px; height:20px; text-align:center; vertical-align:bottom; }
                    </style>
                    <div id='printArea' style='padding:15px;'>
                        <table border='0' cellspacing='0' cellpadding='0' width='100%' style='font-size:11px;'>
                        <tr>
                            <td style='width:50%; vertical-align:top !important;'>
                                <h2 style='font-size:1rem; margin-bottom:0; margin-top:0;'>JOB CARD</h2>
                                <div style='margin-bottom:0.5rem; font-size:8px;'>
                                    Document No.: QP-06-JC<br />
                                    Revision No. 4
                                </div>
                            </td>

                            <td style='width:50%; text-align:right; vertical-align:top !important;'>
                                <img src='".$logo."' width='160' height='40' />
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellspacing='0' cellpadding='0' width='100%' style='margin-bottom:5px;'>
                                <tr>
                                    <td style='width: 140px; line-height:1.2rem;'><b>IRRADIATION LOT NO</b></td>
                                    <td style='width:10px; line-height:1.2rem;'>:</td>
                                    <td style='line-height:1.2rem;'>".$rows_main[0]["IRRD"]."</td>
                                </tr>
                                <tr>
                                    <td style='line-height:1.2rem;'><b>SERIAL NO</b></td>
                                    <td style='width:10px; line-height:1.2rem;'>:</td>
                                    <td style='line-height:1.2rem;'>".$rows_main[0]["SERIAL_NO"]."</td>
                                </tr>
                                <tr>
                                    <td style='line-height:1.2rem;'><b>PRODUCT TYPE</b></td>
                                    <td style='width:10px; line-height:1.2rem;'>:</td>
                                    <td style='line-height:1.2rem;'>".$rows_main[0]["BRAND"]."</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style='border:1px solid; vertical-align:top !important;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px; font-size:10px;'>
                                <tr>
                                    <td style='width:135px;'><b>Customer</b></td>
                                    <td style='width:5px;'> : </td>
                                    <td>".$rows_main[0]["CUSTOMER"]."</td>
                                </tr>
                                <tr>
                                    <td><b>Customer Order Reference</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["CUST_ORDER_NO"]."</td>
                                </tr>
                                <tr>
                                    <td><b>No of cartons</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["TOTAL_CTN"]."</td>
                                </tr>
                                <tr>
                                    <td><b>Carton Dimension</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["CARTON_W"]." cm x ".$rows_main[0]["CARTON_L"]." cm x ".$rows_main[0]["CARTON_H"]." cm</td>
                                </tr>
                                <tr>
                                    <td><b>Gamma Indicator Batch No.</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["GAMMA_BATCH_NO"]."</td>
                                </tr>
                                <tr>
                                    <td><b>Blank Label Batch No.</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["BLANK_BATCH_NO"]."</td>
                                </tr>
                                </table>
                            </td>
                            
                            <td style='border:1px solid; vertical-align:top !important;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px; font-size:10px;'>
                                <tr>
                                    <td style='width:135px;'><b>Product Validation Code</b></td>
                                    <td style='width:5px;'> : </td>
                                    <td>".$rows_main[0]["PRODUCT_VALID_CODE"]."</td>
                                </tr>
                                <tr>
                                    <td><b>Loading Pattern</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["LOADING_PATTERN"]." carton/Tote</td>
                                </tr>
                                <tr>
                                    <td><b>Dose Required</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["DOSE_REQUIRED"]." kGy</td>
                                </tr>
                                <tr>
                                    <td><b>Maximum Acceptable Dose</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["MAXIMUM_ACC_DOSE"]." kGy</td>
                                </tr>
                                <tr>
                                    <td><b>Minimum Acceptable Dose</b></td>
                                    <td> : </td>
                                    <td>".$rows_main[0]["MINIMUM_ACC_DOSE"]." kGy</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2' style='font-weight:bold; padding-top: 10px;'>CARTON WEIGHT</td>
                        </tr>
                        <tr>
                            <td colspan='2' style='border:1px solid;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px;'>
                                <tr>
                                    <td style='width:20%'>1. <div class='wtcol'>".$rows_main[0]["CARTON_W1"]."</div> gm</td>
                                    <td style='width:20%'>2. <div class='wtcol'>".$rows_main[0]["CARTON_W2"]."</div> gm</td>
                                    <td style='width:20%'>3. <div class='wtcol'>".$rows_main[0]["CARTON_W3"]."</div> gm</td>
                                    <td style='width:20%'>4. <div class='wtcol'>".$rows_main[0]["CARTON_W4"]."</div> gm</td>
                                    <td style='width:20%'>5. <div class='wtcol'>".$rows_main[0]["CARTON_W5"]."</div> gm</td>
                                </tr>
                                <tr>
                                    <td colspan='5'><div style='height:5px;'>&nbsp;</div></td>
                                </tr>
                                <tr>
                                    <td colspan='2'>Total Wt <div class='wtcol'>".$rows_main[0]["TOTAL_WEIGHT"]."</div> gm</td>
                                    <td></td>
                                    <td colspan='2'>Average Wt <div class='wtcol'>".$rows_main[0]["AVG_WEIGHT"]."</div> gm</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2' style='font-weight:bold; padding-top: 10px;'>TOTAL PACKAGING DENSITY</td>
                        </tr>
                        <tr>
                            <td colspan='2' style='border:1px solid;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px;'>
                                <tr>
                                    <td style='width:140px;'>Carton Density (High) </td>
                                    <td style='width:20px;'> : </td>
                                    <td><div class='wtcol'>".$rows_main[0]["CARTON_DENSITY"]."</div> g/cc</td>
                                </tr>
                                <tr>
                                    <td colspan='3'>&nbsp;</td>
                                </tr>
                                <tr>
                                    <td><b>Packaging Density</b></td>
                                    <td style='width:20px;'> = </td>
                                    <td><div style='width:195px; text-align:center;'><span style='border-bottom:1px solid;'> carton density x width of product in tote </span> <br /> 61</div></td>
                                </tr>
                                <tr>
                                    <td></td>
                                    <td style='width:20px;'> = </td>
                                    <td><div class='wtcol'>".$rows_main[0]["TOTE_PACK_DENSITY"]."</div> g/cc</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellspacing='0' cellpadding='0' width='100%'>
                                <tr>
                                    <td style='width:30%; border:1px solid;'></td>
                                    <td style='width:40%; border:1px solid; text-align:center; padding:5px;'><b>PROCESS COMPLETION VERIFICATION</b></td>
                                    <td style='width:30%; border:1px solid;'></td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style='border:1px solid;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px;'>
                                <tr>
                                    <td style='width:80px;'>Prepared by: </td>
                                    <td>
                                        <div style='text-align:right; margin-right:10px;'>
                                            <span style='border-bottom:1px solid;'>".$rows_main[0]["PREPARED_BY"]."</span><br />
                                            ".$rows_main[0]["PREPARED_DATE"]."
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan='2'>&nbsp;</td>
                                </tr>
                                <tr>
                                    <td>Checked by: </td>
                                    <td>
                                        <div style='text-align:right; margin-right:10px;'>
                                            <span style='border-bottom:1px solid;'>".$rows_main[0]["CHECKED_BY"]."</span><br />
                                            ".$rows_main[0]["CHECKED_DATE"]."
                                        </div>
                                    </td>
                                </tr>
                                </table>
                            </td>

                            <td style='border:1px solid;'>
                                <div style='text-align:right; margin-right:10px; margin-bottom:10px;'>
                                    <span style='border-bottom:1px solid;'>".$rows_main[0]["VERIFIED_BY"]."</span><br />
                                    ".$rows_main[0]["VERIFIED_DATE"]."
                                </div>

                                <div style='text-align:right; margin:5px;'>
                                    Operation Manager / Exec / Supv<br />
                                    Name and Date
                                </div>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellspacing='0' cellpadding='0' width='100%' style='margin:10px 0;'>
                                <tr>
                                    <td>
                                        <div style='width:30px; height: 20px; border:1px solid; display:inline-block;'>
                                            ".( !empty($rows_main[0]["DOSE_MAPPING"]) && $rows_main[0]["DOSE_MAPPING"] == "Y" ? "<div style='background-color:#000; padding:5px; display:block;'>&nbsp;</div>" : "&nbsp;" )."
                                        </div>
                                    </td>
                                    <td><b>DOSE MAPPING</b></td>

                                    <td>
                                        <div style='width:30px; height: 20px; border:1px solid; display:inline-block;'>
                                            ".( !empty($rows_main[0]["PROD_PACK_EVAL"]) && $rows_main[0]["PROD_PACK_EVAL"] == "Y" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                        </div> 
                                    </td>
                                    <td><b>PRODUCT & PACKAGING EVALUATION</b><i>(Validation and marketing sample)</i></td>
                                    <td></td>
                                </tr>
                                <tr>
                                    <td colspan='5'><div style='height:5px; display:block;'></div></td>
                                </tr>
                                <tr>
                                    <td>
                                        <div style='width:30px; height: 20px; border:1px solid; display:inline-block;'>
                                            ".( !empty($rows_main[0]["ROUTINE_IRRD"]) && $rows_main[0]["ROUTINE_IRRD"] == "Y" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                        </div> 
                                    </td>
                                    <td><b>ROUTINE IRRADIATION</b></td>

                                    <td>
                                        <div style='width:30px; height: 20px; border:1px solid; display:inline-block;'>
                                            ".( !empty($rows_main[0]["DOSE_VERIFICATION"]) && $rows_main[0]["DOSE_VERIFICATION"] == "Y" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                        </div> 
                                    </td>
                                    <td><b>DOSE SETTING DETERMINATION AND DOSE AUDIT</b><i>(Dose verification)</i></td>
                                    <td style='font-size:10px; vertical-align:bottom;'>*pick one</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2' style='border:1px solid;'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px;'>
                                <tr>
                                    <td style='font-size:12px; text-decoration:underline; text-align:center;'><b>Dose Reading</b></td>
                                </tr>
                                <tr>
                                    <td>
                                        <table border='0' cellspacing='0' cellpadding='0' width='100%'>
                                        <tr>
                                            <td style='width:33%;'>
                                                Minimum Dose Reading: ".$rows_main[0]["MIN_DOSE_READ"]." kGy
                                            </td>

                                            <td style='width:2%;'>&nbsp;</td>
                                            <td style='width:30%;'>
                                                <table border='0' cellspacing='0' cellpadding='0'>
                                                <tr>
                                                    <td><div style='text-align:right; padding-right:5px;'>ACCEPTABLE</div></td>
                                                    <td style='border:1px solid; width:30px; height:20px;'>
                                                        ".( !empty($rows_main[0]["MIN_DOSE_STATUS"]) && $rows_main[0]["MIN_DOSE_STATUS"] == "A" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                                    </td>
                                                    <td style='border:1px solid; width:30px; height:20px;'>
                                                        ".( !empty($rows_main[0]["MIN_DOSE_STATUS"]) && $rows_main[0]["MIN_DOSE_STATUS"] == "R" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                                    </td>
                                                    <td><div style='text-align:left; padding-left:5px;'>REJECTABLE</div></td>
                                                </tr>
                                                </table>
                                            </td>
                                            <td style='width:2%;'>&nbsp;</td>

                                            <td rowspan='2' style='width:33%;'>
                                                <div style='text-align:right; padding-right:10px;'>
                                                    Dosimeter Inspected By:<br />
                                                    <div style='margin-top:10px;'>
                                                        <span style='border-bottom:1px solid;'>".$rows_main[0]["DOSIMETER_INSP_BY"]."</span><br />
                                                        ".$rows_main[0]["DOSIMETER_INSP_DATE"]."
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td style='width:33%;'>
                                                Maximum Dose Reading: ".$rows_main[0]["MAX_DOSE_READ"]." kGy
                                            </td>

                                            <td style='width:2%;'>&nbsp;</td>
                                            <td style='width:30%;'>
                                                <table border='0' cellspacing='0' cellpadding='0'>
                                                <tr>
                                                    <td><div style='text-align:right; padding-right:5px;'>ACCEPTABLE</div></td>
                                                    <td style='border:1px solid; width:30px; height:20px;'>
                                                        ".( !empty($rows_main[0]["MAX_DOSE_STATUS"]) && $rows_main[0]["MAX_DOSE_STATUS"] == "A" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                                    </td>
                                                    <td style='border:1px solid; width:30px; height:20px;'>
                                                        ".( !empty($rows_main[0]["MAX_DOSE_STATUS"]) && $rows_main[0]["MAX_DOSE_STATUS"] == "R" ? "<div style='background-color:#000; width:20px; height:10px; margin:5px;'>&nbsp;</div>" : "&nbsp;" )."
                                                    </td>
                                                    <td><div style='text-align:left; padding-left:5px;'>REJECTABLE</div></td>
                                                </tr>
                                                </table>
                                            </td>
                                            <td style='width:2%;'>&nbsp;</td>
                                        </tr>
                                        </table>
                                    </td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellspacing='0' cellpadding='0' width='100%'>
                                <tr>
                                    <td style='width:30%; border:1px solid;'></td>
                                    <td style='width:40%; border:1px solid; text-align:center; padding:5px;'><b>APPROVAL FOR RELEASE</b></td>
                                    <td style='width:30%; border:1px solid;'></td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2' style='border:1px solid; height:100px; vertical-align:bottom; padding:5px;'>
                                <div style='margin-bottom:15px;'>
                                    <span style='border-bottom:1px solid;'>".$rows_main[0]["APPROVED_BY"]."</span><br />
                                    ".$rows_main[0]["APPROVED_DATE"]."
                                </div>

                                QA Manager / QA Deputy Manager / QA Exec<br />
                                Name and Date
                            </td>
                        </tr>
                        </table>
                        <div style='font-size:8px; margin-top:5px;'>*This is a system-generated document. No signature is required.</div>
                    </div>";
               
        $dompdf = new Dompdf();
        $dompdf->loadHtml($htmlStr);
        $dompdf->setPaper("A4");
        ob_clean();
        $dompdf->render();
        $b64Doc = base64_encode($dompdf->output());
    }
    
finalStep:
    print json_encode($b64Doc);
?>