Online PHP editor | vld for OfFgQ

<?php /* Plugin Name: JM Integração com SAP Plugin URI: Description: Jeronimo Martins - Integração com SAP Version: 20170602 Author: Xpand-it License: GPL2 License URI: https://www.gnu.org/licenses/gpl-2.0.html Text Domain: wporg Domain Path: /languages {Plugin Name} is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 2 of the License, or any later version. {Plugin Name} is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with {Plugin Name}. If not, see {License URI}. */ /** * @SWG\Swagger( * host="localhost:88", * basePath="/wp-json/api" * ) */ /** * @SWG\Info(title="Jeronimo Martins API", version="2.0") */ global $jm_sapintegration_db_version; $jm_sapintegration_db_version = '1.2'; require_once( 'utils/RegisterRoutes.php' ); require_once( 'controllers/ProductsControllers.php' ); use JM_leaflets\Controllers as Ctrl; // Hook for adding admin menus //add_action('admin_menu', 'jm_leaflets_add_menu'); // Action to create DB when plugin is installed register_activation_hook( __FILE__, 'jm_sapintegration_create_db' ); //add_action('admin_enqueue_scripts', 'registerLeafletsScripts' ); add_action( 'rest_api_init', 'register_routes_api' ); function register_routes_api(){ $routesRestCtrl = new RoutesRestRegister(); $routesRestCtrl->register_routes(); } function jm_sapintegration_create_db(){ global $wpdb; //global $db_version; $table_name = $wpdb->prefix . 'jm_leaflets_prods'; $charset_collate = $wpdb->get_charset_collate(); require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); $sql = "CREATE TABLE IF NOT EXISTS $table_name ( IdSap BIGINT(9) NOT NULL, Area varchar(254) DEFAULT '' NULL, Divisao varchar(254) DEFAULT '' NULL, Familia varchar(254) DEFAULT '' NULL, Categoria varchar(254) DEFAULT '' NULL, DescricaoCartaz varchar(254) DEFAULT '' NULL, DescricaoFolheto varchar(254) DEFAULT '' NULL, UMV varchar(254) DEFAULT '' NOT NULL, ProductImage varchar(254) DEFAULT '', CategoriesCodes varchar(254) DEFAULT '', IncrementUnit decimal(12 , 2) NULL, MarcaPropria varchar(254) DEFAULT '' NULL, DescrWordpress varchar(254) DEFAULT '' NULL, Embalagem varchar(254) DEFAULT '' NULL, Marca varchar(254) DEFAULT '' NULL, createdBy varchar(254) DEFAULT '' , createdDate datetime DEFAULT '0000-00-00 00:00:00' , updatedBy varchar(254) DEFAULT '', updatedDate datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (IdSap) ) $charset_collate;"; dbDelta( $sql ); /* $sql = "ALTER TABLE $table_name DROP PVP"; $wpdb->query( $sql );*/ /*$sql = "ALTER TABLE $table_name ADD Embalagem varchar(254) DEFAULT '' "; $wpdb->query( $sql ); */ $table_name = $wpdb->prefix . 'jm_leaflets_promotion'; $sql = "CREATE TABLE IF NOT EXISTS $table_name ( IdSap BIGINT(9) NOT NULL, /*Promotion*/ IDPromocaoGlobal BIGINT(9) NOT NULL, DescricaoPromocaoGlobal varchar(254) DEFAULT '' NULL, DataInicio datetime DEFAULT '0000-00-00 00:00:00' NULL, DataFim datetime DEFAULT '0000-00-00 00:00:00' NULL, PVPAccao decimal(5 , 2) NULL, Mecanica varchar(254) DEFAULT '' NULL, Icone varchar(254) DEFAULT '' NULL, MixLXPY varchar(254) DEFAULT '' NULL, LimiteQtd decimal(12 , 2) NULL, PmPVPAccao decimal(12 , 2) NULL, PmDesconto decimal(12 , 2) NULL, PmMecanica varchar(254) DEFAULT '' NULL, PmLimiteQtd decimal(12 , 2) NULL, PmMix varchar(254) DEFAULT '' NULL, TipoComunicacao varchar(254) DEFAULT '' NULL, IdentificadorGama varchar(254) DEFAULT '' NULL, ImagemEmFolheto varchar(254) DEFAULT '' NULL, DestaquePVP varchar(254) DEFAULT '' NULL, Status varchar(254) DEFAULT '' NULL, createdBy varchar(254) DEFAULT '' , createdDate datetime DEFAULT '0000-00-00 00:00:00' , updatedBy varchar(254) DEFAULT '', updatedDate datetime DEFAULT '0000-00-00 00:00:00', GeneratedImageProduct varchar(254) DEFAULT '', GeneratedImageBadge varchar(254) DEFAULT '', NeedsToBeUpdated boolean DEFAULT FALSE, BadgeImageH varchar(254) DEFAULT '', BadgeImageV varchar(254) DEFAULT '', ProductWithError boolean DEFAULT FALSE, UnitPrice decimal(12 , 2) NULL, PVP decimal( 12 , 2 ) NULL, PRIMARY KEY (IdSap, IDPromocaoGlobal) ) $charset_collate;"; dbDelta( $sql ); /* $sql = "ALTER TABLE $table_name ADD PVP decimal( 12 , 2 ) NULL "; $wpdb->query( $sql );*/ $table_name = $wpdb->prefix . 'jm_leaflets_prods_historic'; /*$wpdb->query("DROP TABLE IF EXISTS $table_name");*/ $sql="CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT(9) NOT NULL AUTO_INCREMENT, idSap BIGINT(9) NOT NULL, idPromotion BIGINT(9) NOT NULL, field varchar(254) DEFAULT '' NOT NULL, lastValue varchar(254) DEFAULT '' NOT NULL, fieldType varchar(254) DEFAULT '' NOT NULL, createdBy varchar(254) DEFAULT '' , createdDate datetime DEFAULT '0000-00-00 00:00:00' , updatedBy varchar(254) DEFAULT '', updatedDate datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY ( id ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_store'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( idLeafletProd BIGINT(9) NOT NULL, idPromotion BIGINT(9) NOT NULL, idLoja BIGINT(9) NOT NULL, folheto varchar(254) DEFAULT '', sortido varchar(254) DEFAULT '', createdBy varchar(254) DEFAULT '' , createdDate datetime DEFAULT '0000-00-00 00:00:00' , updatedBy varchar(254) DEFAULT '', updatedDate datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY ( idLeafletProd, idLoja, idPromotion ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_changes'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( IdSap BIGINT(9) NOT NULL, IdPromotion BIGINT(9) NOT NULL, Field varchar(254) DEFAULT '' NOT NULL, FieldValue varchar(254) DEFAULT '' NOT NULL, FieldType varchar(254) DEFAULT '' NOT NULL, createdBy varchar(254) DEFAULT '' , createdDate datetime DEFAULT '0000-00-00 00:00:00' , updatedBy varchar(254) DEFAULT '', updatedDate datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY ( IdSap, IdPromotion, Field ) ) CHARSET = utf8 COLLATE = utf8_unicode_ci;"; dbDelta($sql); //Delete old Market Structure Tables //Market Structure Tables $table_name = $wpdb->prefix . 'jm_leaflets_prods_categories'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT(9) NOT NULL AUTO_INCREMENT, Name varchar(254) DEFAULT '' NOT NULL, MenuOrder INT NULL DEFAULT '0', Icone varchar(254) DEFAULT '', PRIMARY KEY ( id ) ) $charset_collate;"; dbDelta($sql); /* $sql = "ALTER TABLE $table_name ADD MenuOrder INT NULL DEFAULT '0' "; $wpdb->query( $sql ); $sql = "ALTER TABLE $table_name ADD Icone varchar(254) DEFAULT '' "; $wpdb->query( $sql ); */ $table_name = $wpdb->prefix . 'jm_leaflets_prods_sub_categories'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT(9) NOT NULL AUTO_INCREMENT, Name varchar(254) DEFAULT '' NOT NULL, idCategory BIGINT(9) NOT NULL, PRIMARY KEY ( id ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_codes'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT(9) NOT NULL AUTO_INCREMENT, Code varchar(254) DEFAULT '' NOT NULL, PRIMARY KEY ( id ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_sub_categories_codes'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( idCode BIGINT(9) NOT NULL, idSubCategory BIGINT(9) NOT NULL, PRIMARY KEY ( idCode, idSubCategory ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_cross_selling'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( idProd BIGINT(9) NOT NULL, idProdCross BIGINT(9) NOT NULL, IdPromotion BIGINT(9) NOT NULL, PRIMARY KEY ( idProd, idProdCross ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_leaflets_prods_invalid'; $sql="CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT(9) NOT NULL AUTO_INCREMENT, idProd BIGINT(9) NOT NULL, field varchar(254) DEFAULT '' NOT NULL, description varchar(254) DEFAULT '' NOT NULL, PRIMARY KEY ( id ) ) $charset_collate;"; dbDelta($sql); $table_name = $wpdb->prefix . 'jm_sapIntegrations_logs'; $wpdb->query("DROP TABLE IF EXISTS $table_name"); add_option( 'jm_sapintegration_db_version', $jm_sapintegration_db_version ); } function validateProductsCronJob() { error_log("validate Prods CronJob Run"); $ProdCtrl = new Ctrl\SapProductsController(); error_log("create Ctrl Validate"); $ProdCtrl->approveProducts(); error_log("End Prods CronJob Run"); } register_deactivation_hook(__FILE__, 'jm_SapIntegration_deactivate'); function jm_SapIntegration_deactivate() { /*wp_clear_scheduled_hook('jm_sapintegration_validate_prods');*/ } ?>

Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OfFgQ
function name:  (null)
number of ops:  17
compiled vars:  !0 = $jm_sapintegration_db_version
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   40     0  E >   BIND_GLOBAL                                              !0, 'jm_sapintegration_db_version'
   41     1        ASSIGN                                                   !0, '1.2'
   43     2        INCLUDE_OR_EVAL                                          'utils%2FRegisterRoutes.php', REQUIRE_ONCE
   44     3        INCLUDE_OR_EVAL                                          'controllers%2FProductsControllers.php', REQUIRE_ONCE
   53     4        INIT_FCALL_BY_NAME                                       'register_activation_hook'
          5        SEND_VAL_EX                                              '%2Fin%2FOfFgQ'
          6        SEND_VAL_EX                                              'jm_sapintegration_create_db'
          7        DO_FCALL                                      0          
   56     8        INIT_FCALL_BY_NAME                                       'add_action'
          9        SEND_VAL_EX                                              'rest_api_init'
         10        SEND_VAL_EX                                              'register_routes_api'
         11        DO_FCALL                                      0          
  333    12        INIT_FCALL_BY_NAME                                       'register_deactivation_hook'
         13        SEND_VAL_EX                                              '%2Fin%2FOfFgQ'
         14        SEND_VAL_EX                                              'jm_SapIntegration_deactivate'
         15        DO_FCALL                                      0          
  340    16      > RETURN                                                   1

Function register_routes_api:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OfFgQ
function name:  register_routes_api
number of ops:  6
compiled vars:  !0 = $routesRestCtrl
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   60     0  E >   NEW                                              $1      'RoutesRestRegister'
          1        DO_FCALL                                      0          
          2        ASSIGN                                                   !0, $1
   61     3        INIT_METHOD_CALL                                         !0, 'register_routes'
          4        DO_FCALL                                      0          
   62     5      > RETURN                                                   null

End of function register_routes_api

Function jm_sapintegration_create_db:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OfFgQ
function name:  jm_sapintegration_create_db
number of ops:  150
compiled vars:  !0 = $wpdb, !1 = $table_name, !2 = $charset_collate, !3 = $sql, !4 = $jm_sapintegration_db_version
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   66     0  E >   BIND_GLOBAL                                              !0, 'wpdb'
   69     1        FETCH_OBJ_R                                      ~5      !0, 'prefix'
          2        CONCAT                                           ~6      ~5, 'jm_leaflets_prods'
          3        ASSIGN                                                   !1, ~6
   71     4        INIT_METHOD_CALL                                         !0, 'get_charset_collate'
          5        DO_FCALL                                      0  $8      
          6        ASSIGN                                                   !2, $8
   73     7        FETCH_CONSTANT                                   ~10     'ABSPATH'
          8        CONCAT                                           ~11     ~10, 'wp-admin%2Fincludes%2Fupgrade.php'
          9        INCLUDE_OR_EVAL                                          ~11, REQUIRE_ONCE
   76    10        ROPE_INIT                                     5  ~14     'CREATE+TABLE+IF+NOT+EXISTS+'
         11        ROPE_ADD                                      1  ~14     ~14, !1
         12        ROPE_ADD                                      2  ~14     ~14, '+%28%0A%09%09%09IdSap+BIGINT%289%29+NOT+NULL%2C%0A%09%09%09Area+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Divisao+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Familia+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Categoria+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09DescricaoCartaz+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09DescricaoFolheto+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09UMV+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09%09ProductImage+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09CategoriesCodes+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09IncrementUnit+decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09MarcaPropria+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09DescrWordpress+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Embalagem+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Marca+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09createdBy+varchar%28254%29+DEFAULT+%27%27+%2C%0A%09%09%09createdDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+%2C%0A%09%09%09updatedBy+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09updatedDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27%2C%0A%09%09%09%0A%09%09%09%0A%09%09PRIMARY+KEY++%28IdSap%29%0A%09%09%29+'
   99    13        ROPE_ADD                                      3  ~14     ~14, !2
         14        ROPE_END                                      4  ~13     ~14, '%3B'
   76    15        ASSIGN                                                   !3, ~13
  101    16        INIT_FCALL_BY_NAME                                       'dbDelta'
         17        SEND_VAR_EX                                              !3
         18        DO_FCALL                                      0          
  114    19        FETCH_OBJ_R                                      ~19     !0, 'prefix'
         20        CONCAT                                           ~20     ~19, 'jm_leaflets_promotion'
         21        ASSIGN                                                   !1, ~20
  117    22        ROPE_INIT                                     5  ~23     'CREATE+TABLE+IF+NOT+EXISTS+'
         23        ROPE_ADD                                      1  ~23     ~23, !1
         24        ROPE_ADD                                      2  ~23     ~23, '+%28%0A%09%09%09IdSap+BIGINT%289%29+NOT+NULL%2C%0A%0A%09%09%09%2F%2APromotion%2A%2F%0A%09%09%09IDPromocaoGlobal+BIGINT%289%29+NOT+NULL%2C%0A%09%09%09DescricaoPromocaoGlobal+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09DataInicio+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+NULL%2C%0A%09%09%09DataFim+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+NULL%2C%0A%09%09%09PVPAccao+decimal%285+%2C+2%29+NULL%2C%0A%09%09%09Mecanica+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Icone+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09MixLXPY+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09LimiteQtd+decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09PmPVPAccao+decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09PmDesconto++decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09PmMecanica+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09PmLimiteQtd+decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09PmMix+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09TipoComunicacao+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09IdentificadorGama+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09ImagemEmFolheto+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09DestaquePVP+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09Status+varchar%28254%29+DEFAULT+%27%27+NULL%2C%0A%09%09%09createdBy+varchar%28254%29+DEFAULT+%27%27+%2C%0A%09%09%09createdDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+%2C%0A%09%09%09updatedBy+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09updatedDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27%2C%0A%09%09%09GeneratedImageProduct+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09GeneratedImageBadge+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09NeedsToBeUpdated+boolean+DEFAULT+FALSE%2C%0A%09%09%09BadgeImageH+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09BadgeImageV+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09%09ProductWithError+boolean+DEFAULT+FALSE%2C%0A%09%09%09UnitPrice+decimal%2812+%2C+2%29+NULL%2C%0A%09%09%09PVP+decimal%28+12+%2C+2+%29+NULL%2C%0A%09%09%09%0A%09%09PRIMARY+KEY++%28IdSap%2C+IDPromocaoGlobal%29%0A%09%09%29+'
  154    25        ROPE_ADD                                      3  ~23     ~23, !2
         26        ROPE_END                                      4  ~22     ~23, '%3B'
  117    27        ASSIGN                                                   !3, ~22
  156    28        INIT_FCALL_BY_NAME                                       'dbDelta'
         29        SEND_VAR_EX                                              !3
         30        DO_FCALL                                      0          
  163    31        FETCH_OBJ_R                                      ~28     !0, 'prefix'
         32        CONCAT                                           ~29     ~28, 'jm_leaflets_prods_historic'
         33        ASSIGN                                                   !1, ~29
  169    34        ROPE_INIT                                     5  ~32     'CREATE+TABLE+IF+NOT+EXISTS+'
         35        ROPE_ADD                                      1  ~32     ~32, !1
         36        ROPE_ADD                                      2  ~32     ~32, '+%28%0A%09%09id+BIGINT%289%29+NOT+NULL+AUTO_INCREMENT%2C%0A%09%09idSap+BIGINT%289%29+NOT+NULL%2C%0A%09%09idPromotion+BIGINT%289%29+NOT+NULL%2C%0A%09%09field+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09lastValue+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09fieldType+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09createdBy+varchar%28254%29+DEFAULT+%27%27+%2C%0A%09%09createdDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+%2C%0A%09%09updatedBy+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09updatedDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27%2C%0A%09%09PRIMARY+KEY++%28+id+%29%0A%09%09%29+'
  181    37        ROPE_ADD                                      3  ~32     ~32, !2
         38        ROPE_END                                      4  ~31     ~32, '%3B'
  169    39        ASSIGN                                                   !3, ~31
  183    40        INIT_FCALL_BY_NAME                                       'dbDelta'
         41        SEND_VAR_EX                                              !3
         42        DO_FCALL                                      0          
  185    43        FETCH_OBJ_R                                      ~37     !0, 'prefix'
         44        CONCAT                                           ~38     ~37, 'jm_leaflets_prods_store'
         45        ASSIGN                                                   !1, ~38
  188    46        ROPE_INIT                                     5  ~41     'CREATE+TABLE+IF+NOT+EXISTS+'
         47        ROPE_ADD                                      1  ~41     ~41, !1
         48        ROPE_ADD                                      2  ~41     ~41, '+%28%0A%09%09idLeafletProd+BIGINT%289%29+NOT+NULL%2C%0A%09%09idPromotion+BIGINT%289%29+NOT+NULL%2C%0A%09%09idLoja+BIGINT%289%29+NOT+NULL%2C%0A%09%09folheto+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09sortido+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09createdBy+varchar%28254%29+DEFAULT+%27%27+%2C%0A%09%09createdDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+%2C%0A%09%09updatedBy+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09updatedDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27%2C%0A%09%09PRIMARY+KEY++%28+idLeafletProd%2C+idLoja%2C+idPromotion+%29%0A%09%09%29+'
  199    49        ROPE_ADD                                      3  ~41     ~41, !2
         50        ROPE_END                                      4  ~40     ~41, '%3B'
  188    51        ASSIGN                                                   !3, ~40
  201    52        INIT_FCALL_BY_NAME                                       'dbDelta'
         53        SEND_VAR_EX                                              !3
         54        DO_FCALL                                      0          
  203    55        FETCH_OBJ_R                                      ~46     !0, 'prefix'
         56        CONCAT                                           ~47     ~46, 'jm_leaflets_prods_changes'
         57        ASSIGN                                                   !1, ~47
  206    58        ROPE_INIT                                     3  ~50     'CREATE+TABLE+IF+NOT+EXISTS+'
         59        ROPE_ADD                                      1  ~50     ~50, !1
         60        ROPE_END                                      2  ~49     ~50, '+%28%0A%09%09IdSap+BIGINT%289%29+NOT+NULL%2C%0A%09%09IdPromotion+BIGINT%289%29+NOT+NULL%2C%0A%09%09Field+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09FieldValue+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09FieldType+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09createdBy+varchar%28254%29+DEFAULT+%27%27+%2C%0A%09%09createdDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27+%2C%0A%09%09updatedBy+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09updatedDate+datetime+DEFAULT+%270000-00-00+00%3A00%3A00%27%2C%0A%09%09PRIMARY+KEY++%28+IdSap%2C+IdPromotion%2C+Field+%29%0A%09%09%29+CHARSET+%3D+utf8+COLLATE+%3D+utf8_unicode_ci%3B'
         61        ASSIGN                                                   !3, ~49
  219    62        INIT_FCALL_BY_NAME                                       'dbDelta'
         63        SEND_VAR_EX                                              !3
         64        DO_FCALL                                      0          
  224    65        FETCH_OBJ_R                                      ~54     !0, 'prefix'
         66        CONCAT                                           ~55     ~54, 'jm_leaflets_prods_categories'
         67        ASSIGN                                                   !1, ~55
  227    68        ROPE_INIT                                     5  ~58     'CREATE+TABLE+IF+NOT+EXISTS+'
         69        ROPE_ADD                                      1  ~58     ~58, !1
         70        ROPE_ADD                                      2  ~58     ~58, '+%28%0A%09%09id+BIGINT%289%29+NOT+NULL+AUTO_INCREMENT%2C%0A%09%09Name+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09MenuOrder+INT+NULL+DEFAULT+%270%27%2C%0A%09%09Icone+varchar%28254%29+DEFAULT+%27%27%2C%0A%09%09PRIMARY+KEY++%28+id+%29%0A%09%09%29+'
  233    71        ROPE_ADD                                      3  ~58     ~58, !2
         72        ROPE_END                                      4  ~57     ~58, '%3B'
  227    73        ASSIGN                                                   !3, ~57
  235    74        INIT_FCALL_BY_NAME                                       'dbDelta'
         75        SEND_VAR_EX                                              !3
         76        DO_FCALL                                      0          
  244    77        FETCH_OBJ_R                                      ~63     !0, 'prefix'
         78        CONCAT                                           ~64     ~63, 'jm_leaflets_prods_sub_categories'
         79        ASSIGN                                                   !1, ~64
  247    80        ROPE_INIT                                     5  ~67     'CREATE+TABLE+IF+NOT+EXISTS+'
         81        ROPE_ADD                                      1  ~67     ~67, !1
         82        ROPE_ADD                                      2  ~67     ~67, '+%28%0A%09%09id+BIGINT%289%29+NOT+NULL+AUTO_INCREMENT%2C%0A%09%09Name+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09idCategory+BIGINT%289%29+NOT+NULL%2C%0A%09%09PRIMARY+KEY++%28+id+%29%0A%09%09%29+'
  252    83        ROPE_ADD                                      3  ~67     ~67, !2
         84        ROPE_END                                      4  ~66     ~67, '%3B'
  247    85        ASSIGN                                                   !3, ~66
  254    86        INIT_FCALL_BY_NAME                                       'dbDelta'
         87        SEND_VAR_EX                                              !3
         88        DO_FCALL                                      0          
  256    89        FETCH_OBJ_R                                      ~72     !0, 'prefix'
         90        CONCAT                                           ~73     ~72, 'jm_leaflets_prods_codes'
         91        ASSIGN                                                   !1, ~73
  259    92        ROPE_INIT                                     5  ~76     'CREATE+TABLE+IF+NOT+EXISTS+'
         93        ROPE_ADD                                      1  ~76     ~76, !1
         94        ROPE_ADD                                      2  ~76     ~76, '+%28%0A%09%09id+BIGINT%289%29+NOT+NULL+AUTO_INCREMENT%2C%0A%09%09Code+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09PRIMARY+KEY++%28+id+%29%0A%09%09%29+'
  263    95        ROPE_ADD                                      3  ~76     ~76, !2
         96        ROPE_END                                      4  ~75     ~76, '%3B'
  259    97        ASSIGN                                                   !3, ~75
  265    98        INIT_FCALL_BY_NAME                                       'dbDelta'
         99        SEND_VAR_EX                                              !3
        100        DO_FCALL                                      0          
  267   101        FETCH_OBJ_R                                      ~81     !0, 'prefix'
        102        CONCAT                                           ~82     ~81, 'jm_leaflets_prods_sub_categories_codes'
        103        ASSIGN                                                   !1, ~82
  272   104        ROPE_INIT                                     5  ~85     'CREATE+TABLE+IF+NOT+EXISTS+'
        105        ROPE_ADD                                      1  ~85     ~85, !1
        106        ROPE_ADD                                      2  ~85     ~85, '+%28%0A%09%09idCode+BIGINT%289%29+NOT+NULL%2C%0A%09%09idSubCategory+BIGINT%289%29+NOT+NULL%2C%0A%09%09PRIMARY+KEY++%28+idCode%2C+idSubCategory+%29%0A%09%09%29+'
  276   107        ROPE_ADD                                      3  ~85     ~85, !2
        108        ROPE_END                                      4  ~84     ~85, '%3B'
  272   109        ASSIGN                                                   !3, ~84
  278   110        INIT_FCALL_BY_NAME                                       'dbDelta'
        111        SEND_VAR_EX                                              !3
        112        DO_FCALL                                      0          
  282   113        FETCH_OBJ_R                                      ~90     !0, 'prefix'
        114        CONCAT                                           ~91     ~90, 'jm_leaflets_prods_cross_selling'
        115        ASSIGN                                                   !1, ~91
  285   116        ROPE_INIT                                     5  ~94     'CREATE+TABLE+IF+NOT+EXISTS+'
        117        ROPE_ADD                                      1  ~94     ~94, !1
        118        ROPE_ADD                                      2  ~94     ~94, '+%28%0A%09%09idProd+BIGINT%289%29+NOT+NULL%2C%0A%09%09idProdCross+BIGINT%289%29+NOT+NULL%2C%0A%09%09IdPromotion+BIGINT%289%29+NOT+NULL%2C%0A%09%09PRIMARY+KEY++%28+idProd%2C+idProdCross+%29%0A%09%09%29+'
  290   119        ROPE_ADD                                      3  ~94     ~94, !2
        120        ROPE_END                                      4  ~93     ~94, '%3B'
  285   121        ASSIGN                                                   !3, ~93
  292   122        INIT_FCALL_BY_NAME                                       'dbDelta'
        123        SEND_VAR_EX                                              !3
        124        DO_FCALL                                      0          
  295   125        FETCH_OBJ_R                                      ~99     !0, 'prefix'
        126        CONCAT                                           ~100    ~99, 'jm_leaflets_prods_invalid'
        127        ASSIGN                                                   !1, ~100
  298   128        ROPE_INIT                                     5  ~103    'CREATE+TABLE+IF+NOT+EXISTS+'
        129        ROPE_ADD                                      1  ~103    ~103, !1
        130        ROPE_ADD                                      2  ~103    ~103, '+%28%0A%09%09id+BIGINT%289%29+NOT+NULL+AUTO_INCREMENT%2C%0A++++%09idProd+BIGINT%289%29+NOT+NULL%2C%0A%09%09field+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09description+varchar%28254%29+DEFAULT+%27%27+NOT+NULL%2C%0A%09%09PRIMARY+KEY++%28+id+%29%0A%09%09%29+'
  304   131        ROPE_ADD                                      3  ~103    ~103, !2
        132        ROPE_END                                      4  ~102    ~103, '%3B'
  298   133        ASSIGN                                                   !3, ~102
  306   134        INIT_FCALL_BY_NAME                                       'dbDelta'
        135        SEND_VAR_EX                                              !3
        136        DO_FCALL                                      0          
  310   137        FETCH_OBJ_R                                      ~108    !0, 'prefix'
        138        CONCAT                                           ~109    ~108, 'jm_sapIntegrations_logs'
        139        ASSIGN                                                   !1, ~109
  312   140        INIT_METHOD_CALL                                         !0, 'query'
        141        NOP                                                      
        142        FAST_CONCAT                                      ~111    'DROP+TABLE+IF+EXISTS+', !1
        143        SEND_VAL_EX                                              ~111
        144        DO_FCALL                                      0          
  314   145        INIT_FCALL_BY_NAME                                       'add_option'
        146        SEND_VAL_EX                                              'jm_sapintegration_db_version'
        147        SEND_VAR_EX                                              !4
        148        DO_FCALL                                      0          
  316   149      > RETURN                                                   null

End of function jm_sapintegration_create_db

Function validateproductscronjob:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OfFgQ
function name:  validateProductsCronJob
number of ops:  15
compiled vars:  !0 = $ProdCtrl
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
  320     0  E >   INIT_FCALL                                               'error_log'
          1        SEND_VAL                                                 'validate+Prods+CronJob+Run'
          2        DO_ICALL                                                 
  322     3        NEW                                              $2      'JM_leaflets%5CControllers%5CSapProductsController'
          4        DO_FCALL                                      0          
          5        ASSIGN                                                   !0, $2
  324     6        INIT_FCALL                                               'error_log'
          7        SEND_VAL                                                 'create+Ctrl+Validate'
          8        DO_ICALL                                                 
  326     9        INIT_METHOD_CALL                                         !0, 'approveProducts'
         10        DO_FCALL                                      0          
  328    11        INIT_FCALL                                               'error_log'
         12        SEND_VAL                                                 'End+Prods+CronJob+Run'
         13        DO_ICALL                                                 
  330    14      > RETURN                                                   null

End of function validateproductscronjob

Function jm_sapintegration_deactivate:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/OfFgQ
function name:  jm_SapIntegration_deactivate
number of ops:  1
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
  337     0  E > > RETURN                                                   null

End of function jm_sapintegration_deactivate

Generated using Vulcan Logic Dumper, using php 8.0.0