HOW TO SEND MESSAGE USING PHP AND REST SMS APK
HOW TO SEND MESSAGE USING PHP AND REST SMS APK BASIC CODES FOR Beginners :)
STEP 1: USE OR DOWNLOAD SUBLIME or any kind of tet editor na pwede kay PHP
STEP 2: USE OR DOWNLOAD XAMPP OR WAMPP CONTROL PANEL
STEP 3: USE OR DOWNLOAD REST SMS APK at this link:
Download the file...
STEP 4: CONNECT YOUR LAPTOP OR DESKTOP INTO YOUR ROUTER OR MODEM AND THEN YOUR CELLPHONE AFTER THAT OPEN THE REST SMS GATEWAY APK
STEP 5: ENCODE THIS INTO YOUR TEXT EDITOR AND THEN RUN THE PROGRAM make sure the ip address of your cellphone is same with the ip address below ..
PLEASE LIKE OUR PAGE: https://www.facebook.com/Educatorcode
How to send Message using NETBEANS and REST SMS APK
create a form like this :
type the codes in the button of SEND MESSAGE
apk rest sms link: Download the file...
LIKE OUR PAGE IN FACEBOOK: https://www.facebook.com/Educatorcode
Flat Ui Design in JAVA Netbeans Free Source Code
Download the source code after a seconds
.. DOWNLOAD THE FILE
Please Be Patients
the Zip password is: crazydev-ph
please dont
Dont Forget to Like our Fan page: https://www.facebook.com/educatorcode/ for more source code free to come.
and then follow us in gmail: https://plus.google.com/118054808074315176404
please Comment ..
Auto Enter and Read in Notepad using PHP Nfc Device
Copy and Paste this code to your Sublime or Notepad name the page as index.php
<!-- this is for barcode scanner not tab-->
<script language="javascript">
function DoCheckLength(aTextBox) {
if (aTextBox.maxLength - aTextBox.value.length<=0) {
document.theForm.submit();
//beep.play();
}
}
</script>
<form class="form-horizontal style-form" NAME="theForm" action="s_homepage.php" method="get" >
<label for="code">TAP YOUR ID</label>
<input class="form-control" type="text" onkeyup="return(DoCheckLength(this));" ID="firstTextBox" name="idno" autofocus placeholder="Swipe your ID" autocomplete="off" >
</form>
Then make new page and name as s_homepage.php and paste the code
<?php
$idno1 = ($_GET['idno']);
echo "your ID Number is: ".$idno1." ";
?>
Install the drivers of NFC ACR122U-9 ..
Download this command to read your card ..
Download the file...
Reminder: before you run the command tap your card first and then open the application.
Dont Forget to Like our Fan page: https://www.facebook.com/educatorcode/ for more source code free to come.
and then follow us in gmail: https://plus.google.com/118054808074315176404
please Comment ..
How to send message using Sms gateway App orange API
How to send message using SMSgateway Orange and broadband
Pocket Wifi API
Before I discuss or teach this kind of sending message using
GSM module or broadband pocket wifi please like our page and share to your wall
as a support in my blog ..
Lets start..
Step 1 : Download the SMS Gateway App on Google app store in
your cell phone . Make sure you have a sim card and in your cellphone to test
what we do in this tutorial.
Link of smsgateway: https://play.google.com/store/apps/details?id=fr.nope.smsgateway&hl=en
Interface
To test you need sim card smart, globe, sun or any sim card
that you have make sure your sim have a load.
Step 2: Open your laptop and Broadband Pocket wifi. Connect your laptop wifi to your Pocket Wifi
no worries if your Pocket wifi don’t have sim its ok. Connect also your
cellphone to your pocket Wifi I suggest this device.
Step 3: To test the text open the smsgateway orange app in
your cellphone click the start and insert the ip address of your phone.
How to see the ip address of your phone if you connect the
pocket wifi?
Go to settings click wifi after you click the wifi name the
details of ip address Is there ..
After all the step
Insert this text to your browser chrome or mozila.
That’s all please
don’t forget to like our page and share to your wall .
Thanks don’t forget also to comment in my blog …
dont forget to like our page :
please comment and share my blog for more source code to come :)
IONIC SOURCE CODE MOBILE APP WITH ANGULAR JS
FREE IONIC SOURCE CODE LIST
How to run the ionic framework with angular JS?
Step 1: Download the NODE.JS at this link : https://nodejs.org/en/
Step 2: click the window button and find node js terminal command
and the type this code
ionic start myApp blank
wait until the command is ok and click yes to download all component.
the cmd command ask you this Install the free Ionic Pro SDK and connect your app(Y/n)? click Y.
the Cmd node js command will ask you if you will proceed click Y and then enter..
type this CD mysamples
type this in npm : ionic serve to proceed in the program code..
type the localhost:8100 in your browser
This is the final output of the program
Download the source code and copy the contain folder
copy and replace the folder in source code ..
This is the final output of the program
Source code: DOWNLOAD ME!
Follow me in my Google Circle: https://plus.google.com/118054808074315176404/
Dont forget to comment thanks :)
Student Text Notification System in php
Figure 1.1 This area input the number of student you can use any device reader to read the number like barcode reader, Magnetic Device Reader, Swiper
Figure 1.2 In this area you can now login your username and password in database the default username password is this
Username: admin
Password: admin
Figure 1.3 this is the interface of the backend panel
Figure 1.4 Adding Student Information
Figure 1.5 Add Nationality
Figure 1.6 Add Announcement
Figure 1.7 View the history of all student
This is the final output of the system ...
Please like and share or comment
LIKE OUR PAGE: https://www.facebook.com/Educatorcode/
FOLLOW US IN GOOGLE : https://plus.google.com/118054808074315176404/op/followers
DOWNLOAD THE SOURCE CODE: DOWNLOAD ME
DONT FORGET TO COMMENT IN MY BLOG THANKS :) ENJOY CODING ..for any question please leave a comment ..
How to Open a Cam in Netbeans using OpenCV source code
Download the Source Code at this link: DOWNLOAD SOURCE!
Go to Properties
Click the Run and paste this to VM Option: -Djava.library.path="C:\opencv\build\java\x86"
Please Dont Forget to comment in the blog thanks
Follow me at Google Circle: https://plus.google.com/118054808074315176404/op/followers
Like Us on Facebook: https://www.facebook.com/Educatorcode/
A SIMPLE INVENTORY SYSTEM w/ POS
MAIN PAGE ..
Before you download the source code please
LIKE OUR PAGE: https://www.facebook.com/Educatorcode/
FOLLOW US IN GOOGLE CIRCLE: https://plus.google.com/118054808074315176404
and please comment and share
THIS IS A LOGIN AREA 1.1
TABLE AREA
STATISTIC AREA
ADD ITEM
ADD TABLE
ADD ITEM
IF NORMAL CRITICAL OR OUT OF STOCK
SALES REPORT
AS A SIGN OF THANK YOU FOR THIS SYSTEM PLEASE SHARE AND LIKE OUR PAGE IN FACEBOOK TO UPDATE YOU FOR MORE SOURCE CODE TO COME
THIS IS THE PHP SOURCE CODE LINK:
WAIT FOR TO VIEW THE LINK
Download the file...
TO RUN THE PROGRAM PHP SYSTEM PLEASE PASTE THE SQL CODE
Open your wampp or Xampp and start the apache and MySQL panel.
In Browser type the localhost/phpmyadmin.
After that create database name: side_db
Paste this in SQL code
Admin Code SQL
CREATE TABLE IF NOT EXISTS `admin` (
`admin_id`
tinyint(5) NOT NULL AUTO_INCREMENT,
`name`
varchar(255) DEFAULT NULL,
`username`
varchar(10) NOT NULL,
`password`
varchar(10) NOT NULL,
`date` datetime
NOT NULL,
PRIMARY KEY
(`admin_id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`admin_id`, `name`, `username`,
`password`, `date`) VALUES
(1, 'Philip Prado', 'admin', 'admin', '2016-11-23
00:00:00'),
(2, 'Jojo', 'jojo', 'jojo', '2017-08-05 14:55:28');
Module for Log Report
CREATE TABLE IF NOT EXISTS `logreport` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`idno` int(255)
DEFAULT NULL,
`name`
varchar(255) DEFAULT NULL,
`log_in` datetime
DEFAULT NULL,
`log_out`
datetime DEFAULT NULL,
`date` date
DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Dumping data for table `logreport`
--
INSERT INTO `logreport` (`id`, `idno`, `name`, `log_in`,
`log_out`, `date`) VALUES
(24, 1, 'Philip Prado', '2017-07-10 16:32:52', NULL,
'2017-07-10'),
(25, 1, 'Philip Prado', '2017-07-10 16:33:30', NULL,
'2017-07-10'),
(26, 1, 'Philip Prado', '2017-07-10 16:33:44', NULL,
'2017-07-10'),
(27, 1, 'Philip Prado', '2017-07-10 16:34:41', NULL,
'2017-07-10'),
(28, 1, 'Philip Prado', '2017-07-10 18:09:39', NULL,
'2017-07-10'),
(29, 1, 'Philip Prado', '2017-07-11 13:58:46', NULL,
'2017-07-11');
Create Main admin
CREATE TABLE IF NOT EXISTS `main_admin` (
`main_admin`
int(255) NOT NULL AUTO_INCREMENT,
`name`
varchar(255) DEFAULT NULL,
`username`
varchar(255) DEFAULT NULL,
`password`
varchar(255) DEFAULT NULL,
`date` date
DEFAULT NULL,
PRIMARY KEY
(`main_admin`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `main_admin`
--
INSERT INTO `main_admin` (`main_admin`, `name`,
`username`, `password`, `date`) VALUES
(1, 'philip prado', 'user', 'user', '2017-07-11');
Module for members
admin
CREATE TABLE IF NOT EXISTS `members` (
`member_id`
int(11) NOT NULL AUTO_INCREMENT,
`UserName`
varchar(200) NOT NULL,
`Password`
varchar(200) NOT NULL,
`FirstName`
varchar(200) NOT NULL,
`LastName`
varchar(200) NOT NULL,
PRIMARY KEY
(`member_id`)
) ENGINE=MyISAM
DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`member_id`, `UserName`,
`Password`, `FirstName`, `LastName`) VALUES
(1, 'js', 'js', 'john', 'smith'),
(2, 'jk', 'jk', 'john kevin', 'lorayna'),
(5, 'admin', 'admin', 'john', 'smith');
Per Bucket Module
CREATE TABLE IF NOT EXISTS `per_bucket` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`per_bucket`
varchar(255) DEFAULT NULL,
`orig_item`
int(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `per_bucket`
--
INSERT INTO `per_bucket` (`id`, `per_bucket`,
`orig_item`) VALUES
(1, 'BUCKET', 10),
(2, 'BANYERA', 20);
Per Transaction
CREATE TABLE IF NOT EXISTS `per_transaction` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`table_transaction` varchar(255) DEFAULT NULL,
`sell_price` varchar(255)
DEFAULT NULL,
`date` date
DEFAULT NULL,
`assist_by`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `per_transaction`
--
INSERT INTO `per_transaction` (`id`, `table_transaction`,
`sell_price`, `date`, `assist_by`) VALUES
(2, '3', '600', '2017-09-09', NULL),
(3, '5', '150', '2017-09-09', NULL),
(4, '5', '366', '2017-09-09', NULL),
(5, '1', '60', '2017-09-11', 'john smith');
Module for drinks
CREATE TABLE IF NOT EXISTS `product_mix` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`product_mix`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `product_mix`
--
INSERT INTO `product_mix` (`id`, `product_mix`) VALUES
(1, 'Beer'),
(2, 'Hard liquor '),
(3, 'Grilled');
Module for start
me
CREATE TABLE IF NOT EXISTS `startme` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`startme`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `startme`
--
INSERT INTO `startme` (`id`, `startme`) VALUES
(1, '10');
Module for stat
admin
CREATE TABLE IF NOT EXISTS `stat_admin` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`from`
varchar(255) DEFAULT NULL,
`to` varchar(255)
DEFAULT NULL,
`user`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `stat_admin`
--
INSERT INTO `stat_admin` (`id`, `from`, `to`, `user`)
VALUES
(1, '2017-07-10', '2017-07-11', 'admin'),
(2, '2017-07-10', '2017-07-12', NULL),
(3, '2017-07-10', '2017-07-15', NULL),
(4, '2017-07-10', '2017-07-11', NULL),
(5, '2017-07-01', '2017-07-31', NULL),
(6, '2017-07-17', '2017-07-21', NULL),
(7, '2017-07-08', '2017-07-20', NULL),
(8, '2017-07-01', '2017-07-20', NULL),
(9, '2017-07-20', '2017-07-21', NULL),
(10, '2017-07-17', '2017-07-21', NULL),
(11, '2017-07-08', '2017-07-21', NULL),
(12, '2017-07-01', '2017-07-22', NULL),
(13, '2017-07-24', '2017-07-25', NULL),
(14, '2017-07-25', '2017-07-26', NULL),
(15, '2017-07-25', '2017-07-25', NULL),
(16, '2017-07-25', '2017-07-26', NULL),
(17, '2017-07-24', '2017-07-28', NULL),
(18, '2017-07-24', '2017-07-28', NULL),
(19, '2017-07-24', '2017-07-27', NULL),
(20, '2017-07-25', '2017-07-29', NULL),
(21, '2017-07-25', '2017-07-29', NULL),
(22, '2017-07-25', '2017-07-29', NULL),
(23, '2017-07-25', '2017-07-29', NULL),
(24, '2017-07-24', '2017-07-29', NULL),
(25, '2017-08-03', '2017-08-03', NULL),
(26, '2017-08-03', '2017-08-03', NULL),
(27, '2017-08-05', '2017-08-05', NULL),
(28, '2017-08-05', '2017-08-05', NULL),
(29, '2017-08-05', '2017-08-06', NULL),
(30, '2017-09-08', '2017-09-09', NULL);
Module for Stock
in
CREATE TABLE IF NOT EXISTS `stock_in` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`stockno`
varchar(255) DEFAULT NULL,
`item_name`
varchar(255) DEFAULT NULL,
`h_beggining`
int(255) NOT NULL,
`beggining`
int(255) NOT NULL,
`orig_price`
double NOT NULL,
`sell_price`
double NOT NULL,
`p_status`
varchar(255) DEFAULT NULL,
`per_bucket`
varchar(255) DEFAULT NULL,
`item_number`
varchar(255) DEFAULT NULL,
`date` date NOT
NULL,
`date_update`
date DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `stock_in`
--
INSERT INTO `stock_in` (`id`, `stockno`, `item_name`,
`h_beggining`, `beggining`, `orig_price`, `sell_price`, `p_status`,
`per_bucket`, `item_number`, `date`, `date_update`) VALUES
(1, '258', 'San meg', 4, 7, 30, 30, '1', '280', '6',
'2017-08-05', NULL),
(2, '6998996', 'Empe lights', 0, 3, 30, 60, '2', '350',
'2', '2017-08-05', NULL),
(3, '96389', 'BANYERA', 0, 4, 35, 60, '3', '400', '7',
'2017-08-05', NULL),
(4, '8963', 'SISIG inasal', 0, 21, 25, 36, '3', NULL,
NULL, '2017-08-05', NULL),
(5, '56988999', 'BULALO', 0, 10, 20, 30, '3', NULL, NULL,
'2017-09-11', NULL);
Module for stock
out
CREATE TABLE IF NOT EXISTS `stock_out` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`idno` int(255)
DEFAULT NULL,
`stockno`
varchar(255) DEFAULT NULL,
`item_name`
varchar(255) DEFAULT NULL,
`quantity`
int(255) DEFAULT NULL,
`orig_price`
double DEFAULT NULL,
`sell_price`
double DEFAULT NULL,
`status` int(255)
NOT NULL,
`date` date
DEFAULT NULL,
`user`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `stock_out`
--
INSERT INTO `stock_out` (`id`, `idno`, `stockno`,
`item_name`, `quantity`, `orig_price`, `sell_price`, `status`, `date`, `user`)
VALUES
(30, 1, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-11', '5');
A Sample for stock
out
CREATE TABLE IF NOT EXISTS `stock_out_report` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`idno` int(255)
DEFAULT NULL,
`stockno`
varchar(255) DEFAULT NULL,
`item_name`
varchar(255) DEFAULT NULL,
`quantity`
int(255) DEFAULT NULL,
`orig_price`
double DEFAULT NULL,
`sell_price`
double DEFAULT NULL,
`status` int(255)
DEFAULT NULL,
`date` date
DEFAULT NULL,
`user`
varchar(255) DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `stock_out_report`
--
INSERT INTO `stock_out_report` (`id`, `idno`, `stockno`,
`item_name`, `quantity`, `orig_price`, `sell_price`, `status`, `date`, `user`)
VALUES
(1, 1, '258', 'San meg', 3, 30, 90, 1, '2017-09-08',
'5'),
(2, 1, '6998996', 'Empe lights', 2, 30, 120, 2,
'2017-09-08', '5'),
(3, 1, '8963', 'SISIG inasal', 5, 25, 180, 3,
'2017-09-08', '5'),
(4, 1, '6998996', 'Empe lights', 6, 30, 360, 2,
'2017-09-08', '5'),
(6, 1, '96389', 'BANYERA', 1, 35, 60, 3, '2017-09-08',
'5'),
(7, 1, '96389', 'BANYERA', 2, 35, 120, 3, '2017-09-08',
'5'),
(8, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09',
'5'),
(9, 3, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(10, 3, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(11, 3, '8963', 'SISIG inasal', 1, 25, 36, 3,
'2017-09-09', '5'),
(12, 6, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(13, 6, '258', 'San meg', 1, 30, 30, 1, '2017-09-09',
'5'),
(14, 3, '258', 'San meg', 2, 30, 60, 1, '2017-09-09',
'5'),
(15, 3, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(16, 3, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(17, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09',
'5'),
(18, 3, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(19, 3, '258', 'San meg', 1, 30, 30, 1, '2017-09-09', '5'),
(20, 3, '6998996', 'Empe lights', 2, 30, 120, 2,
'2017-09-09', '5'),
(21, 3, '96389', 'BANYERA', 1, 35, 60, 3, '2017-09-09',
'5'),
(22, 3, '6998996', 'Empe lights', 10, 30, 600, 2,
'2017-09-09', '5'),
(23, 5, '258', 'San meg', 3, 30, 90, 1, '2017-09-09',
'5'),
(24, 5, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-09', '5'),
(25, 5, '258', 'San meg', 10, 30, 300, 1, '2017-09-09',
'5'),
(26, 5, '258', 'San meg', 1, 30, 30, 1, '2017-09-09',
'5'),
(27, 5, '8963', 'SISIG inasal', 1, 25, 36, 3, '2017-09-09',
'5'),
(29, 1, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-11', '5'),
(30, 1, '6998996', 'Empe lights', 1, 30, 60, 2,
'2017-09-11', '5');
Module for table
Me
CREATE TABLE IF NOT EXISTS `tablename` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`tablename`
varchar(255) DEFAULT NULL,
`total`
varchar(255) DEFAULT NULL,
`status`
varchar(255) DEFAULT NULL,
`assist_by`
varchar(255) DEFAULT NULL,
`date` date
DEFAULT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tablename`
--
INSERT INTO `tablename` (`id`, `tablename`, `total`,
`status`, `assist_by`, `date`) VALUES
(1, 'TABLE 1', '60', 'occupy', 'john', '2017-07-05'),
(3, 'TABLE 3', '', 'vacant', 'john', '2017-07-05'),
(5, 'TABLE 2', '', 'vacant', 'john', '0000-00-00'),
(6, 'TABLE 4', '', 'vacant', 'john', '0000-00-00'),
(7, 'TABLE 5', '', 'vacant', '', '0000-00-00');
Table for why
avoid?
CREATE TABLE IF NOT EXISTS `whyvoid` (
`id` int(255) NOT
NULL AUTO_INCREMENT,
`tablename`
varchar(255) DEFAULT NULL,
`whyvoid` varchar(255) DEFAULT NULL,
`clerk_ass`
varchar(255) DEFAULT NULL,
`date` date NOT
NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `whyvoid`
--
INSERT INTO `whyvoid` (`id`, `tablename`, `whyvoid`,
`clerk_ass`, `date`) VALUES
(1, '7', '', NULL, '0000-00-00'),
(2, '7', '', NULL, '0000-00-00'),
(3, '7', '', NULL, '0000-00-00'),
(4, '7', '', NULL, '0000-00-00'),
(5, '7', '', NULL, '0000-00-00'),
(6, '7', '', NULL, '0000-00-00'),
(7, '7', '', NULL, '0000-00-00'),
(8, '7', '', NULL, '0000-00-00'),
(9, '7', '', NULL, '0000-00-00'),
(10, '7', '', NULL, '0000-00-00'),
(11, '7', '', NULL, '0000-00-00'),
(12, '7', '', NULL, '0000-00-00'),
(13, '7', '', NULL, '0000-00-00'),
(14, '7', '', NULL, '0000-00-00');
