



	
	    
    ALTER TABLE `invoice_data_current_payments` 
ADD COLUMN `created_at` DATETIME NULL AFTER `status_idc`,
ADD COLUMN `updated_at` DATETIME NULL AFTER `created_at`;

INSERT INTO `fr_tomasmoro`.`payment_button` (`serial_pbn`, `serial_crr`, `merchant_name_pbn`, `service_pbn`, `path_logo`, `path_terms_conditions`, `url_return`, `type_pbn`, `payphone_url_api`, `partner_pbn`) VALUES ('22', '47', 'DEHUCI corriente 1 de 10', 'RUBROS NO ACADÉMICOS CORRIENTE 1 DE 10', 'https://learnbox.tomasmoro.k12.ec/learnbox/img/payment_button/payphone.png', 'files/TCDEHUCI.txt', 'https://demo.learnbox.com.ec/franklin/RUTADEMIC/DEV/laravel/public/schoolsupliespayments/return', 'PAYPHONE', 'https://pay.payphonetodoesposible.com/api/button/', 'Payphone');


INSERT INTO `fr_tomasmoro2022`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('17', '3', '5', '1', 'currentDefered', 'ACTIVE');
INSERT INTO `fr_tomasmoro2022`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('18', '3', '16', '2', 'current', 'ACTIVE');
INSERT INTO `fr_tomasmoro2022`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('19', '3', '11', '1', 'currentDefered', 'ACTIVE');
INSERT INTO `fr_tomasmoro2022`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('20', '3', '13', '2', 'current', 'ACTIVE');
UPDATE `fr_tomasmoro2022`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='11';
UPDATE `fr_tomasmoro2022`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='12';
UPDATE `fr_tomasmoro2022`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='13';
UPDATE `fr_tomasmoro2022`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='14';
UPDATE `fr_tomasmoro2022`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='15';

INSERT INTO `fr_tomasmoro`.`payment_button` (`serial_pbn`, `serial_crr`, `merchant_name_pbn`, `service_pbn`, `path_logo`, `url_web_page_bank`, `path_terms_conditions`, `info_pbn`, `vpos_url_pbn`, `url_return`, `login`, `trankey`, `type_pbn`, `partner_pbn`) VALUES ('23', '47', 'Dehuci Corriente 1 de 10 - Sitio Web', 'RUBROS NO ACADÉMICOS CORREINTE', 'https://static.placetopay.com/placetopay-logo.svg', 'https://placetopay.ec/', 'files/TCDEHUCI.txt', '<h4>Placetopay</h>', 'https://checkout-test.placetopay.ec/', 'https://demo.learnbox.com.ec/franklin/RUTADEMIC/DEV/modules/registration_process_wizard/payment_buttons/placetopay/fReturn', 'db18a33659c550b081c0030b32f43956', 'yn57OGpDFmZlNZsl', 'WALLET_P2P', 'Placetopay');

UPDATE `fr_tomasmoro2022`.`payment_button` SET `merchant_name_pbn`='U.E. Tomas Moro - Alimentación - Sitio Web', `service_pbn`='PAGOS EN DE ALIMENTACIÓN' WHERE `serial_pbn`='23';
INSERT INTO `fr_tomasmoro2022`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('23', '4', '23', '2', 'current', 'ACTIVE');

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('850', '156', 'Pago de útiles', 'laravel/public/schoolsupliespayments', '135.6', 'LOCKABLE');
INSERT INTO `dates_to_current_payments` (`serial_dts`, `serial_pcg`, `serial_scy`, `month_to_pay_dts`, `month_dts`, `start_date_dts`, `end_date_dts`, `month_to_check_paid_dts`, `status_dts`) VALUES ('25', '2', '12', '2022-09-01', 'Sep', '2022-09-01', '2023-07-31', '2022-09-01', 'ACTIVE');
INSERT INTO `payment_button` (`serial_pbn`, `serial_crr`, `merchant_name_pbn`, `service_pbn`, `path_logo`, `url_web_page_bank`, `path_terms_conditions`, `info_pbn`, `vpos_url_pbn`, `url_return`, `login`, `trankey`, `type_pbn`, `partner_pbn`) VALUES ('21', '47', 'Dehuci Corriente 1 de 10 - Sitio Web', 'RUBROS DE ÚTILES ', 'https://static.placetopay.com/placetopay-logo.svg', 'https://placetopay.ec/', 'files/TCDEHUCI.txt', '<h4>Placetopay</h>', 'https://checkout-test.placetopay.ec/', 'https://demo.learnbox.com.ec/franklin/RUTADEMIC/DEV/laravel/public/schoolsupliespayments/return', 'db18a33659c550b081c0030b32f43956', 'yn57OGpDFmZlNZsl', 'WALLET_P2P', 'Placetopay');
INSERT INTO `payment_button` (`serial_pbn`, `serial_crr`, `merchant_name_pbn`, `service_pbn`, `path_logo`, `path_terms_conditions`, `url_return`, `login`, `token_payphone_pbn`, `type_pbn`, `payphone_url_api`, `partner_pbn`) VALUES ('22', '47', 'DEHUCI corriente 1 de 10', 'RUBROS DE ÚTILES ', 'https://learnbox.tomasmoro.k12.ec/learnbox/img/payment_button/payphone.png', 'files/TCDEHUCI.txt', 'https://demo.learnbox.com.ec/franklin/RUTADEMIC/DEV/laravel/public/schoolsupliespayments/returnpayphone', '4e98ed80-ed33-456a-9844-00ded18e8ead', 'A0V3CPGHhEBrJqeMt4S_7iht7eaxMxbMpNsurbhA-Bjp5ZO5x3WGrpWFKShOMbgbjypEf9CR5w9A6E-qJAXyO5-tBg__hK7FOgufx6EV06mCZTll9g3bfQtZGE-Kb8eQMCKpFus_1bzDw2tfbegl1UUbLA3Gpxs_45uesRLarL23oMPf0hO6529jgbbn-m_gR6VIkzG9HHo-0HdcUO4PtKck-t8V2HM8I40ipJnPgKvZef9U5D9HEMjG40LgTnrE4PuaYx1fuWGCOlacnGCeqfXeeaHPumjSs3xgD6p43aIuttZNSRuUT4h5l8pbJQXb08M6i6TeeRhhRBCVAUfGjLXVAzQ', 'PAYPHONE', 'https://pay.payphonetodoesposible.com/api/button/', 'Payphone');



ALTER TABLE `group_payment_button` 
CHANGE COLUMN `type_gpb` `type_gpb` ENUM('currentDefered', 'current', 'register', 'CURRENTPAYMENTS', 'FEEDINGPAYMENTS', 'SCHOOL_SUPPLIES') NULL DEFAULT 'currentDefered' ;
INSERT INTO `demoboton`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('16', '2', '21', NULL, 'SCHOOL_SUPPLIES', 'ACTIVE');
INSERT INTO `demoboton`.`group_payment_button` (`serial_gpb`, `serial_pcg`, `serial_pbn`, `serial_pmw`, `type_gpb`, `status_gpb`) VALUES ('17', '2', '22', NULL, 'SCHOOL_SUPPLIES', 'ACTIVE');
UPDATE `demoboton`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='11';
UPDATE `demoboton`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='12';
UPDATE `demoboton`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='13';
UPDATE `demoboton`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='14';
UPDATE `demoboton`.`group_payment_button` SET `serial_pmw`=NULL WHERE `serial_gpb`='15';


CREATE TABLE `invoice_data_current_payments` (
  `serial_idc` INT NOT NULL AUTO_INCREMENT,
  `serial_cdf` INT NULL,
  `identification_type_idc` VARCHAR(45) NULL,
  `business_name_idc` VARCHAR(300) NULL,
  `id_idc` VARCHAR(45) NULL,
  `address_idc` VARCHAR(45) NULL,
  `phone_paying_idc` VARCHAR(45) NULL,
  `email_paying_idc` VARCHAR(45) NULL,
  `status_idc` ENUM('ACTIVE', 'INACTIVE') NULL,
  PRIMARY KEY (`serial_idc`),
  INDEX `fk_idf_cdf_idx` (`serial_cdf` ASC),
  CONSTRAINT `fk_idc_cdf`
    FOREIGN KEY (`serial_cdf`)
    REFERENCES `current_deferred` (`serial_cdf`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
	
	
	ALTER TABLE `invoice_data_current_payments` 
ADD COLUMN `created_at` DATETIME NULL AFTER `status_idc`,
ADD COLUMN `updated_at` DATETIME NULL AFTER `created_at`;

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('850', '156', 'Pago de útiles', 'laravel/public/schoolsupliespayments', '135.60', 'LOCKABLE');
