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 applicab..
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();
$ue2942a04780e223b215eb8b663cf5353 = (int) $u217ecb18a8f8e5f1889339c3fa093fc3->fetchOne();
$u7a86c157ee9713c34fbd7a1ee40f0c5a = 0;
while ($u7a86c157ee9713c34fbd7a1ee40f0c5a < $ue2942a04780e223b215eb8b663cf5353) {
$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(500);
$u1b1cc7f086b3f074da452bc3129981eb->offset($u7a86c157ee9713c34fbd7a1ee40f0c5a);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
while ($uf1965a857bc285d26fe22023aa5ab50d = $u217ecb18a8f8e5f1889339c3fa093fc3->fetch()) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $uf1965a857bc285d26fe22023aa5ab50d["id"] . " : " . $u06e3d36fa30cea095545139854ad1fb9 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9]);
static::u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $uf1965a857bc285d26fe22023aa5ab50d["id"], $u06e3d36fa30cea095545139854ad1fb9, $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9], $u78e6221f6393d1356681db398f14ce6d);
}
$u7a86c157ee9713c34fbd7a1ee40f0c5a += 500;
}
}
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 ($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 ($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();
while ($uf1965a857bc285d26fe22023aa5ab50d = $u217ecb18a8f8e5f1889339c3fa093fc3->fetch()) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $ub80bb7740288fda1f201890375a60c8f . " : " . $u54969a3886ef4c6079d1c60690e9f618 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618]);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u54969a3886ef4c6079d1c60690e9f618, $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618], $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
}
}
} ?>
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("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();
$ue2942a04780e223b215eb8b663cf5353 = (int) $u217ecb18a8f8e5f1889339c3fa093fc3->fetchOne();
$u7a86c157ee9713c34fbd7a1ee40f0c5a = 0;
while ($u7a86c157ee9713c34fbd7a1ee40f0c5a < $ue2942a04780e223b215eb8b663cf5353) {
$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(500);
$u1b1cc7f086b3f074da452bc3129981eb->offset($u7a86c157ee9713c34fbd7a1ee40f0c5a);
$u217ecb18a8f8e5f1889339c3fa093fc3 = $u1b1cc7f086b3f074da452bc3129981eb->compile()->execute();
while ($uf1965a857bc285d26fe22023aa5ab50d = $u217ecb18a8f8e5f1889339c3fa093fc3->fetch()) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $uf1965a857bc285d26fe22023aa5ab50d["id"] . " : " . $u06e3d36fa30cea095545139854ad1fb9 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9]);
static::u519aed211797c418e7904f4f9db60ba6($u22884db148f0ffb0d830ba431102b0b5, $uf1965a857bc285d26fe22023aa5ab50d["id"], $u06e3d36fa30cea095545139854ad1fb9, $uf1965a857bc285d26fe22023aa5ab50d[$u06e3d36fa30cea095545139854ad1fb9], $u78e6221f6393d1356681db398f14ce6d);
}
$u7a86c157ee9713c34fbd7a1ee40f0c5a += 500;
}
}
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 ($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 ($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();
while ($uf1965a857bc285d26fe22023aa5ab50d = $u217ecb18a8f8e5f1889339c3fa093fc3->fetch()) {
$u78e6221f6393d1356681db398f14ce6d->writeln("Creating audit log for record " . $ub80bb7740288fda1f201890375a60c8f . " : " . $u54969a3886ef4c6079d1c60690e9f618 . " - " . $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618]);
static::u596cf3d2adf72e8676f8cb68afe29988($u4ed9407630eb1000c0f6b63842defa7d, $ub80bb7740288fda1f201890375a60c8f, $u3412cd36186c08bce4e546d7958123ae, $u54969a3886ef4c6079d1c60690e9f618, $uf1965a857bc285d26fe22023aa5ab50d[$u54969a3886ef4c6079d1c60690e9f618], $u85b9afa9abd22ade2cd3d4b838b0fc2c);
}
}
}
} ?>
Function Calls
None |
Stats
MD5 | dbcd25fea66b868c98bb3e30be2a1a57 |
Eval Count | 0 |
Decode Time | 53 ms |