multipart

CREATE DEFINER=`root`@`localhost` PROCEDURE `p_inbox`(IN `txt` VARCHAR(1000), IN `numb` vARCHAR(50))
BEGIN
DECLARE x INT;
DECLARE jmlpsn INT;
DECLARE jmlpsn1 INT;
DECLARE jmlcr INT;
DECLARE pecah INT;
DECLARE newID INT;
DECLARE tex varchar(255);
DECLARE udh VARCHAR(255);
DECLARE msg VARCHAR(1000);
set x = 1;
SET udh ='';
SET pecah =0;
#mengetahui panjang karakter
SET jmlcr = CHAR_LENGTH(txt);
#membagi panjang text dengan 153 karakter dan di bulatkan
SET jmlpsn = ceil(jmlcr / 153);
SET newID = (SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'evanta' AND   TABLE_NAME   = 'outbox');
while x<= jmlpsn do


SET udh = concat('050003A7','0',jmlpsn,'0',tex);
SET msg = SUBSTR(txt,pecah+1,(153+pecah));
if x = 1 then
INSERT INTO outbox (DestinationNumber, UDH, TextDecoded, ID, MultiPart, CreatorID) VALUES (numb, udh, msg, newID, 'true', 'Gammu');
else
INSERT INTO outbox_multipart(UDH, TextDecoded, ID, SequencePosition) VALUES (udh, msg, newID, x);
end if;
SET pecah = pecah+153;
SET x = x+1;
#select msg;
end while;
#select jmlpsn;
END