Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php class Data { public static function mainFilter($post, $params) { $form = $post->fo..
Decoded Output download
<?php
class Data { public static function mainFilter($post, $params) { $form = $post->form; $WHERE = ''; $box_order_cols = array("f.acronim", "i.nume", "r.nr", "b.nume", "tip.tip_nume", "denumire", "p.adresa", "p.year", "nume_prenume", "p.eterra_finalizat", "difference_contract", "difference_tax"); $isWhere = 0; $formCount = count($form); for ($i = 0; $i < $formCount; $i++) { $element = $form[$i]; if ($element !== '') { if ($isWhere === 1) { $WHERE .= " AND "; } else { $WHERE .= "WHERE "; } $isWhere = 1; $WHERE .= $box_order_cols[$i] . " LIKE '%" . $form[$i] . "%'"; } } $sql = "\xaSELECT
p.id AS p_id,
p.adresa, \xap.year,
p.tarif,
p.tarif_tax,\xar.nr,\xar.`data` as registru_data,
f.acronim,
i.nume as inginer_nume,\xap.eterra_finalizat,
(p.tarif - IFNULL(sc.suma_contract, 0)) AS difference_contract,
(p.tarif_tax - IFNULL(sti.suma_taxe_in, 0)) AS difference_tax,
GROUP_CONCAT(DISTINCT b.id SEPARATOR ', ') as b_id, \xaGROUP_CONCAT(DISTINCT b.nume SEPARATOR ', ') as nume, \xatip.tip_nume, GROUP_CONCAT(DISTINCT a.id SEPARATOR ', ') as a_id, \xaGROUP_CONCAT(DISTINCT a.denumire SEPARATOR ', ') AS denumire,\xaGROUP_CONCAT(DISTINCT u.nume_prenume SEPARATOR ', ') AS nume_prenume
FROM Proiecte p
LEFT JOIN Proiecte_Beneficiari pb ON p.id = pb.id_proiect \xaLEFT JOIN Beneficiari b ON pb.id_beneficiar = b.id \xaLEFT JOIN Tipuri_Lucrari tip ON p.id_tip = tip.id
LEFT JOIN Proiecte_Acte pa ON p.id = pa.id_proiect \xaLEFT JOIN Acte a ON a.id = pa.id_act
LEFT JOIN Proiecte_Responsabili pr ON p.id = pr.id_proiect
LEFT JOIN Users u ON u.id = pr.id_user \xaLEFT JOIN Registru r ON r.id = p.id_registru\xaLEFT JOIN Firme f ON f.id = p.id_firma\xaLEFT JOIN Ingineri i ON i.id = p.id_inginer
LEFT JOIN (SELECT SUM(suma) as suma_contract, id_proiect FROM `IO` WHERE scop = 2 AND io = 1 GROUP BY id_proiect) sc ON p.id = sc.id_proiect\xaLEFT JOIN (SELECT SUM(suma) as suma_taxe_in, id_proiect FROM `IO` WHERE scop = 1 AND io = 1 GROUP BY id_proiect) sti ON p.id = sti.id_proiect
LEFT JOIN (SELECT SUM(suma) as suma_taxe_out, id_proiect FROM `IO` WHERE scop = 1 AND io = 2 GROUP BY id_proiect) sto ON p.id = sto.id_proiect\xa{$WHERE}
GROUP BY p.id, sc.suma_contract, sti.suma_taxe_in, sto.suma_taxe_out, sc.id_proiect, sti.id_proiect, sto.id_proiect\xaORDER BY p.year DESC, nume ASC;
"; try { $result = $params->conn->query($sql); $list = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $mylist = array(); array_push($mylist, $row["p_id"]); array_push($mylist, $row["acronim"]); array_push($mylist, $row["inginer_nume"]); if ($row["nr"]) { $date = date("d.m.Y", substr(intval($row["registru_data"]), 0, 10)); $afisaj = $row["nr"] . "<br>" . $date; } else { $afisaj = ''; } array_push($mylist, $afisaj); array_push($mylist, $row["nume"]); array_push($mylist, $row["tip_nume"]); array_push($mylist, $row["denumire"]); array_push($mylist, $row["adresa"]); array_push($mylist, $row["year"]); array_push($mylist, $row["nume_prenume"]); if ($row["eterra_finalizat"] === "1") { $afisaj = "DA"; } else { $afisaj = "NU"; } array_push($mylist, $afisaj); if (findRole(Roles::$contabilitate, $params->user_roles) !== false || findRole(Roles::$admin, $user_roles) !== false) { if ($row["difference_contract"] === "0" && $row["tarif"]) { $afisaj = "Achitat"; } else { if (!$row["tarif"]) { $afisaj = "!"; } else { $afisaj = $row["difference_contract"]; } } array_push($mylist, $afisaj); } if ($row["difference_tax"] === "0" && $row["tarif_tax"]) { $afisaj = "Achitat"; } else { if (!$row["tarif_tax"]) { $afisaj = "!"; } else { $afisaj = $row["difference_tax"]; } } array_push($mylist, $afisaj); $list[] = $mylist; } } echo json_encode($list, 1); } catch (Exception $e) { } } } ?>Did this file decode correctly?
Original Code
<?php
class Data { public static function mainFilter($post, $params) { $form = $post->form; $WHERE = ''; $box_order_cols = array("\x66\56\141\x63\162\157\156\151\155", "\151\56\156\x75\155\145", "\162\x2e\156\x72", "\142\56\x6e\165\x6d\x65", "\164\151\x70\56\164\x69\x70\x5f\156\165\155\145", "\144\145\156\x75\x6d\x69\x72\x65", "\160\56\x61\x64\x72\145\163\x61", "\x70\56\x79\x65\x61\162", "\x6e\x75\x6d\x65\x5f\x70\162\x65\156\165\155\x65", "\x70\x2e\x65\x74\x65\x72\162\x61\137\x66\151\156\141\x6c\151\172\x61\x74", "\x64\151\146\x66\x65\162\145\x6e\143\x65\137\x63\157\156\164\x72\x61\x63\x74", "\144\151\146\146\145\x72\x65\x6e\143\145\137\x74\x61\x78"); $isWhere = 0; $formCount = count($form); for ($i = 0; $i < $formCount; $i++) { $element = $form[$i]; if ($element !== '') { if ($isWhere === 1) { $WHERE .= "\x20\101\x4e\x44\x20"; } else { $WHERE .= "\127\x48\x45\122\105\40"; } $isWhere = 1; $WHERE .= $box_order_cols[$i] . "\x20\x4c\111\113\x45\x20\47\45" . $form[$i] . "\x25\47"; } } $sql = "\xa\123\x45\114\105\103\124\x20\12\x70\x2e\151\x64\x20\x41\123\x20\x70\137\151\144\x2c\x20\12\x70\x2e\x61\144\x72\145\x73\x61\54\x20\xa\160\x2e\171\145\141\x72\x2c\x20\12\160\x2e\x74\141\162\x69\x66\x2c\12\x70\x2e\x74\141\x72\151\x66\137\164\141\170\x2c\xa\162\x2e\x6e\162\x2c\xa\x72\x2e\140\144\141\x74\x61\140\x20\141\x73\40\x72\145\147\x69\163\x74\x72\165\137\144\141\x74\x61\x2c\12\x66\x2e\141\143\162\x6f\156\x69\155\54\12\x69\x2e\x6e\165\x6d\x65\40\141\163\x20\151\156\147\x69\x6e\x65\x72\137\156\165\x6d\x65\54\xa\x70\x2e\x65\164\145\162\162\x61\x5f\x66\x69\156\141\x6c\151\x7a\141\x74\x2c\12\50\160\56\x74\141\162\151\x66\x20\55\40\x49\x46\116\x55\x4c\x4c\50\x73\143\x2e\x73\x75\155\x61\x5f\x63\157\156\x74\x72\141\x63\x74\54\40\x30\x29\51\40\x41\x53\x20\144\151\146\146\145\x72\x65\156\x63\145\137\143\157\x6e\x74\x72\x61\x63\164\x2c\12\50\x70\x2e\x74\141\x72\151\146\137\x74\141\170\40\55\x20\x49\106\x4e\x55\114\114\x28\163\x74\151\56\x73\165\x6d\141\x5f\164\141\x78\145\x5f\x69\156\54\40\60\x29\51\x20\101\x53\x20\x64\x69\146\x66\145\162\145\156\143\145\x5f\x74\x61\x78\x2c\12\107\x52\x4f\125\x50\x5f\103\117\x4e\103\x41\124\50\x44\111\123\124\x49\116\103\x54\40\x62\x2e\151\x64\x20\x53\105\120\101\x52\x41\124\117\x52\x20\47\54\x20\x27\x29\x20\x61\x73\x20\x62\137\151\144\54\x20\xa\107\x52\x4f\x55\x50\137\103\117\116\x43\101\124\x28\x44\x49\x53\x54\111\x4e\103\x54\x20\x62\56\156\165\155\x65\40\123\x45\120\101\x52\101\124\x4f\122\40\47\54\x20\x27\51\40\x61\163\40\156\x75\x6d\x65\x2c\x20\xa\x74\x69\160\x2e\164\x69\x70\x5f\156\x75\155\x65\54\x20\107\x52\x4f\x55\120\137\103\117\x4e\103\101\x54\50\104\x49\x53\124\111\116\103\124\x20\x61\x2e\151\x64\40\123\x45\120\101\x52\x41\x54\x4f\x52\x20\47\x2c\x20\47\x29\40\x61\163\x20\x61\137\151\x64\54\x20\xa\107\122\117\x55\x50\x5f\103\117\116\103\x41\124\50\x44\111\x53\x54\x49\116\103\124\40\141\56\x64\145\156\165\155\x69\162\x65\40\x53\105\120\x41\x52\101\124\x4f\122\x20\x27\54\40\47\51\x20\x41\x53\40\144\145\156\x75\x6d\x69\162\145\x2c\xa\x47\x52\x4f\x55\120\x5f\x43\117\x4e\x43\101\124\x28\x44\x49\x53\x54\x49\x4e\103\124\x20\165\x2e\x6e\165\x6d\x65\137\160\162\x65\156\165\x6d\145\40\40\x53\105\x50\101\122\101\124\x4f\122\x20\47\x2c\40\47\x29\40\x41\123\x20\x6e\x75\155\x65\137\160\x72\145\156\x75\x6d\145\x20\12\106\122\x4f\x4d\x20\120\162\x6f\x69\x65\x63\x74\x65\40\160\40\12\12\x4c\x45\x46\124\x20\112\117\x49\x4e\x20\120\162\x6f\x69\145\143\164\145\137\102\x65\x6e\145\146\151\x63\x69\141\162\x69\40\x70\x62\40\x4f\116\x20\160\56\151\x64\40\75\40\x70\142\x2e\151\144\x5f\x70\x72\x6f\x69\145\143\164\40\xa\x4c\x45\x46\124\40\112\117\x49\116\40\x42\x65\x6e\145\146\151\143\151\x61\x72\151\x20\142\40\117\116\40\160\142\x2e\151\144\x5f\x62\x65\x6e\145\x66\151\x63\x69\141\162\x20\75\x20\x62\56\x69\x64\40\xa\114\105\106\x54\x20\x4a\x4f\x49\116\x20\124\x69\160\165\162\x69\137\114\165\x63\x72\141\162\x69\40\x74\151\160\x20\x4f\x4e\x20\x70\x2e\x69\144\137\x74\151\x70\x20\75\40\x74\x69\x70\56\x69\x64\x20\12\114\105\106\x54\x20\x4a\x4f\111\116\40\120\x72\x6f\151\x65\x63\x74\145\137\101\143\164\145\40\160\x61\x20\117\116\x20\x70\x2e\x69\x64\x20\x3d\40\160\x61\x2e\151\x64\137\160\162\157\151\x65\x63\164\40\xa\x4c\x45\x46\x54\40\x4a\x4f\x49\116\40\x41\x63\164\145\40\x61\x20\117\116\x20\141\56\x69\144\x20\75\x20\160\141\56\x69\x64\x5f\x61\x63\164\40\12\114\x45\x46\x54\x20\x4a\x4f\111\116\x20\120\x72\x6f\x69\x65\x63\164\x65\x5f\x52\x65\163\160\x6f\156\163\x61\142\151\x6c\x69\x20\x70\x72\x20\117\x4e\40\160\56\151\x64\x20\x3d\40\160\x72\56\151\x64\x5f\160\162\x6f\x69\x65\x63\164\40\12\x4c\x45\106\124\40\x4a\117\x49\x4e\x20\125\x73\145\162\163\40\165\x20\117\x4e\x20\165\x2e\151\144\40\x3d\40\x70\x72\x2e\151\144\137\165\163\145\162\x20\xa\114\x45\x46\124\x20\x4a\117\x49\116\40\122\145\x67\x69\163\164\162\x75\40\162\40\x4f\116\x20\162\56\151\144\40\75\x20\x70\x2e\x69\x64\137\162\x65\147\x69\163\164\162\165\xa\114\105\x46\124\x20\x4a\117\111\x4e\x20\x46\x69\162\155\x65\40\x66\x20\x4f\x4e\40\x66\x2e\151\x64\x20\x3d\40\x70\x2e\x69\144\137\146\151\162\x6d\x61\xa\x4c\105\x46\x54\40\x4a\117\111\116\x20\111\156\147\x69\156\x65\162\x69\40\x69\40\x4f\x4e\x20\151\x2e\151\144\x20\75\40\160\56\151\x64\x5f\x69\x6e\x67\x69\156\145\162\12\114\x45\106\x54\x20\x4a\x4f\111\116\x20\x28\x53\x45\114\x45\x43\x54\x20\x53\x55\x4d\50\x73\x75\155\141\51\x20\141\x73\40\163\x75\155\141\x5f\x63\157\156\x74\162\x61\143\164\x2c\x20\x69\144\x5f\160\x72\157\x69\145\143\164\x20\106\122\x4f\x4d\x20\140\111\117\x60\x20\x57\110\x45\122\105\40\163\143\157\160\40\75\40\x32\x20\101\116\104\x20\x69\157\x20\x3d\40\x31\40\x47\x52\117\125\120\x20\x42\131\40\151\x64\x5f\160\162\x6f\x69\145\143\164\51\x20\x73\143\x20\x4f\x4e\40\160\56\x69\144\40\75\40\163\143\x2e\x69\x64\137\x70\162\x6f\x69\x65\x63\x74\xa\x4c\105\106\124\40\x4a\117\111\x4e\x20\50\x53\105\x4c\105\103\x54\x20\123\x55\x4d\50\163\x75\x6d\141\x29\x20\x61\163\x20\163\165\155\x61\x5f\x74\141\x78\145\137\151\x6e\x2c\40\x69\x64\x5f\160\x72\x6f\x69\145\x63\164\x20\106\122\x4f\x4d\40\x60\111\x4f\140\40\x57\x48\105\122\105\40\163\143\157\x70\40\75\40\x31\x20\x41\x4e\104\40\x69\x6f\40\x3d\40\61\40\x47\x52\x4f\125\x50\x20\x42\131\40\x69\144\x5f\x70\162\157\151\x65\x63\x74\51\x20\x73\x74\x69\x20\x4f\x4e\x20\x70\x2e\x69\144\x20\75\40\x73\164\151\x2e\151\x64\137\x70\x72\x6f\x69\x65\x63\x74\12\114\x45\x46\124\x20\x4a\117\x49\116\x20\x28\123\105\114\105\103\x54\x20\x53\x55\x4d\x28\x73\165\155\141\x29\40\x61\163\x20\163\165\x6d\x61\137\164\x61\x78\x65\x5f\x6f\x75\164\54\40\151\x64\x5f\x70\x72\157\x69\145\x63\164\40\x46\x52\117\x4d\40\140\x49\117\140\x20\x57\x48\x45\x52\x45\x20\163\x63\157\x70\x20\x3d\40\61\40\101\116\x44\x20\x69\x6f\x20\75\40\62\x20\x47\x52\x4f\x55\120\x20\102\131\40\151\144\x5f\160\162\x6f\151\145\143\164\51\40\x73\164\157\40\x4f\x4e\40\x70\x2e\x69\x64\40\75\40\163\x74\x6f\x2e\151\x64\137\160\x72\157\151\145\143\164\xa{$WHERE}\12\x47\122\x4f\125\x50\40\x42\x59\40\160\56\151\144\54\40\x73\x63\56\163\x75\155\141\x5f\143\157\x6e\x74\x72\141\x63\x74\54\x20\x73\164\151\56\x73\x75\155\141\x5f\x74\x61\x78\x65\x5f\151\x6e\54\40\x73\x74\x6f\x2e\163\165\155\141\137\x74\x61\x78\145\x5f\157\x75\164\54\40\x73\x63\56\x69\x64\x5f\x70\x72\x6f\x69\145\143\x74\x2c\x20\x73\x74\x69\x2e\151\144\137\160\162\x6f\x69\145\143\x74\x2c\40\x73\x74\157\56\151\144\x5f\160\162\x6f\x69\145\x63\x74\xa\x4f\122\x44\x45\x52\x20\x42\131\x20\x70\56\x79\x65\x61\x72\40\104\x45\123\x43\54\x20\x6e\165\155\x65\x20\x41\123\x43\x3b\12"; try { $result = $params->conn->query($sql); $list = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $mylist = array(); array_push($mylist, $row["\x70\x5f\151\144"]); array_push($mylist, $row["\x61\143\x72\157\156\151\155"]); array_push($mylist, $row["\151\156\x67\x69\156\145\x72\137\156\165\x6d\x65"]); if ($row["\156\x72"]) { $date = date("\x64\56\x6d\56\131", substr(intval($row["\x72\x65\x67\x69\x73\164\162\x75\137\144\x61\x74\x61"]), 0, 10)); $afisaj = $row["\x6e\162"] . "\x3c\142\x72\76" . $date; } else { $afisaj = ''; } array_push($mylist, $afisaj); array_push($mylist, $row["\156\x75\155\x65"]); array_push($mylist, $row["\164\x69\160\x5f\x6e\x75\x6d\x65"]); array_push($mylist, $row["\x64\x65\156\165\x6d\151\x72\145"]); array_push($mylist, $row["\141\x64\162\x65\x73\x61"]); array_push($mylist, $row["\x79\145\141\162"]); array_push($mylist, $row["\x6e\165\x6d\145\x5f\160\162\x65\x6e\x75\x6d\x65"]); if ($row["\145\164\145\x72\162\141\137\x66\151\x6e\x61\154\x69\172\141\x74"] === "\61") { $afisaj = "\x44\101"; } else { $afisaj = "\x4e\x55"; } array_push($mylist, $afisaj); if (findRole(Roles::$contabilitate, $params->user_roles) !== false || findRole(Roles::$admin, $user_roles) !== false) { if ($row["\x64\151\x66\146\x65\x72\x65\156\143\x65\137\143\x6f\x6e\x74\162\141\143\164"] === "\x30" && $row["\164\141\x72\151\146"]) { $afisaj = "\x41\143\150\151\164\x61\164"; } else { if (!$row["\x74\x61\x72\x69\x66"]) { $afisaj = "\x21"; } else { $afisaj = $row["\x64\x69\146\146\x65\x72\145\x6e\x63\145\137\x63\157\x6e\x74\162\141\143\x74"]; } } array_push($mylist, $afisaj); } if ($row["\x64\151\146\146\x65\x72\145\156\143\145\137\x74\x61\x78"] === "\x30" && $row["\164\x61\162\151\x66\137\164\x61\x78"]) { $afisaj = "\x41\143\150\151\164\x61\x74"; } else { if (!$row["\164\x61\x72\151\146\137\164\141\x78"]) { $afisaj = "\x21"; } else { $afisaj = $row["\x64\151\x66\146\145\x72\145\156\143\145\137\x74\141\x78"]; } } array_push($mylist, $afisaj); $list[] = $mylist; } } echo json_encode($list, 1); } catch (Exception $e) { } } }Function Calls
| None |
Stats
| MD5 | a94d9edff4b5bf8e82f6688385f88f6f |
| Eval Count | 0 |
| Decode Time | 73 ms |