<?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)) {
        //Header
        $sql = " SELECT a.id, a.irrd, a.serial_no, a.loading_pattern, 
                        a.dosimetry_batch_no, e.employee_name log_prepared_by, 
                        to_char(a.log_prepared_date,'DD/MM/RR') log_prepared_date, 
                        f.employee_name log_checked_by, 
                        to_char(log_checked_date, 'DD/MM/RR') log_checked_date, 
                        g.employee_name log_verified_by, 
                        to_char(log_verified_date, 'DD/MM/RR') log_verified_date
                   FROM ytycustom.xx_yty_incoming_outgoing_inspection_tbl a, 
                        production.employee_master e, 
                        production.employee_master f, 
                        production.employee_master g
                  WHERE a.log_prepared_by = e.emp_id (+)
                    AND a.log_checked_by = f.emp_id (+)
                    AND a.log_verified_by = g.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);

        //Detail
        $sql_det = "SELECT tote_no, loading_loc, to_char(loading_date, 'DD/MM/RR HH24:MI') loading_date, loading_by,
                           unloading_loc, to_char(unloading_date, 'DD/MM/RR HH24:MI') unloading_date, unloading_by,
                           remarks
                      FROM ytycustom.xx_yty_incoming_outgoing_inspection_op
                     WHERE inspection_id = :insp_id
                  ORDER BY id";

        $sqlarr = oci_parse($dbcon , $sql_det);
        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_detail, null, null, OCI_FETCHSTATEMENT_BY_ROW);

        //Generate HTML
        /*
            Document No.: QP-05-OL<br />
            Revision No. 2
        */
        $htmlStr = "<html>
                    <head>
                        <style>
                            @page { size: auto; size: A4 portrait; margin:175px 30px 170px 30px; }
                            body { font-family: Helvetica; }
                            #header{
                                position: fixed; 
                                top: -152px; 
                                left: 0px; 
                                right: 0px;
                                height: 155px;
                            }
                            #footer{
                                position: fixed;
                                left: 0px;
                                right: 0px;
                                bottom: -140px;
                                height: 140px;
                            }
                            .page:after { content: counter(page, decimal); }
                            .wtcol { display:inline-block; border-bottom:1px solid; width:75px; height:20px; text-align:center; vertical-align:bottom; }
                        </style>
                    </head>
                    <body>
                        <div id='header'>
                            <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;'>OPERATOR LOG</h2>
                                    
                                    ";
    if (!empty($rows_main[0]['LOG_PREPARED_DATE'])) {

        $logDate = DateTime::createFromFormat('d/m/y', $rows_main[0]['LOG_PREPARED_DATE']);
        $compareDate = DateTime::createFromFormat('d/m/y', '16/01/26');

        if ($logDate && $logDate >= $compareDate) {
            $htmlStr .= "<div style='margin-bottom:-0.1rem; font-size:8px;'>Document No.: QP-05-OL<br />Revision No. 3 <br/> Effective Date : 16/01/26</div>";
        } else {
            $htmlStr .= "<div style='margin-bottom:0.5rem; font-size:8px;'>Document No.: QP-05-OL<br />Revision No. 2";
        }
    } else {
        $htmlStr .= 'Document No.: QP-05-OL<br />Revision No. 2';
    }
    $htmlStr .= "
                                </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 colspan='4' style='line-height:1.2rem;'>".$rows_main[0]["IRRD"]."</td>
                                    </tr>
                                    <tr>
                                        <td style='width: 140px; line-height:1.2rem;'><b>Serial No</b></td>
                                        <td style='width:10px; line-height:1.2rem;'>:</td>
                                        <td colspan='4' style='line-height:1.2rem;'>".$rows_main[0]["SERIAL_NO"]."</td>
                                    </tr>
                                    <tr>
                                        <td style='width: 140px; line-height:1.2rem;'><b>Carton per Tote</b></td>
                                        <td style='width:10px; line-height:1.2rem;'>:</td>
                                        <td width='100%' style='line-height:1.2rem;'>".$rows_main[0]["LOADING_PATTERN"]."</td>

                                        <td style='width: 130px; line-height:1.2rem;'><b>Dosimeter Batch No</b></td>
                                        <td style='width: 10px; line-height:1.2rem;'>:</td>
                                        <td style='width: 130px; line-height:1.2rem;'>".$rows_main[0]["DOSIMETRY_BATCH_NO"]."</td>
                                    </tr>
                                    </table>
                                </td>
                            </tr>
                            </table>

                            <table border='0' cellspacing='0' cellpadding='3' width='100%' style='font-size:11px;'>
                                <tr>
                                    <th rowspan='2' style='border:1px solid; width:50px;'>TOTE NO</th>
                                    <th colspan='3' style='border:1px solid;'>LOADING</th>
                                    <th colspan='3' style='border:1px solid;'>UNLOADING</th>
                                    <th rowspan='2' style='border:1px solid;'>REMARKS</th>
                                </tr>
                                <tr>
                                    <th style='border:1px solid; width:70px;'>DOSI LOC</th>
                                    <th style='border:1px solid; width:100px;'>DATE &amp; TIME</th>
                                    <th style='border:1px solid; width:80px;'>OPERATOR</th>
                                    <th style='border:1px solid; width:70px;'>DOSI LOC</th>
                                    <th style='border:1px solid; width:100px;'>DATE &amp; TIME</th>
                                    <th style='border:1px solid; width:80px;'>OPERATOR</th>
                                </tr>
                            </table>
                        </div>

                        <div id='footer'>
                            <table border='0' cellspacing='0' cellpadding='0' width='100%' style='font-size:11px;'>
                            <tr>
                                <td colspan='2'><div style='height:10px;'>&nbsp;</div></td>
                            </tr>
                            <tr>
                                <td style='border:1px solid; width:50%;'>
                                    <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]["LOG_PREPARED_BY"]."</span><br />
                                                ".$rows_main[0]["LOG_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]["LOG_CHECKED_BY"]."</span><br />
                                                ".$rows_main[0]["LOG_CHECKED_DATE"]."
                                            </div>
                                        </td>
                                    </tr>
                                    </table>
                                </td>    

                                <td style='border:1px solid; width:50%; vertical-align:top;'>
                                    <table border='0' cellspacing='0' cellpadding='3' width='100%' style='margin:5px;'>
                                    <tr>
                                        <td colspan='2' style='text-align:center; font-weight:500; text-decoration:underline;'>OPERATION SUPV / EXEC / MANAGER VERIFICATION</td>
                                    </tr>
                                    <tr>
                                        <td colspan='2'>
                                            <div style='margin:5px;'>
                                                &nbsp;
                                            </div>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>Verified by: </td>
                                        <td>
                                            <div style='text-align:right; margin-right:10px;'>
                                                <span style='border-bottom:1px solid;'>".$rows_main[0]["LOG_VERIFIED_BY"]."</span><br />
                                                ".$rows_main[0]["LOG_VERIFIED_DATE"]."
                                            </div>
                                        </td>
                                    </tr>
                                    </table>
                                </td>    
                            </tr>
                            </table>
                            <div style='font-size:8px; margin-top:5px;'>*This is a system-generated document. No signature is required.</div>

                            <p class='page' align='center' style='font-size:10px;'>Page </p>
                        </div>

                        <table border='0' cellspacing='0' cellpadding='3' width='100%' style='font-size:11px;'>  
                                ";

        foreach ($rows_detail as $det) {
            $htmlStr .=     "<tr>
                                <td style='border:1px solid; text-align:center; width:50px;'>".$det["TOTE_NO"]."</td>
                                <td style='border:1px solid; text-align:center; width:70px;'>".(!empty($det["REMARKS"]) ? $det["LOADING_LOC"] : '')."</td>
                                <td style='border:1px solid; text-align:center; width:100px;'>".$det["LOADING_DATE"]."</td>
                                <td style='border:1px solid; text-align:center; width:80px;'>".$det["LOADING_BY"]."</td>
                                <td style='border:1px solid; text-align:center; width:70px;'>".(!empty($det["REMARKS"]) ? $det["UNLOADING_LOC"] : '')."</td>
                                <td style='border:1px solid; text-align:center; width:100px;'>".$det["UNLOADING_DATE"]."</td>
                                <td style='border:1px solid; text-align:center; width:80px;'>".$det["UNLOADING_BY"]."</td>
                                <td style='border:1px solid; text-align:center;'>".$det["REMARKS"]."</td>
                            </tr>";
        }
                                
        $htmlStr .=     "</table>
                         
                        </body>
                        </html>";
               
        $dompdf = new Dompdf();
        $dompdf->loadHtml($htmlStr);
        $dompdf->setPaper("A4");
        ob_clean();
        $dompdf->render();
        $b64Doc = base64_encode($dompdf->output());
    }
    
finalStep:
    print json_encode($b64Doc);
?>