01/06/2016
Modul Xml SERVER sender Trigger MSSQL gabungan dengan Fix sms Paksa sender server OTOMAX posting terdahulu
modul ini harus di sertakan php server dan aplikasi Php dengan system xml soap , bagi yang membutuhkan silahkan kontak kami :)
BEGIN
BEGIN
declare varchar(6)
Declare varchar(2)
Declare varchar(20)
declare int
declare int
declare varchar(1)
declare varchar(100)
declare varchar(100)
SELECT
=case when ISNUMERIC(dbo.auto_respon.awalan )=1 THEN dbo.auto_respon.awalan else 0 end ,
=dbo.auto_respon.masuk_cs
FROM
dbo.auto_respon
WHERE dbo.auto_respon.kata_kunci_1='SETTING' and dbo.auto_respon.kata_kunci_2 ='SETTING' and balasan='PaksaKirimUlangOutboxGagal'
SELECT =kode ,=status ,=kode_reseller , =tipe_penerima, =penerima FROM Inserted
if =40
BEGIN--3
if NULLIF( ,'')''
begin--2
if =1
begin--1
UPDATE [otomax].[dbo].[outbox] SET [kode_terminal]='1', [status]='0',[tgl_entri]= (getdate()) ,[tgl_status]= (getdate()) ,[kode_modul]=NULL , [modul_proses]='',[smsdiulang]=smsdiulang+1 WHERE ([kode]=)
end--1
end--2
END--3
SELECT =kode ,=status ,=kode_reseller, =tipe_penerima FROM Inserted
SELECT =pengirim from dbo.pengirim where dbo.pengirim.kode_reseller= and tipe_pengirim='' and kirim_info=1
if =0
BEGIN
if NULLIF( ,'')'' and =''
begin
UPDATE [otomax].[dbo].[outbox] SET [penerima]=, [status]='2' WHERE ([kode]=)
DECLARE
INT,
VARCHAR(8000),
INT,
VARCHAR(200)
EXEC sp_OACreate 'MSXML2.ServerXMLHTTP', OUTPUT
EXEC sp_OAMethod , 'open',NULL, 'POST',
EXEC sp_OAMethod , 'send'
EXEC sp_OAMethod , 'responseText', OUTPUT
EXEC sp_OAMethod , 'Status', OUTPUT
EXEC sp_OAMethod , 'StatusText', OUTPUT
EXEC sp_OADestroy
IF =200 AND ='OK' AND ='OK'
BEGIN
UPDATE [otomax].[dbo].[outbox] SET [penerima]=, [status]='20' ,[tgl_status]= (getdate()) ,[smsdiulang]=smsdiulang+1 WHERE ([kode]=)
END
end
END
END
END
==================================
Fawwaz Pulsa,Stefanus Widjiwaluyo,Lawet Tronik,Ali Shohib,Triple En En En, Cecep Ircham, Delta Anugrah, Den Ruri, Didik Siswanto, Fauzul Adhim