<?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)) {
        //Main
        $sql = " SELECT a.id, b.customer_name, b.address customer_address, 
                        c.customer_name destination_name, c.address destination_address, 
                        a.container_no, a.driver_name, a.nric, d.employee_name authorized_by, 
                        to_char(a.authorized_date, 'DD/MM/RR') authorized_date, 
                        NVL(remarks,'COMPLETE') remarks 
                   FROM ytycustom.xx_yty_incoming_outgoing_inspection_ship_hd a, 
                        apps.xxyty_cust_gth_v2 b, 
                        apps.xxyty_cust_gth_v3 c,
                        production.employee_master d
                  WHERE a.customer = b.customer_id
                    AND a.destination = c.customer_id
                    AND a.authorized_by = d.emp_id
                    AND a.id = :ship_id";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':ship_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 = " SELECT a.inspection_id, b.customer_name, regexp_substr(a.ref_no, '[^*]*') ref_no, 
                        a.brand, a.irrd, a.serial_no, 
                        SUM(a.quantity_out) quantity_out, SUM(a.damage_data) damage_data, 
                        a.sticker_gng, to_char(c.date_received,'DD/MM/RR') date_received,
                        to_char(d.date_out,'DD/MM/RR') date_out, c.total_ctn as total_recv
                   FROM ytycustom.xx_yty_incoming_outgoing_inspection_detail_stl_part a,
                        apps.xxyty_cust_gth_v2 b,
                        ytycustom.xx_yty_incoming_outgoing_inspection_tbl c,
                        ytycustom.xx_yty_incoming_outgoing_inspection_ship_hd d
                  WHERE a.customer = b.customer_id
                    AND a.inspection_id = c.id
                    AND a.ship_id = d.id
                    AND a.ship_id = :ship_id
               GROUP BY a.inspection_id, regexp_substr(a.ref_no, '[^*]*'), a.brand, a.irrd, a.serial_no, 
                        a.sticker_gng, b.customer_name,
                        c.date_received, d.date_out, c.total_ctn
               ORDER BY a.irrd";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':ship_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);

        //IRRD
        $insp_id = implode(', ', array_map(function ($entry) { return $entry['INSPECTION_ID']; }, $rows_detail));

        $sql = "SELECT RTRIM(XMLAGG(XMLELEMENT(e, b.irrd, ', ').EXTRACT('//text()')), ', ') irrd,
                       RTRIM(XMLAGG(XMLELEMENT(e, to_char(min(a.loading_date),'DD/MM/RR'), ', ').EXTRACT('//text()')), ', ') irrd_date
                  FROM ytycustom.xx_yty_incoming_outgoing_inspection_op a,
                       ytycustom.xx_yty_incoming_outgoing_inspection_tbl b
                 WHERE a.inspection_id = b.id
                   AND a.inspection_id IN (".$insp_id.")
              GROUP BY b.irrd";

        $sqlarr = oci_parse($dbcon , $sql);
        $r = oci_execute($sqlarr);
        if (!$r) {
            $e = oci_error($sqlarr);
            goto finalStep;
        }
        oci_fetch_all($sqlarr, $rows_irrd, 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;'>Grand Ten Holdings Sdn Bhd</h2>
                                <div style='margin-bottom:0.5rem; font-size:8px;'>Company No. 707876-T</div>
                                <div style='font-size:10px; line-height:14px;'>
                                    Plot PT5754, Jalan 2,<br />
                                    Kawasan Perusahaan Bandar Baru Salak Tinggi,<br />
                                    43900 Sepang,<br />
                                    Selangor, Malaysia
                                </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'><div style='height:7px;'>&nbsp;</div></td>
                        </tr>
                        <tr>
                            <td colspan='2' style='text-align:center;'>
                                <h2 style='font-size:1rem; margin-bottom:0; margin-top:0;'>SHIPPING ORDER</h2>
                                <div style='margin-bottom:0.5rem; font-size:8px; line-height:11px;'>
                                    Document No. QP-12-SO<br />
                                    Revision No : 1
                                </div>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'><div style='height:7px;'>&nbsp;</div></td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellspacing='0' cellpadding='3' width='100%'>
                                <tr>
                                    <td style='width:100px; vertical-align:top;'>Delivered To :</td>

                                    <td style='width:350px;'>
                                        <div style='font-weight:bold; line-height:14px;'>".$rows_main[0]["DESTINATION_NAME"]."</div>
                                        <div style='line-height:14px;'>".$rows_main[0]["DESTINATION_ADDRESS"]."</div>
                                    </td>

                                    <td style='vertical-align:top;'>
                                        <table border='0' cellpadding='0' cellspacing='0' style='margin-left:25px;'>
                                        <tr>
                                            <td align='right' style='width:120px; vertical-align:top;'>Irradiation Lot No &nbsp; : &nbsp;</td>
                                            <td style='width:120px; vertical-align:top;'>".$rows_irrd[0]["IRRD"]."</td>
                                        </tr>
                                        <tr>
                                            <td align='right'>Date &nbsp; : &nbsp;</td>
                                            <td>".$rows_detail[0]["DATE_OUT"]."</td>
                                        </tr>
                                        </table>
                                    </td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>
                                <table border='0' cellpadding='5' cellspacing='0' width='100%' style='margin-top:0.8rem;'>
                                <tr>
                                    <th style='border:1px solid;'>No.</th>
                                    <th style='border:1px solid;'>Description of Product</th>
                                    <th style='border:1px solid;'>Quantity Delivered</th>
                                </tr>";

        $grandtotal = 0;
        foreach ($rows_detail as $det) {
            $htmlStr .=         "<tr>
                                    <td style='border:1px solid;'></td>
                                    <td style='border:1px solid;'>
                                        <table border='0' cellpadding='2' cellspacing='0' width='100%' style='margin:5px 5px 10px 5px;'>
                                        <tr>
                                            <td style='width:150px;'><b>COMPANY</b></td>
                                            <td>".$det["CUSTOMER_NAME"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>IRRADIATION NO</b></td>
                                            <td>".$det["IRRD"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>MODEL</b></td>
                                            <td>".$det["BRAND"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>PWO/DO</b></td>
                                            <td>".$det["REF_NO"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>QTY</b></td>
                                            <td>".$det["TOTAL_RECV"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>DATE REC</b></td>
                                            <td>".$det["DATE_RECEIVED"]."</td>
                                        </tr>
                                        <tr>
                                            <td><b>DATE DELIVER</b></td>
                                            <td>".$det["DATE_OUT"]."</td>
                                        </tr>
                                        </table>
                                    </td>
                                    <td style='border:1px solid;'>".$det["QUANTITY_OUT"]." CTNS</td>
                                </tr>";

            $grandtotal += $det["QUANTITY_OUT"];
        }

        $htmlStr .=            "<tr>
                                    <td colspan='2' style='font-weight:700; text-align:right'>TOTAL</td>
                                    <td style='border:1px solid; font-weight:700;'>".$grandtotal." CTNS</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2'>&nbsp;</td>
                        </tr>
                        <tr>
                            <td colspan='2' style='border:1px solid; vertical-align:top;'>
                                <table border='0' cellspacing='0' cellpadding='5' width='100%' style='margin-top:0.5rem;'>
                                <tr>
                                    <td colspan='2' style='font-weight:700; text-align:center;'>REMARKS</td>
                                </tr>
                                <tr>
                                    <td width='50%'><div style='height:50px; padding-top:25px; text-align:center; display: block; font-weight:700;'>".$rows_main[0]["REMARKS"]."</div></td>
                                    <td width='50%'></td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td colspan='2' style='vertical-align:top !important;'>
                                <table border='0' cellspacing='0' cellpadding='5' width='100%' style='margin-top:1rem;'>
                                <tr>
                                    <td width='50%' style='border:1px solid;'>
                                        <div>AUTHORIZATION OF SHIPMENT</div>
                                        <div style='margin-bottom:80px;'>Operation Manager/Designate:</div>


                                        <table border='0' cellspacing='0' width='100%' style='margin-bottom:10px;'>
                                        <tr>
                                            <td>
                                                <div>Date :</div>
                                                <div>Time :</div>
                                            </td>
                                            
                                            <td>
                                                <div style='text-align:right; margin-right:10px;'>
                                                    <span style='border-bottom:1px solid;'>".$rows_main[0]["AUTHORIZED_BY"]."</span><br />
                                                    ".$rows_main[0]["AUTHORIZED_DATE"]."
                                                </div>
                                            </td>
                                        </tr>
                                        </table>
                                    </td>
                                    
                                    <td width='50%' style='border:1px solid; vertical-align:top !important;'>
                                        <div>I hereby confirmed that all the above mentioned products are received in good conditions.</div>
                                        <table border='0' cellspacing='0' cellpadding='5' width='100%' style='margin-top:10px;'>
                                        <tr>
                                            <td style='vertical-align:top !important; width:100px;'>Vehicle No</td>
                                            <td style='vertical-align:top !important;'>&nbsp; : ".$rows_main[0]["CONTAINER_NO"]."</td>
                                        </tr>
                                        <tr>
                                            <td style='vertical-align:top !important;'>Name</td>
                                            <td style='vertical-align:top !important;'>&nbsp; : ".$rows_main[0]["DRIVER_NAME"]."</td>
                                        </tr>
                                        <tr>
                                            <td style='vertical-align:top !important;'>NRIC</td>
                                            <td style='vertical-align:top !important;'>&nbsp; : ".$rows_main[0]["NRIC"]."</td>
                                        </tr>
                                        <tr>
                                            <td style='vertical-align:top !important;'>Signature</td>
                                            <td style='vertical-align:top !important; height:30px;'>&nbsp; : </td>
                                        </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td style='font-size:10px;'>*This is a system-generated document. No signature is required.</td>
                                    <td align='right' style='font-size:10px;'>*Customer / File</td>
                                </tr>
                                </table>
                            </td>
                        </tr>
                        </table>
                    </div>";
               
        $dompdf = new Dompdf();
        $dompdf->loadHtml($htmlStr);
        $dompdf->setPaper("A4");
        ob_clean();
        $dompdf->render();
        $b64Doc = base64_encode($dompdf->output());
    }
    
finalStep:
    print json_encode($b64Doc);
?>