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 /* * Your installation or use of this Upsert file is subject to the applicable ..
Decoded Output download
<?php
/*
* Your installation or use of this Upsert file is subject to the applicable terms available at:
* https://upsertconsulting.com/documents/eula-for-upsert-software/
* If you do not agree to all of the applicable terms or do not have the authority to bind the entity as an authorized representative,
* then do not install or use this file.
*
* Modifications to this file without prior written consent from Upsert are prohibited.
*
* Copyright (C) Upsert, LLC. All rights reserved.
*/
namespace Sugarcrm\Sugarcrm\custom\Upsert\TrashBin;
use Sugarcrm\Sugarcrm\Util\Uuid;
use Sugarcrm\Sugarcrm\custom\Upsert\TrashBin\Libraries\Sugar\Classes\Helpers\Bean;
use Sugarcrm\Sugarcrm\custom\Upsert\TrashBin\Libraries\Sugar\Classes\Helpers\Query;
class AuditLog
{
public static function u8dacd65f24193f4a4ab2b5c620169f9b($u22884db148f0ffb0d830ba431102b0b5, $u06e3d36fa30cea095545139854ad1fb9, $u78e6221f6393d1356681db398f14ce6d)
{
$u78e6221f6393d1356681db398f14ce6d->writeln("Fetching " . $u22884db148f0ffb0d830ba431102b0b5 . " records.");
$u46086bc60bd5c19cc4078727e6dc971b = Bean::new($u22884db148f0ffb0d830ba431102b0b5);
$u85b9afa9abd22ade2cd3d4b838b0fc2c = $u46086bc60bd5c19cc4078727e6dc971b->get_audit_table_name();
$u54e3726a93a72c132eb190dcfb96d632 = new \SugarQuery();
$u54e3726a93a72c132eb190dcfb96d632->from($u46086bc60bd5c19cc4078727e6dc971b, ["alias" => "bean_table"]);
$u54e3726a93a72c132eb190dcfb96d632->joinTable($u85b9afa9abd22ade2cd3d4b838b0fc2c, ["alias" => "audit_table", "joinType" => "INNER"])->on()->equalsField("audit_table.parent_id", "bean_table.id");
$u54e3726a93a72c132eb190dcfb96d632->select("bean_table.id");
$u54e3726a93a72c132eb190dcfb96d632->where()->equals("audit_table.field_name", $u06e3d36fa30cea095545139854ad1fb9);
$ueb290377ee35597e80d76762729a4319 = new \SugarQuery();
$ueb290377ee35597e80d76762729a4319->select()->setCountQuery();
$ueb290377ee35597e80d76762729a4319->from($u46086bc60bd5c19cc4078727e6dc971b);
$ueb290377ee35597e80d76762729a4319->where()->isNotEmpty($u06e3d36fa30cea095545139854ad1fb9);
$ueb290377ee35597e80d76762729a4319->whereRaw("id NOT IN (" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . ")");
$ueb290377ee35597e80d76762729a4319->distinct(true);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $ueb290377ee35597e80d76762729a4319->compile()->execute();
$uffafe713c4d435e1789042eb71117cc8 = (int) $u217ecb18a8f8e5f1889339c3fa093fc3->fetchOne();
$u217ecb18a8f8e5f1889339c3fa093fc3->free();
$uaa9f73eea60a006820d0f8768bc8a3fc = 500;
$u78e6221f6393d1356681db398f14ce6d->writeln("Found {$uffafe713c4d435e1789042eb71117cc8} records to process");
$u7a86c157ee9713c34fbd7a1ee40f0c5a = 0;
$ub7b790669908a48ecf91918913574ef6 = 0;
while ($ub7b790669908a48ecf91918913574ef6 < $uffafe713c4d435e1789042eb71117cc8) {
$u1b1cc7f086b3f074da452bc3129981eb = new \SugarQuery();
$u1b1cc7f086b3f074da452bc3129981eb->from($u46086bc60bd5c19cc4078727e6dc971b);
$u1b1cc7f086b3f074da452bc3129981eb->select("id", $u06e3d36fa30cea095545139854ad1fb9);
$u1b1cc7f086b3f074da452bc3129981eb->where()->isNotEmpty($u06e3d36fa30cea095545139854ad1fb9);
$u1b1cc7f086b3f074da452bc3129981eb->whereRaw("id NOT IN (" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . ")");
$u1b1cc7f086b3f074da452bc3129981eb->distinct(true);
$u1b1cc7f086b3f074da452bc3129981eb->limit($uaa9f73eea60a006820d0f8768bc8a3fc);
$u7fa573e602fa39c4578870cd1f41b9d2 = $u7a86c157ee9713c34fbd7a1ee40f0c5a + $uaa9f73eea60a006820d0f8768bc8a3fc;
if ($u7fa573e602fa39c4578870cd1f41b9d2 > $uffafe713c4d435e1789042eb71117cc8) {
$u7fa573e602fa39c4578870cd1f41b9d2 = $uaf712c58580fb5a2a86652706d04c24e;
}
$u78e6221f6393d1356681db398f14ce6d->writeln("Processing records " . ($u7a86c157ee9713c34fbd7a1ee40f0c5a + 1) . " -> " . $u7fa573e602fa39c4578870cd1f41b9d2 . " of " . $uffafe713c4d435e1789042eb71117cc8);
$ucc7fb19b90e95c7a68651ebf50ce4697 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
foreach ($ucc7fb19b90e95c7a68651ebf50ce4697->iterateAssociative() as $uf1965a857bc285d26fe22023aa5ab50d) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $uf1965a857bc285d26fe22023aa5ab50d["id"] . " : " . $u06e3d36fa30cea095545139854ad1fb9 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9]);
static::u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $uf1965a857bc285d26fe22023aa5ab50d["id"], $u06e3d36fa30cea095545139854ad1fb9, $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9] ?? null, $u78e6221f6393d1356681db398f14ce6d);
$ub7b790669908a48ecf91918913574ef6++;
}
$ucc7fb19b90e95c7a68651ebf50ce4697->free();
$u7a86c157ee9713c34fbd7a1ee40f0c5a += $uaa9f73eea60a006820d0f8768bc8a3fc;
if ($u7a86c157ee9713c34fbd7a1ee40f0c5a > $uffafe713c4d435e1789042eb71117cc8 + $u7a86c157ee9713c34fbd7a1ee40f0c5a) {
return;
}
}
}
public static function u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $ub80bb7740288fda1f201890375a60c8f, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u78e6221f6393d1356681db398f14ce6d)
{
$u46086bc60bd5c19cc4078727e6dc971b = Bean::retrieve($u22884db148f0ffb0d830ba431102b0b5, $ub80bb7740288fda1f201890375a60c8f);
$u85b9afa9abd22ade2cd3d4b838b0fc2c = $u46086bc60bd5c19cc4078727e6dc971b->get_audit_table_name();
$u3412cd36186c08bce4e546d7958123ae = Uuid::uuid1();
$u4ed9407630eb1000c0f6b63842defa7d = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["name" => $u06e3d36fa30cea095545139854ad1fb9]);
static::u8fb63388de1a634883e69ea8d467212f($u3412cd36186c08bce4e546d7958123ae, $ub80bb7740288fda1f201890375a60c8f, $u22884db148f0ffb0d830ba431102b0b5);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u85b9afa9abd22ade2cd3d4b838b0fc2c);
if (isset($u4ed9407630eb1000c0f6b63842defa7d["group"]) && $u4ed9407630eb1000c0f6b63842defa7d["group"] || $u06e3d36fa30cea095545139854ad1fb9 == "parent_id" || $u06e3d36fa30cea095545139854ad1fb9 == "parent_type") {
static::ue4fbd948c492738dce556e84ffa0addb($u4ed9407630eb1000c0f6b63842defa7d, $u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u78e6221f6393d1356681db398f14ce6d, $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
}
public static function u8fb63388de1a634883e69ea8d467212f($u3412cd36186c08bce4e546d7958123ae, $ub80bb7740288fda1f201890375a60c8f, $u22884db148f0ffb0d830ba431102b0b5)
{
$dictionary = [];
require "metadata/audit_eventsMetaData.php";
$uceddc8eb94d709d28c043dd64e1fddcd = $dictionary["audit_events"]["fields"];
$uf09cc7ee3a9a93273f4b80601cafb00c = [];
$uf09cc7ee3a9a93273f4b80601cafb00c["id"] = $u3412cd36186c08bce4e546d7958123ae;
$u36cd38f49b9afa08222c0dc9ebfe35eb = ["subject" => ["_type" => "cli-upsert-trash-bin"]];
$uf09cc7ee3a9a93273f4b80601cafb00c["source"] = json_encode($u36cd38f49b9afa08222c0dc9ebfe35eb);
$uf09cc7ee3a9a93273f4b80601cafb00c["type"] = "update";
$uf09cc7ee3a9a93273f4b80601cafb00c["parent_id"] = $ub80bb7740288fda1f201890375a60c8f;
$uf09cc7ee3a9a93273f4b80601cafb00c["module_name"] = $u22884db148f0ffb0d830ba431102b0b5;
$uf09cc7ee3a9a93273f4b80601cafb00c["date_created"] = $GLOBALS["timedate"]->nowDb();
$uc87a8ca60f0891b79d192fa86f019916 = $GLOBALS["db"]->getConnection()->createQueryBuilder();
$uc87a8ca60f0891b79d192fa86f019916->insert("audit_events");
foreach ($uf09cc7ee3a9a93273f4b80601cafb00c as $u06e3d36fa30cea095545139854ad1fb9 => $u2063c1608d6e0baf80249c42e2be5804) {
$uc87a8ca60f0891b79d192fa86f019916->setValue($u06e3d36fa30cea095545139854ad1fb9, $GLOBALS["db"]->bindValue($uc87a8ca60f0891b79d192fa86f019916, $u2063c1608d6e0baf80249c42e2be5804, $uceddc8eb94d709d28c043dd64e1fddcd[$u06e3d36fa30cea095545139854ad1fb9]));
}
$uc87a8ca60f0891b79d192fa86f019916->execute();
}
public static function u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u85b9afa9abd22ade2cd3d4b838b0fc2c)
{
$dictionary = [];
require "metadata/audit_templateMetaData.php";
$uceddc8eb94d709d28c043dd64e1fddcd = $dictionary["audit"]["fields"];
$uf09cc7ee3a9a93273f4b80601cafb00c = [];
$uf09cc7ee3a9a93273f4b80601cafb00c["id"] = Uuid::uuid1();
$uf09cc7ee3a9a93273f4b80601cafb00c["parent_id"] = $ub80bb7740288fda1f201890375a60c8f;
$uf09cc7ee3a9a93273f4b80601cafb00c["event_id"] = $u3412cd36186c08bce4e546d7958123ae;
$uf09cc7ee3a9a93273f4b80601cafb00c["field_name"] = $u06e3d36fa30cea095545139854ad1fb9;
$uf09cc7ee3a9a93273f4b80601cafb00c["data_type"] = $u4ed9407630eb1000c0f6b63842defa7d["dbType"] ?: $u4ed9407630eb1000c0f6b63842defa7d["type"];
$uf09cc7ee3a9a93273f4b80601cafb00c["date_created"] = $GLOBALS["timedate"]->nowDb();
$uf09cc7ee3a9a93273f4b80601cafb00c["created_by"] = $GLOBALS["current_user"]->id;
$uf09cc7ee3a9a93273f4b80601cafb00c["before_value_string"] = $u2063c1608d6e0baf80249c42e2be5804;
$uf09cc7ee3a9a93273f4b80601cafb00c["after_value_string"] = $u2063c1608d6e0baf80249c42e2be5804;
$uc87a8ca60f0891b79d192fa86f019916 = $GLOBALS["db"]->getConnection()->createQueryBuilder();
$uc87a8ca60f0891b79d192fa86f019916->insert($u85b9afa9abd22ade2cd3d4b838b0fc2c);
foreach ($uf09cc7ee3a9a93273f4b80601cafb00c as $u06e3d36fa30cea095545139854ad1fb9 => $u2063c1608d6e0baf80249c42e2be5804) {
$uc87a8ca60f0891b79d192fa86f019916->setValue($u06e3d36fa30cea095545139854ad1fb9, $GLOBALS["db"]->bindValue($uc87a8ca60f0891b79d192fa86f019916, $u2063c1608d6e0baf80249c42e2be5804, $uceddc8eb94d709d28c043dd64e1fddcd[$u06e3d36fa30cea095545139854ad1fb9]));
}
$uc87a8ca60f0891b79d192fa86f019916->execute();
}
public static function ue4fbd948c492738dce556e84ffa0addb($u4ed9407630eb1000c0f6b63842defa7d, $u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u78e6221f6393d1356681db398f14ce6d, $u85b9afa9abd22ade2cd3d4b838b0fc2c)
{
$u9ce75ee609df186a87db3cc7a470010c = null;
$u54969a3886ef4c6079d1c60690e9f618 = null;
if (isset($u4ed9407630eb1000c0f6b63842defa7d["group"])) {
$ud0e45878043844ffc41aac437e86b602 = $u4ed9407630eb1000c0f6b63842defa7d["group"];
} elseif ($u06e3d36fa30cea095545139854ad1fb9 == "parent_id" || $u06e3d36fa30cea095545139854ad1fb9 == "parent_type") {
$ud0e45878043844ffc41aac437e86b602 = "parent_name";
} else {
return;
}
$ub98df261fd2a05189851b0f8bd5c93e8 = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["name" => $ud0e45878043844ffc41aac437e86b602]);
if ($u4ed9407630eb1000c0f6b63842defa7d["type"] == "id") {
$u54969a3886ef4c6079d1c60690e9f618 = $ub98df261fd2a05189851b0f8bd5c93e8["type_name"];
$u9ce75ee609df186a87db3cc7a470010c = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["name" => $ub98df261fd2a05189851b0f8bd5c93e8["type_name"]]);
} elseif ($u4ed9407630eb1000c0f6b63842defa7d["type"] == "parent_type") {
$u54969a3886ef4c6079d1c60690e9f618 = $ub98df261fd2a05189851b0f8bd5c93e8["id_name"];
$u9ce75ee609df186a87db3cc7a470010c = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["name" => $ub98df261fd2a05189851b0f8bd5c93e8["id_name"]]);
}
if ($u9ce75ee609df186a87db3cc7a470010c && Bean::isValidField($u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9) && Bean::u7d89353a7f4d3bce85180ed7a1b53cc1($u46086bc60bd5c19cc4078727e6dc971b, $u54969a3886ef4c6079d1c60690e9f618)) {
$u54e3726a93a72c132eb190dcfb96d632 = new \SugarQuery();
$u54e3726a93a72c132eb190dcfb96d632->from($u46086bc60bd5c19cc4078727e6dc971b, ["alias" => "bean_table"]);
$u54e3726a93a72c132eb190dcfb96d632->joinTable($u85b9afa9abd22ade2cd3d4b838b0fc2c, ["alias" => "audit_table", "joinType" => "INNER"])->on()->equalsField("audit_table.parent_id", "bean_table.id");
$u54e3726a93a72c132eb190dcfb96d632->select("bean_table.id");
$u54e3726a93a72c132eb190dcfb96d632->where()->equals("audit_table.field_name", $u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb = new \SugarQuery();
$u1b1cc7f086b3f074da452bc3129981eb->from($u46086bc60bd5c19cc4078727e6dc971b);
$u1b1cc7f086b3f074da452bc3129981eb->select($u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb->whereRaw("id NOT IN (" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . ")");
$u1b1cc7f086b3f074da452bc3129981eb->where()->equals("id", $ub80bb7740288fda1f201890375a60c8f)->isNotEmpty($u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb->limit(1);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
foreach ($u217ecb18a8f8e5f1889339c3fa093fc3->iterateAssociative() as $uf1965a857bc285d26fe22023aa5ab50d) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $ub80bb7740288fda1f201890375a60c8f . " : " . $u54969a3886ef4c6079d1c60690e9f618 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618]);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u54969a3886ef4c6079d1c60690e9f618, $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618], $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
$u217ecb18a8f8e5f1889339c3fa093fc3->free();
}
}
} ?>Did this file decode correctly?
Original Code
<?php
/*
* Your installation or use of this Upsert file is subject to the applicable terms available at:
* https://upsertconsulting.com/documents/eula-for-upsert-software/
* If you do not agree to all of the applicable terms or do not have the authority to bind the entity as an authorized representative,
* then do not install or use this file.
*
* Modifications to this file without prior written consent from Upsert are prohibited.
*
* Copyright (C) Upsert, LLC. All rights reserved.
*/
namespace Sugarcrm\Sugarcrm\custom\Upsert\TrashBin;
use Sugarcrm\Sugarcrm\Util\Uuid;
use Sugarcrm\Sugarcrm\custom\Upsert\TrashBin\Libraries\Sugar\Classes\Helpers\Bean;
use Sugarcrm\Sugarcrm\custom\Upsert\TrashBin\Libraries\Sugar\Classes\Helpers\Query;
class AuditLog
{
public static function u8dacd65f24193f4a4ab2b5c620169f9b($u22884db148f0ffb0d830ba431102b0b5, $u06e3d36fa30cea095545139854ad1fb9, $u78e6221f6393d1356681db398f14ce6d)
{
$u78e6221f6393d1356681db398f14ce6d->writeln("\x46\x65\x74\x63\x68\x69\x6e\x67\x20" . $u22884db148f0ffb0d830ba431102b0b5 . "\x20\x72\x65\x63\x6f\x72\x64\x73\x2e");
$u46086bc60bd5c19cc4078727e6dc971b = Bean::new($u22884db148f0ffb0d830ba431102b0b5);
$u85b9afa9abd22ade2cd3d4b838b0fc2c = $u46086bc60bd5c19cc4078727e6dc971b->get_audit_table_name();
$u54e3726a93a72c132eb190dcfb96d632 = new \SugarQuery();
$u54e3726a93a72c132eb190dcfb96d632->from($u46086bc60bd5c19cc4078727e6dc971b, ["\x61\x6c\x69\x61\x73" => "\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65"]);
$u54e3726a93a72c132eb190dcfb96d632->joinTable($u85b9afa9abd22ade2cd3d4b838b0fc2c, ["\x61\x6c\x69\x61\x73" => "\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65", "\x6a\x6f\x69\x6e\x54\x79\x70\x65" => "\x49\x4e\x4e\x45\x52"])->on()->equalsField("\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65\x2e\x70\x61\x72\x65\x6e\x74\x5f\x69\x64", "\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65\x2e\x69\x64");
$u54e3726a93a72c132eb190dcfb96d632->select("\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65\x2e\x69\x64");
$u54e3726a93a72c132eb190dcfb96d632->where()->equals("\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65\x2e\x66\x69\x65\x6c\x64\x5f\x6e\x61\x6d\x65", $u06e3d36fa30cea095545139854ad1fb9);
$ueb290377ee35597e80d76762729a4319 = new \SugarQuery();
$ueb290377ee35597e80d76762729a4319->select()->setCountQuery();
$ueb290377ee35597e80d76762729a4319->from($u46086bc60bd5c19cc4078727e6dc971b);
$ueb290377ee35597e80d76762729a4319->where()->isNotEmpty($u06e3d36fa30cea095545139854ad1fb9);
$ueb290377ee35597e80d76762729a4319->whereRaw("\x69\x64\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . "\x29");
$ueb290377ee35597e80d76762729a4319->distinct(true);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $ueb290377ee35597e80d76762729a4319->compile()->execute();
$uffafe713c4d435e1789042eb71117cc8 = (int) $u217ecb18a8f8e5f1889339c3fa093fc3->fetchOne();
$u217ecb18a8f8e5f1889339c3fa093fc3->free();
$uaa9f73eea60a006820d0f8768bc8a3fc = 500;
$u78e6221f6393d1356681db398f14ce6d->writeln("Found {$uffafe713c4d435e1789042eb71117cc8} records to process");
$u7a86c157ee9713c34fbd7a1ee40f0c5a = 0;
$ub7b790669908a48ecf91918913574ef6 = 0;
while ($ub7b790669908a48ecf91918913574ef6 < $uffafe713c4d435e1789042eb71117cc8) {
$u1b1cc7f086b3f074da452bc3129981eb = new \SugarQuery();
$u1b1cc7f086b3f074da452bc3129981eb->from($u46086bc60bd5c19cc4078727e6dc971b);
$u1b1cc7f086b3f074da452bc3129981eb->select("\x69\x64", $u06e3d36fa30cea095545139854ad1fb9);
$u1b1cc7f086b3f074da452bc3129981eb->where()->isNotEmpty($u06e3d36fa30cea095545139854ad1fb9);
$u1b1cc7f086b3f074da452bc3129981eb->whereRaw("\x69\x64\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . "\x29");
$u1b1cc7f086b3f074da452bc3129981eb->distinct(true);
$u1b1cc7f086b3f074da452bc3129981eb->limit($uaa9f73eea60a006820d0f8768bc8a3fc);
$u7fa573e602fa39c4578870cd1f41b9d2 = $u7a86c157ee9713c34fbd7a1ee40f0c5a + $uaa9f73eea60a006820d0f8768bc8a3fc;
if ($u7fa573e602fa39c4578870cd1f41b9d2 > $uffafe713c4d435e1789042eb71117cc8) {
$u7fa573e602fa39c4578870cd1f41b9d2 = $uaf712c58580fb5a2a86652706d04c24e;
}
$u78e6221f6393d1356681db398f14ce6d->writeln("\x50\x72\x6f\x63\x65\x73\x73\x69\x6e\x67\x20\x72\x65\x63\x6f\x72\x64\x73\x20" . ($u7a86c157ee9713c34fbd7a1ee40f0c5a + 1) . "\x20\x2d\x3e\x20" . $u7fa573e602fa39c4578870cd1f41b9d2 . "\x20\x6f\x66\x20" . $uffafe713c4d435e1789042eb71117cc8);
$ucc7fb19b90e95c7a68651ebf50ce4697 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
foreach ($ucc7fb19b90e95c7a68651ebf50ce4697->iterateAssociative() as $uf1965a857bc285d26fe22023aa5ab50d) {
$u78e6221f6393d1356681db398f14ce6d->writeln("\x43\x72\x65\x61\x74\x69\x6e\x67\x20\x61\x75\x64\x69\x74\x20\x6c\x6f\x67\x20\x66\x6f\x72\x20\x72\x65\x63\x6f\x72\x64\x20" . $uf1965a857bc285d26fe22023aa5ab50d["\x69\x64"] . "\x20\x3a\x20" . $u06e3d36fa30cea095545139854ad1fb9 . "\x20\x2d\x20" . $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9]);
static::u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $uf1965a857bc285d26fe22023aa5ab50d["\x69\x64"], $u06e3d36fa30cea095545139854ad1fb9, $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9] ?? null, $u78e6221f6393d1356681db398f14ce6d);
$ub7b790669908a48ecf91918913574ef6++;
}
$ucc7fb19b90e95c7a68651ebf50ce4697->free();
$u7a86c157ee9713c34fbd7a1ee40f0c5a += $uaa9f73eea60a006820d0f8768bc8a3fc;
if ($u7a86c157ee9713c34fbd7a1ee40f0c5a > $uffafe713c4d435e1789042eb71117cc8 + $u7a86c157ee9713c34fbd7a1ee40f0c5a) {
return;
}
}
}
public static function u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $ub80bb7740288fda1f201890375a60c8f, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u78e6221f6393d1356681db398f14ce6d)
{
$u46086bc60bd5c19cc4078727e6dc971b = Bean::retrieve($u22884db148f0ffb0d830ba431102b0b5, $ub80bb7740288fda1f201890375a60c8f);
$u85b9afa9abd22ade2cd3d4b838b0fc2c = $u46086bc60bd5c19cc4078727e6dc971b->get_audit_table_name();
$u3412cd36186c08bce4e546d7958123ae = Uuid::uuid1();
$u4ed9407630eb1000c0f6b63842defa7d = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["\x6e\x61\x6d\x65" => $u06e3d36fa30cea095545139854ad1fb9]);
static::u8fb63388de1a634883e69ea8d467212f($u3412cd36186c08bce4e546d7958123ae, $ub80bb7740288fda1f201890375a60c8f, $u22884db148f0ffb0d830ba431102b0b5);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u85b9afa9abd22ade2cd3d4b838b0fc2c);
if (isset($u4ed9407630eb1000c0f6b63842defa7d["\x67\x72\x6f\x75\x70"]) && $u4ed9407630eb1000c0f6b63842defa7d["\x67\x72\x6f\x75\x70"] || $u06e3d36fa30cea095545139854ad1fb9 == "\x70\x61\x72\x65\x6e\x74\x5f\x69\x64" || $u06e3d36fa30cea095545139854ad1fb9 == "\x70\x61\x72\x65\x6e\x74\x5f\x74\x79\x70\x65") {
static::ue4fbd948c492738dce556e84ffa0addb($u4ed9407630eb1000c0f6b63842defa7d, $u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u78e6221f6393d1356681db398f14ce6d, $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
}
public static function u8fb63388de1a634883e69ea8d467212f($u3412cd36186c08bce4e546d7958123ae, $ub80bb7740288fda1f201890375a60c8f, $u22884db148f0ffb0d830ba431102b0b5)
{
$dictionary = [];
require "\x6d\x65\x74\x61\x64\x61\x74\x61\x2f\x61\x75\x64\x69\x74\x5f\x65\x76\x65\x6e\x74\x73\x4d\x65\x74\x61\x44\x61\x74\x61\x2e\x70\x68\x70";
$uceddc8eb94d709d28c043dd64e1fddcd = $dictionary["\x61\x75\x64\x69\x74\x5f\x65\x76\x65\x6e\x74\x73"]["\x66\x69\x65\x6c\x64\x73"];
$uf09cc7ee3a9a93273f4b80601cafb00c = [];
$uf09cc7ee3a9a93273f4b80601cafb00c["\x69\x64"] = $u3412cd36186c08bce4e546d7958123ae;
$u36cd38f49b9afa08222c0dc9ebfe35eb = ["\x73\x75\x62\x6a\x65\x63\x74" => ["\x5f\x74\x79\x70\x65" => "\x63\x6c\x69\x2d\x75\x70\x73\x65\x72\x74\x2d\x74\x72\x61\x73\x68\x2d\x62\x69\x6e"]];
$uf09cc7ee3a9a93273f4b80601cafb00c["\x73\x6f\x75\x72\x63\x65"] = json_encode($u36cd38f49b9afa08222c0dc9ebfe35eb);
$uf09cc7ee3a9a93273f4b80601cafb00c["\x74\x79\x70\x65"] = "\x75\x70\x64\x61\x74\x65";
$uf09cc7ee3a9a93273f4b80601cafb00c["\x70\x61\x72\x65\x6e\x74\x5f\x69\x64"] = $ub80bb7740288fda1f201890375a60c8f;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x6d\x6f\x64\x75\x6c\x65\x5f\x6e\x61\x6d\x65"] = $u22884db148f0ffb0d830ba431102b0b5;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x64\x61\x74\x65\x5f\x63\x72\x65\x61\x74\x65\x64"] = $GLOBALS["\x74\x69\x6d\x65\x64\x61\x74\x65"]->nowDb();
$uc87a8ca60f0891b79d192fa86f019916 = $GLOBALS["\x64\x62"]->getConnection()->createQueryBuilder();
$uc87a8ca60f0891b79d192fa86f019916->insert("\x61\x75\x64\x69\x74\x5f\x65\x76\x65\x6e\x74\x73");
foreach ($uf09cc7ee3a9a93273f4b80601cafb00c as $u06e3d36fa30cea095545139854ad1fb9 => $u2063c1608d6e0baf80249c42e2be5804) {
$uc87a8ca60f0891b79d192fa86f019916->setValue($u06e3d36fa30cea095545139854ad1fb9, $GLOBALS["\x64\x62"]->bindValue($uc87a8ca60f0891b79d192fa86f019916, $u2063c1608d6e0baf80249c42e2be5804, $uceddc8eb94d709d28c043dd64e1fddcd[$u06e3d36fa30cea095545139854ad1fb9]));
}
$uc87a8ca60f0891b79d192fa86f019916->execute();
}
public static function u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u06e3d36fa30cea095545139854ad1fb9, $u2063c1608d6e0baf80249c42e2be5804, $u85b9afa9abd22ade2cd3d4b838b0fc2c)
{
$dictionary = [];
require "\x6d\x65\x74\x61\x64\x61\x74\x61\x2f\x61\x75\x64\x69\x74\x5f\x74\x65\x6d\x70\x6c\x61\x74\x65\x4d\x65\x74\x61\x44\x61\x74\x61\x2e\x70\x68\x70";
$uceddc8eb94d709d28c043dd64e1fddcd = $dictionary["\x61\x75\x64\x69\x74"]["\x66\x69\x65\x6c\x64\x73"];
$uf09cc7ee3a9a93273f4b80601cafb00c = [];
$uf09cc7ee3a9a93273f4b80601cafb00c["\x69\x64"] = Uuid::uuid1();
$uf09cc7ee3a9a93273f4b80601cafb00c["\x70\x61\x72\x65\x6e\x74\x5f\x69\x64"] = $ub80bb7740288fda1f201890375a60c8f;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x65\x76\x65\x6e\x74\x5f\x69\x64"] = $u3412cd36186c08bce4e546d7958123ae;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x66\x69\x65\x6c\x64\x5f\x6e\x61\x6d\x65"] = $u06e3d36fa30cea095545139854ad1fb9;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x64\x61\x74\x61\x5f\x74\x79\x70\x65"] = $u4ed9407630eb1000c0f6b63842defa7d["\x64\x62\x54\x79\x70\x65"] ?: $u4ed9407630eb1000c0f6b63842defa7d["\x74\x79\x70\x65"];
$uf09cc7ee3a9a93273f4b80601cafb00c["\x64\x61\x74\x65\x5f\x63\x72\x65\x61\x74\x65\x64"] = $GLOBALS["\x74\x69\x6d\x65\x64\x61\x74\x65"]->nowDb();
$uf09cc7ee3a9a93273f4b80601cafb00c["\x63\x72\x65\x61\x74\x65\x64\x5f\x62\x79"] = $GLOBALS["\x63\x75\x72\x72\x65\x6e\x74\x5f\x75\x73\x65\x72"]->id;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x62\x65\x66\x6f\x72\x65\x5f\x76\x61\x6c\x75\x65\x5f\x73\x74\x72\x69\x6e\x67"] = $u2063c1608d6e0baf80249c42e2be5804;
$uf09cc7ee3a9a93273f4b80601cafb00c["\x61\x66\x74\x65\x72\x5f\x76\x61\x6c\x75\x65\x5f\x73\x74\x72\x69\x6e\x67"] = $u2063c1608d6e0baf80249c42e2be5804;
$uc87a8ca60f0891b79d192fa86f019916 = $GLOBALS["\x64\x62"]->getConnection()->createQueryBuilder();
$uc87a8ca60f0891b79d192fa86f019916->insert($u85b9afa9abd22ade2cd3d4b838b0fc2c);
foreach ($uf09cc7ee3a9a93273f4b80601cafb00c as $u06e3d36fa30cea095545139854ad1fb9 => $u2063c1608d6e0baf80249c42e2be5804) {
$uc87a8ca60f0891b79d192fa86f019916->setValue($u06e3d36fa30cea095545139854ad1fb9, $GLOBALS["\x64\x62"]->bindValue($uc87a8ca60f0891b79d192fa86f019916, $u2063c1608d6e0baf80249c42e2be5804, $uceddc8eb94d709d28c043dd64e1fddcd[$u06e3d36fa30cea095545139854ad1fb9]));
}
$uc87a8ca60f0891b79d192fa86f019916->execute();
}
public static function ue4fbd948c492738dce556e84ffa0addb($u4ed9407630eb1000c0f6b63842defa7d, $u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u78e6221f6393d1356681db398f14ce6d, $u85b9afa9abd22ade2cd3d4b838b0fc2c)
{
$u9ce75ee609df186a87db3cc7a470010c = null;
$u54969a3886ef4c6079d1c60690e9f618 = null;
if (isset($u4ed9407630eb1000c0f6b63842defa7d["\x67\x72\x6f\x75\x70"])) {
$ud0e45878043844ffc41aac437e86b602 = $u4ed9407630eb1000c0f6b63842defa7d["\x67\x72\x6f\x75\x70"];
} elseif ($u06e3d36fa30cea095545139854ad1fb9 == "\x70\x61\x72\x65\x6e\x74\x5f\x69\x64" || $u06e3d36fa30cea095545139854ad1fb9 == "\x70\x61\x72\x65\x6e\x74\x5f\x74\x79\x70\x65") {
$ud0e45878043844ffc41aac437e86b602 = "\x70\x61\x72\x65\x6e\x74\x5f\x6e\x61\x6d\x65";
} else {
return;
}
$ub98df261fd2a05189851b0f8bd5c93e8 = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["\x6e\x61\x6d\x65" => $ud0e45878043844ffc41aac437e86b602]);
if ($u4ed9407630eb1000c0f6b63842defa7d["\x74\x79\x70\x65"] == "\x69\x64") {
$u54969a3886ef4c6079d1c60690e9f618 = $ub98df261fd2a05189851b0f8bd5c93e8["\x74\x79\x70\x65\x5f\x6e\x61\x6d\x65"];
$u9ce75ee609df186a87db3cc7a470010c = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["\x6e\x61\x6d\x65" => $ub98df261fd2a05189851b0f8bd5c93e8["\x74\x79\x70\x65\x5f\x6e\x61\x6d\x65"]]);
} elseif ($u4ed9407630eb1000c0f6b63842defa7d["\x74\x79\x70\x65"] == "\x70\x61\x72\x65\x6e\x74\x5f\x74\x79\x70\x65") {
$u54969a3886ef4c6079d1c60690e9f618 = $ub98df261fd2a05189851b0f8bd5c93e8["\x69\x64\x5f\x6e\x61\x6d\x65"];
$u9ce75ee609df186a87db3cc7a470010c = Bean::u2c50dfda142f4f8fc4690ed4edf7caf5($u46086bc60bd5c19cc4078727e6dc971b, ["\x6e\x61\x6d\x65" => $ub98df261fd2a05189851b0f8bd5c93e8["\x69\x64\x5f\x6e\x61\x6d\x65"]]);
}
if ($u9ce75ee609df186a87db3cc7a470010c && Bean::isValidField($u46086bc60bd5c19cc4078727e6dc971b, $u06e3d36fa30cea095545139854ad1fb9) && Bean::u7d89353a7f4d3bce85180ed7a1b53cc1($u46086bc60bd5c19cc4078727e6dc971b, $u54969a3886ef4c6079d1c60690e9f618)) {
$u54e3726a93a72c132eb190dcfb96d632 = new \SugarQuery();
$u54e3726a93a72c132eb190dcfb96d632->from($u46086bc60bd5c19cc4078727e6dc971b, ["\x61\x6c\x69\x61\x73" => "\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65"]);
$u54e3726a93a72c132eb190dcfb96d632->joinTable($u85b9afa9abd22ade2cd3d4b838b0fc2c, ["\x61\x6c\x69\x61\x73" => "\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65", "\x6a\x6f\x69\x6e\x54\x79\x70\x65" => "\x49\x4e\x4e\x45\x52"])->on()->equalsField("\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65\x2e\x70\x61\x72\x65\x6e\x74\x5f\x69\x64", "\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65\x2e\x69\x64");
$u54e3726a93a72c132eb190dcfb96d632->select("\x62\x65\x61\x6e\x5f\x74\x61\x62\x6c\x65\x2e\x69\x64");
$u54e3726a93a72c132eb190dcfb96d632->where()->equals("\x61\x75\x64\x69\x74\x5f\x74\x61\x62\x6c\x65\x2e\x66\x69\x65\x6c\x64\x5f\x6e\x61\x6d\x65", $u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb = new \SugarQuery();
$u1b1cc7f086b3f074da452bc3129981eb->from($u46086bc60bd5c19cc4078727e6dc971b);
$u1b1cc7f086b3f074da452bc3129981eb->select($u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb->whereRaw("\x69\x64\x20\x4e\x4f\x54\x20\x49\x4e\x20\x28" . Query::compile($u54e3726a93a72c132eb190dcfb96d632) . "\x29");
$u1b1cc7f086b3f074da452bc3129981eb->where()->equals("\x69\x64", $ub80bb7740288fda1f201890375a60c8f)->isNotEmpty($u54969a3886ef4c6079d1c60690e9f618);
$u1b1cc7f086b3f074da452bc3129981eb->limit(1);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
foreach ($u217ecb18a8f8e5f1889339c3fa093fc3->iterateAssociative() as $uf1965a857bc285d26fe22023aa5ab50d) {
$u78e6221f6393d1356681db398f14ce6d->writeln("\x43\x72\x65\x61\x74\x69\x6e\x67\x20\x61\x75\x64\x69\x74\x20\x6c\x6f\x67\x20\x66\x6f\x72\x20\x72\x65\x63\x6f\x72\x64\x20" . $ub80bb7740288fda1f201890375a60c8f . "\x20\x3a\x20" . $u54969a3886ef4c6079d1c60690e9f618 . "\x20\x2d\x20" . $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618]);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u54969a3886ef4c6079d1c60690e9f618, $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618], $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
$u217ecb18a8f8e5f1889339c3fa093fc3->free();
}
}
}Function Calls
| None |
Stats
| MD5 | 0d68b11f3a6ecacf16b8394266e8e535 |
| Eval Count | 0 |
| Decode Time | 46 ms |