Web Dialer dial plan

[ivr]

exten=>s,1,Answer()

same=>n,Wait(1)

same=>n,Read(CONFIRM,${audio},1)

same=>n,System(mysql --user=root --password='1112' dialer -e 'UPDATE `list` SET `keypressed`="${CONFIRM}" WHERE phone="${telephone}" and list_cp="${cp}"')

same=> n,ExecIf($["${CONFIRM}"= "${cp_dnc_key}"&&"${CONFIRM}"!=""]?system(mysql --user=root --password='1112' dialer -e "INSERT INTO dnc (dnc_phone) values ("${telephone}")"))

same=> n,ExecIf($["${CONFIRM}"= "${key1}"]?Dial(SIP/${transf_dest}@${carrier},25))

same=> n,ExecIf($["${CONFIRM}"= "${key2}"]?Dial(SIP/${transf_dest2}@${carrier},25))

exten=>h,1,System(mysql --user=root --password='1112' dialer -e 'UPDATE `list` SET `call_dispo`="${CDR(disposition)}" WHERE phone="${telephone}" and list_cp="${cp}"')

exten=>h,2,System(mysql --user=root --password='1112' dialer -e 'UPDATE `list` SET `calldate`="${STRFTIME(${EPOCH},,%d-%m-%Y-%H:%M:%S)}" WHERE phone="${telephone}" and list_cp="${cp}"')

;;query reserved future use

;;;exten=>h,3,ExecIf($["${CONFIRM}"= "9"]?System(mysql --user=root --password='1112' dialer -e "delete  from dnc where dnc_phone=100")