http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&feed=atom&action=history
Изменение суммы лимита определенной группе договоров - История изменений
2024-03-28T13:00:53Z
История изменений этой страницы в вики
MediaWiki 1.15.1
http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&diff=6159&oldid=prev
Phricker в 09:00, 27 февраля 2015
2015-02-27T09:00:03Z
<p></p>
<table style="background-color: white; color:black;">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Предыдущая</td>
<td colspan='2' style="background-color: white; color:black;">Версия 09:00, 27 февраля 2015</td>
</tr>
<tr><td colspan="2" class="diff-lineno">Строка 24:</td>
<td colspan="2" class="diff-lineno">Строка 24:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> public void execute(Setup setup, ConnectionSet connectionSet)</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> public void execute(Setup setup, ConnectionSet connectionSet)</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> throws Exception {</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> throws Exception {</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"> print("Start");</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"> long timeStart = System.currentTimeMillis();</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int groupId = 1; //ID группы</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int groupId = 1; //ID группы</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int count = 0;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int count = 0;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> BigDecimal limit = new BigDecimal(-10000000); //Сумма установленного лимита</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> BigDecimal limit = new BigDecimal(-10000000); //Сумма установленного лимита</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> String comment = "Лимит выставленный скриптом";</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> String comment = "Лимит выставленный скриптом";</div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <del class="diffchange diffchange-inline">print("Start");</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> Connection con = connectionSet.getConnection();</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> Connection con = connectionSet.getConnection();</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> LimitManager lm = new LimitManager(con);</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> LimitManager lm = new LimitManager(con);</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> ServerContext context = ServerContext.get();</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> ServerContext context = ServerContext.get();</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"> long timeStart = System.currentTimeMillis();</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> String query = " SELECT c.id FROM contract AS c WHERE gr&(1<<" + groupId + ") > 0";</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> String query = " SELECT c.id FROM contract AS c WHERE gr&(1<<" + groupId + ") > 0";</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> PreparedStatement ps = con.prepareStatement(query);</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> PreparedStatement ps = con.prepareStatement(query);</div></td></tr>
<!-- diff generator: internal 2024-03-28 13:00:53 -->
</table>
Phricker
http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&diff=6158&oldid=prev
Phricker в 08:58, 27 февраля 2015
2015-02-27T08:58:32Z
<p></p>
<table style="background-color: white; color:black;">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Предыдущая</td>
<td colspan='2' style="background-color: white; color:black;">Версия 08:58, 27 февраля 2015</td>
</tr>
<tr><td colspan="2" class="diff-lineno">Строка 1:</td>
<td colspan="2" class="diff-lineno">Строка 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Скрипт меняет лимит договорам в определенной группе</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Скрипт меняет лимит договорам в определенной группе</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Предварительно скрипт удаляет все задачи по восстановлению временного лимита, на том договоре на котором будет происходить смена лимита.</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang="java">package ru.ellcom.test;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang="java">package ru.ellcom.test;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<!-- diff generator: internal 2024-03-28 13:00:53 -->
</table>
Phricker
http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&diff=6157&oldid=prev
Phricker в 08:57, 27 февраля 2015
2015-02-27T08:57:43Z
<p></p>
<table style="background-color: white; color:black;">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Предыдущая</td>
<td colspan='2' style="background-color: white; color:black;">Версия 08:57, 27 февраля 2015</td>
</tr>
<tr><td colspan="2" class="diff-lineno">Строка 26:</td>
<td colspan="2" class="diff-lineno">Строка 26:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int count = 0;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> int count = 0;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> BigDecimal limit = new BigDecimal(-10000000); //Сумма установленного лимита</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> BigDecimal limit = new BigDecimal(-10000000); //Сумма установленного лимита</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"> String comment = "Лимит выставленный скриптом";</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> print("Start");</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> print("Start");</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Строка 44:</td>
<td colspan="2" class="diff-lineno">Строка 45:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> }</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> lm.updateContractLimit(User.USER_SERVER, limit, cid, <del class="diffchange diffchange-inline">"Лимит выставленный VIP абонентам"</del>, "");</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> lm.updateContractLimit(User.USER_SERVER, limit, cid, <ins class="diffchange diffchange-inline">comment</ins>, "");</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> context.publishAfterCommit(new SystemLimitChangedEvent(cid, limit));</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> context.publishAfterCommit(new SystemLimitChangedEvent(cid, limit));</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> context.publishAfterCommit(new LimitChangedEvent(cid, limit));</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> context.publishAfterCommit(new LimitChangedEvent(cid, limit));</div></td></tr>
<!-- diff generator: internal 2024-03-28 13:00:53 -->
</table>
Phricker
http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&diff=6156&oldid=prev
Phricker в 08:52, 27 февраля 2015
2015-02-27T08:52:54Z
<p></p>
<table style="background-color: white; color:black;">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Предыдущая</td>
<td colspan='2' style="background-color: white; color:black;">Версия 08:52, 27 февраля 2015</td>
</tr>
<tr><td colspan="2" class="diff-lineno">Строка 1:</td>
<td colspan="2" class="diff-lineno">Строка 1:</td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Скрипт меняет лимит </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Скрипт меняет лимит <ins class="diffchange diffchange-inline">договорам в определенной группе</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang="java">package ru.ellcom.test;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang="java">package ru.ellcom.test;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<!-- diff generator: internal 2024-03-28 13:00:53 -->
</table>
Phricker
http://wiki.bitel.ru/index.php?title=%D0%98%D0%B7%D0%BC%D0%B5%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D1%83%D0%BC%D0%BC%D1%8B_%D0%BB%D0%B8%D0%BC%D0%B8%D1%82%D0%B0_%D0%BE%D0%BF%D1%80%D0%B5%D0%B4%D0%B5%D0%BB%D0%B5%D0%BD%D0%BD%D0%BE%D0%B9_%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D0%B5_%D0%B4%D0%BE%D0%B3%D0%BE%D0%B2%D0%BE%D1%80%D0%BE%D0%B2&diff=6155&oldid=prev
Phricker: Новая страница: «Скрипт меняет лимит <source lang="java">package ru.ellcom.test; import bitel.billing.server.contract.bean.LimitChangeTask; import bitel.billing.se…»
2015-02-27T08:51:12Z
<p>Новая страница: «Скрипт меняет лимит <source lang="java">package ru.ellcom.test; import bitel.billing.server.contract.bean.LimitChangeTask; import bitel.billing.se…»</p>
<p><b>Новая страница</b></p><div>Скрипт меняет лимит <br />
<source lang="java">package ru.ellcom.test;<br />
<br />
import bitel.billing.server.contract.bean.LimitChangeTask;<br />
import bitel.billing.server.contract.bean.LimitManager;<br />
import ru.bitel.bgbilling.kernel.container.managed.ServerContext;<br />
import ru.bitel.bgbilling.kernel.event.events.LimitChangedEvent;<br />
import ru.bitel.bgbilling.kernel.event.events.system.SystemLimitChangedEvent;<br />
import ru.bitel.bgbilling.kernel.module.common.bean.User;<br />
import ru.bitel.bgbilling.kernel.script.server.dev.GlobalScriptBase;<br />
import ru.bitel.bgbilling.server.util.Setup;<br />
import ru.bitel.common.sql.ConnectionSet;<br />
<br />
import java.math.BigDecimal;<br />
import java.sql.Connection;<br />
import java.sql.PreparedStatement;<br />
import java.sql.ResultSet;<br />
import java.util.List;<br />
<br />
public class ChangeLimitTest<br />
extends GlobalScriptBase {<br />
@Override<br />
public void execute(Setup setup, ConnectionSet connectionSet)<br />
throws Exception {<br />
int groupId = 1; //ID группы<br />
int count = 0;<br />
BigDecimal limit = new BigDecimal(-10000000); //Сумма установленного лимита<br />
<br />
print("Start");<br />
Connection con = connectionSet.getConnection();<br />
LimitManager lm = new LimitManager(con);<br />
ServerContext context = ServerContext.get();<br />
<br />
long timeStart = System.currentTimeMillis();<br />
String query = " SELECT c.id FROM contract AS c WHERE gr&(1<<" + groupId + ") > 0";<br />
PreparedStatement ps = con.prepareStatement(query);<br />
ResultSet rs = ps.executeQuery();<br />
<br />
while (rs.next()) {<br />
int cid = rs.getInt("c.id");<br />
List<LimitChangeTask> taskList = lm.getContractMoveTasks(cid);<br />
for (LimitChangeTask task : taskList) {<br />
lm.deleteMoveTaskAndLog(task.getId(), task.getContractId(), task.getUserId());<br />
}<br />
<br />
lm.updateContractLimit(User.USER_SERVER, limit, cid, "Лимит выставленный VIP абонентам", "");<br />
context.publishAfterCommit(new SystemLimitChangedEvent(cid, limit));<br />
context.publishAfterCommit(new LimitChangedEvent(cid, limit));<br />
count++;<br />
}<br />
rs.close();<br />
ps.close();<br />
long timeEnd = System.currentTimeMillis();<br />
print("Count = " + count);<br />
print("Process time: " + (timeEnd - timeStart) / 1000 + " s.");<br />
<br />
}<br />
}<br />
</source></div>
Phricker