@ 2017-07-11T10:59:52Z <?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');*/
}
?>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).
Version System time (s) User time (s) Memory (MiB) 8.3.6 0.017 0.003 16.75 8.3.5 0.003 0.014 16.26 8.3.4 0.006 0.009 18.96 8.3.3 0.006 0.009 18.83 8.3.2 0.007 0.011 20.16 8.3.1 0.009 0.009 21.99 8.3.0 0.000 0.009 21.89 8.2.18 0.012 0.009 17.00 8.2.17 0.008 0.008 22.96 8.2.16 0.010 0.003 20.47 8.2.15 0.004 0.004 24.18 8.2.14 0.003 0.005 24.66 8.2.13 0.009 0.000 21.12 8.2.12 0.007 0.011 26.35 8.2.11 0.009 0.000 22.26 8.2.10 0.009 0.003 18.03 8.2.9 0.000 0.008 19.22 8.2.8 0.003 0.006 18.05 8.2.7 0.006 0.003 17.88 8.2.6 0.005 0.003 17.92 8.2.5 0.000 0.008 18.10 8.2.4 0.000 0.008 20.73 8.2.3 0.003 0.005 21.05 8.2.2 0.008 0.000 18.10 8.2.1 0.000 0.008 18.26 8.2.0 0.004 0.004 18.13 8.1.28 0.015 0.000 25.92 8.1.27 0.004 0.004 22.32 8.1.26 0.008 0.000 26.35 8.1.25 0.000 0.007 28.09 8.1.24 0.006 0.003 23.84 8.1.23 0.003 0.010 22.25 8.1.22 0.004 0.004 17.78 8.1.21 0.005 0.003 18.77 8.1.20 0.010 0.000 17.60 8.1.19 0.005 0.003 17.48 8.1.18 0.000 0.008 18.10 8.1.17 0.000 0.007 19.15 8.1.16 0.000 0.007 19.16 8.1.15 0.000 0.008 20.68 8.1.14 0.003 0.007 19.66 8.1.13 0.000 0.007 19.06 8.1.12 0.004 0.004 17.42 8.1.11 0.000 0.008 17.49 8.1.10 0.008 0.000 17.45 8.1.9 0.003 0.005 17.45 8.1.8 0.003 0.006 17.60 8.1.7 0.005 0.003 17.54 8.1.6 0.004 0.004 17.76 8.1.5 0.004 0.004 17.59 8.1.4 0.005 0.003 17.53 8.1.3 0.000 0.008 17.73 8.1.2 0.000 0.008 17.86 8.1.1 0.009 0.000 17.63 8.1.0 0.005 0.002 17.64 8.0.30 0.003 0.006 18.77 8.0.29 0.004 0.004 17.00 8.0.28 0.004 0.004 18.60 8.0.27 0.007 0.000 17.32 8.0.26 0.000 0.007 16.97 8.0.25 0.002 0.005 17.21 8.0.24 0.000 0.007 17.17 8.0.23 0.004 0.004 17.18 8.0.22 0.004 0.004 17.08 8.0.21 0.004 0.004 17.19 8.0.20 0.000 0.007 17.05 8.0.19 0.006 0.003 17.13 8.0.18 0.004 0.004 17.14 8.0.17 0.000 0.007 17.09 8.0.16 0.000 0.009 17.10 8.0.15 0.000 0.007 17.07 8.0.14 0.000 0.007 16.95 8.0.13 0.003 0.003 13.52 8.0.12 0.004 0.004 16.97 8.0.11 0.004 0.004 17.00 8.0.10 0.005 0.002 17.05 8.0.9 0.004 0.004 16.90 8.0.8 0.004 0.018 17.09 8.0.7 0.002 0.005 16.94 8.0.6 0.003 0.005 17.13 8.0.5 0.004 0.004 16.91 8.0.3 0.008 0.010 17.23 8.0.2 0.011 0.008 17.41 8.0.1 0.005 0.002 17.08 8.0.0 0.003 0.015 17.01 7.4.33 0.000 0.006 15.55 7.4.32 0.007 0.000 16.68 7.4.30 0.004 0.004 16.69 7.4.29 0.005 0.003 16.60 7.4.28 0.006 0.003 16.54 7.4.27 0.000 0.007 16.75 7.4.26 0.004 0.004 16.64 7.4.25 0.000 0.008 16.57 7.4.24 0.000 0.007 16.61 7.4.23 0.008 0.000 16.52 7.4.22 0.009 0.016 16.80 7.4.21 0.008 0.008 16.63 7.4.20 0.004 0.004 16.60 7.4.16 0.005 0.012 16.75 7.4.15 0.020 0.006 17.40 7.4.14 0.005 0.013 17.86 7.4.13 0.014 0.003 16.54 7.4.12 0.010 0.012 16.60 7.3.33 0.005 0.000 13.30 7.3.32 0.003 0.003 13.30 7.3.31 0.007 0.000 16.41 7.3.30 0.000 0.007 16.39 7.3.29 0.010 0.005 16.40 7.3.28 0.009 0.009 16.41 7.3.27 0.010 0.007 17.40 7.3.26 0.009 0.013 16.51 7.3.25 0.012 0.006 16.36 7.3.24 0.009 0.010 16.44 7.1.6 0.020 0.010 34.96
preferences:dark mode live preview
63.35 ms | 401 KiB | 5 Q