Rate Sheet 匯入作業

技巧：使用 SQL

查詢 Ratecard ID

mysql> SELECT id,tariffname FROM cc_tariffplan;
+----+----------------+
| id | tariffname     |
+----+----------------+
|  1 | callwithus std |
+----+----------------+
1 row in set (0.00 sec)

使 SellRate 等於 BuyRate
註：欄位 rateinitial 就是 SellRate

mysql> UPDATE cc_ratecard SET buyrate = rateinitial WHERE idtariffplan = 1;

調整所有 sellrate 加上 20%

mysql> UPDATE cc_ratecard SET rateinitial = (rateinitial*1.2) WHERE idtariffplan = 1;

使 SellRate Min Duration 等於 BuyRate Min Duration

mysql> UPDATE cc_ratecard SET initblock = buyrateinitblock WHERE idtariffplan = 1;

使 SellRate Billing Block 等於 BuyRate Billing Block

mysql> UPDATE cc_ratecard SET billingblock = buyrateincrement WHERE idtariffplan = 1;

參考教學

• 教學一：以 provider CallWithUs 為例
• 教學二：以 provider Voip.ms 為例