https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=SMS_handler_functions 2026-09-09T22:09:14Z Revision history for this page on the wiki MediaWiki 1.31.16 https://wiki.isikhnas.com/index.php?title=SMS_handler_functions&diff=854&oldid=prev 2014-02-25T13:48:09Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="id"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Revisi sebelumnya</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revisi per 25 Februari 2014 13.48</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Baris 1:</td> <td colspan="2" class="diff-lineno">Baris 1:</td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;div class='plain'&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{#apGetSQL:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{#apGetSQL:</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>select format ('&lt;h2&gt;%s: %s&lt;/h2&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>select format ('&lt;h2&gt;%s: %s&lt;/h2&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l34" >Baris 34:</td> <td colspan="2" class="diff-lineno">Baris 35:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>where not s.del</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>where not s.del</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>order by s.start_code;|}}</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>order by s.start_code;|}}</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/div&gt;</ins></div></td></tr> </table>

Angus https://wiki.isikhnas.com/index.php?title=SMS_handler_functions&diff=819&oldid=prev 2014-02-25T03:25:51Z

<p>Created page with &quot;{{#apGetSQL: select format (&#039;&lt;h2&gt;%s: %s&lt;/h2&gt; &lt;h3&gt;Format pesan&lt;/h3&gt; %s %s %s %s&#039;, s.start_code, s.name[1],get_sms_format(s.id,1), format(&#039;&lt;h3&gt;Reply SQL&lt;/h3&gt; %s&#039;,replace(s.r...&quot;</p> <p><b>Halaman baru</b></p><div>{{#apGetSQL:<br /> select format ('&lt;h2&gt;%s: %s&lt;/h2&gt;<br /> &lt;h3&gt;Format pesan&lt;/h3&gt;<br /> %s<br /> %s <br /> %s <br /> %s', s.start_code, s.name[1],get_sms_format(s.id,1), format('&lt;h3&gt;Reply SQL&lt;/h3&gt;<br /> %s',replace(s.reply_sql,'<br /> ', '<br /> ')),<br /> case when s.alert_sql is not null and trim(s.alert_sql) &lt;&gt; '' then<br /> format('&lt;h3&gt;Alert SQL&lt;/h3&gt;<br /> %s',replace(s.alert_sql,'<br /> ', '<br /> '))<br /> else '' end,<br /> bar.br)<br /> from metadata.sms s<br /> left outer join (<br /> <br /> select foo.msg, format('&lt;h3&gt;Business Rules&lt;/h3&gt; %s', string_agg(foo.sql, '<br /> ')) as br<br /> from (<br /> select upper(right(b.caller,-4)) as msg,<br /> format('<br /> &lt;h5&gt;Hook: %s; Order: %s&lt;/h5&gt; <br /> %s',b.hook, b.ruleorder, replace(b.sql,'<br /> ', '<br /> ')) as sql<br /> from businessrules b<br /> where not b.del<br /> order by b.hook, b.ruleorder) as foo <br /> group by foo.msg ) bar on upper(bar.msg) = s.start_code<br /> where not s.del<br /> order by s.start_code;|}}</div>

Catriona