Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" ?>
- <SCENARIOS version="3.0.103.16003">
- <SCENARIO name="AR DND forward enable cust" description="Scenario allows to enable Do not disturb mode to forward to particular number.">
- <STATE id="1" name="SQLQueryState" query="delete from redirectphones where number_priority=0 and id_client=${client/id-client} and client_type=${client/client-type}">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>7</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="7" name="SQLQueryState" result_variable="query_result" query="select if(char_length(SUBSTRING_INDEX(SUBSTRING_INDEX("${dialed-number}","*",-2),'*',1))>0,1,0);">
- <TRANSITIONS>
- <TRANSITION type="TransitionOnVariable">
- <next_state_id variable_name="query_result" variable_value="1" >8</next_state_id>
- <next_state_id variable_name="query_result" variable_value="0" >FINAL_STATE_ID</next_state_id>
- </TRANSITION>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>8</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="2" name="SQLQueryState" result_variable="query_result" query="select if(char_length(substring_index("${dialed-number}","*", -1))>0,1,0);">
- <TRANSITIONS>
- <TRANSITION type="TransitionOnVariable">
- <next_state_id variable_name="query_result" variable_value="1" >4</next_state_id>
- <next_state_id variable_name="query_result" variable_value="0" >3</next_state_id>
- </TRANSITION>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>3</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="3" name="SQLQueryState" query="insert into redirectphones(id_client, client_type, call_end_reason, follow_me_number, number_priority, did_number) VALUES (${client/id-client}, ${client/client-type}, 16, '<answering_rule> <action type="Voicemail"> </action></answering_rule>', 0,'${did_number}');">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>9</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="4" name="SQLQueryState" result_variable="forward_number" query="select substring_index("${dialed-number}","*", -1);">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>5</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="5" name="SQLQueryState" query="insert into redirectphones(id_client, client_type, call_end_reason, follow_me_number, number_priority) VALUES (${client/id-client}, ${client/client-type}, 16, '<answering_rule> <action type="forward"> <forward_to>${forward_number}</forward_to> </action></answering_rule>', 0);">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>6</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="6" name="PlayWaveState" wave_name="${language-media-dirname}\beep" playing_time="1">
- <TRANSITIONS>
- <TRANSITION type="TransitionOnEvent">
- <next_state_id event="EndCallEvent">FINAL_STATE_ID</next_state_id>
- </TRANSITION>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>FINAL_STATE_ID</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="8" name="SQLQueryState" result_variable="did_number" query="select SUBSTRING_INDEX(SUBSTRING_INDEX("${dialed-number}","*",-2),'*',1));">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>2</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- <STATE id="9" name="SQLQueryState" query="update dialingplan set tech_prefix = concat(LEFT(tech_prefix, INSTR(tech_prefix,'#')), 'redirect') where telephone_number = '${did_number}' and telephone_number in (select phone_number from portal_clientdids where client_id = ${/client/id-client});">
- <TRANSITIONS>
- <TRANSITION type="TransitionAlwaysTrue">
- <next_state_id>6</next_state_id>
- </TRANSITION>
- </TRANSITIONS>
- </STATE>
- </SCENARIO>
- </SCENARIOS>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement