<?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(&quot;${dialed-number}&quot;,&quot;*&quot;,-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(&quot;${dialed-number}&quot;,&quot;*&quot;, -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, '&lt;answering_rule&gt;  &lt;action type=&quot;Voicemail&quot;&gt;  &lt;/action&gt;&lt;/answering_rule&gt;', 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(&quot;${dialed-number}&quot;,&quot;*&quot;, -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, '&lt;answering_rule&gt;  &lt;action type=&quot;forward&quot;&gt;	&lt;forward_to&gt;${forward_number}&lt;/forward_to&gt;  &lt;/action&gt;&lt;/answering_rule&gt;', 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(&quot;${dialed-number}&quot;,&quot;*&quot;,-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>