Changeset 723

Timestamp:

05/14/08 07:50:55 (8 months ago)

Author:

areski

Message:

CHANGELOG UPDATE

Files:

• branches/1.3/CHANGELOG (modified) (1 diff)
• tags/1.3.3/CHANGELOG (modified) (1 diff)

branches/1.3/CHANGELOG

@@ -1 @@
-
-
-********************************************************************
-                                                V1.3
-********************************************************************
-
-
-#### BUG : CallBack
-********************************************************************
-DIVIDE THE AMOUNT OF CREDIT BY 2 IN ORDER TO AVOID NEGATIVE BALANCE IF THE USER USE ALL HIS CREDIT
-
-
-#### BUG : Customer UI
-********************************************************************
-from the user portal, i'm able to add more than 5 callerID eventhough i just set limit_callerid = 2. Is it a BUG or just i'm having this problem?
-http://forum.asterisk2billing.org/viewtopic.php?t=2250
-
-
-#### MISC
-********************************************************************
-- Change qualify to 7 chars : 
-        db change mysql :
-                ALTER TABLE cc_iax_buddies CHANGE qualify qualify char(7);
-                ALTER TABLE cc_sip_buddies CHANGE qualify qualify char(7);
-        db change psql :
-                ALTER TABLE cc_iax_buddies ALTER COLUMN qualify TYPE char(7);
-                ALTER TABLE cc_sip_buddies ALTER COLUMN qualify TYPE char(7);
-        
-- Correction on alarm spelling
-- Add export rates csv & xml
-- BUG : wrong audio file prepaid-enter-pin-number.gsm
-- BUG : peer sip iax qualify & nat & sip/iax info on Customer UI display 
-- UPDATE : scrollbar on textarea
-- UPDATE : naming on batch update
-- UPDATE : Help files
-- UPDATE : remove paypal section from conf files
-- UPDATE : Display ratecard 100% wide
-- BUG : Reporting
-
-
-#### NEW LOGO ON MAIN PAGE
-********************************************************************
-
-
-#### MOVE THIS IN CONF FILE
-********************************************************************
-        and this the a2billing-callback-daemon:
-        
-        ####### ASTERISK MANAGER ######
-        my $manager_host = "localhost";
-        my $manager_username = "myasterisk";
-        my $manager_secret = "mycode"; 
-
-use a2billing.conf
-[global]
-; MANAGER CONNECTION PARAMETERS
-manager_host = localhost
-manager_username = myasterisk
-manager_secret = mycode
-
-
-#### FILE USED ?
-********************************************************************
-trunk/A2BCustomer_UI/lib/epayment/includes/PP_header.php
-trunk/A2Billing_UI/lib/epayment/includes/PP_header.php
-
-To remove : 
-trunk/A2Billing_UI/signup/PP_footer.php
-trunk/A2Billing_UI/signup/PP_header.php
-
-#### BUG : IAX / SIP friends
-********************************************************************
-I have the BLANK PAGE when I click to generate the iax friend 
-it happens on the first user in the system
-
-
-#### BUG : IE Customer UI
-********************************************************************
-the menu is very bad on Internet Explorer in client interface
-you can view just half of the menu
-
-
-#### CALLBACK : INTRO MESSAGE
-********************************************************************
-Play an intro message on CallBack
-
-
-#### Building a logging / tracking system on the web interface
-********************************************************************
-Building a logging / tracking system on the web interface
-
-
-#### FEATURE : IVR - OPTION NO VOICE
-********************************************************************
-Create an option on the AGI to remove Audio
-
-; Play audio - this will disable all stream file but not the Get Data 
-; for wholesale ensure that the authentication works and than number_try = 1
-play_audio = YES
-
-
-#### REMOVE OLD PAYPAL
-********************************************************************
-A2Billing_UI/paypal
-A2B_entity_paypal.php?atmenu=paypal&stitle=PaypalTransaction&form_action=list&section=2
-FG_var_paypal
-
-
-#### SIGNUP : IF SIP/IAX Created reload asterik
-********************************************************************
-After the public signup , get Asterisk to do a reload, as when a new card is created, 
-asterisk is not reloaded, and therefore the SIP/IAX friend cannot register.
-
-I added new parameter to handle this :
-; Define if you want to reload Asterisk when a SIP / IAX Friend is created at signup time
-reload_asterisk_if_sipiax_created = no
-
-
-
-
-
-
-
-
+
-
+14 May 2008     - Belaid Arezqui <areski@gmail.com>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+       
+       
-
-#### BUG
-********************************************************************
-You have 1 dependent records.
-You are going as well to remove all the SIP/IAX accounts attached to this card! Please comfirm that you really want to remove that SIP/IAX Accounts ?
-
-
-#### check files 
-********************************************************************
-A2BCustomer_UI/lib/epayment/includes/methods/*
-
-define action url from conf file
-A2BCustomer_UI/lib/epayment/methods/moneybookers.php
-
-
-#### SHIFT LEFT : DEFINES.PHP
-********************************************************************
-SHIFT LEFT : DEFINES.PHP
-
-
-#### FEATURE : NEW CALLBACK SYSTEM
-********************************************************************
-rebuild of the callback system, we are using a spool system in DB and a perl Daemon to initiate the callback.
-it brings flexibility and a way to track the callback request, their status, etc...
-So we have a spool system, all request are stored and handled by a perl daemon that will take care of dispatching 
-them through several asterisk server.
-There is also an API also for this to generate the callback.
-/api/api_spool_callback.php
-this could be use by any third application/platform to generate callback request.
-
-#### INVOICES 
-********************************************************************
-View Invoices 
-        # show cardnumber
-        # Status appears to be empty for the invoice I had previously why ?
-        # if I click on Sent the sent date is not update
-        # Enter the cardnumber: -> this is the Card ID
-        
-        # Click on Details -> it will be good to see the Start date and the End Date there
-        # Details -> 
-                the Charges is not converted at all if I have a charge of 100 in EUR and my base currency is in usd
-                it will show 100 usd the amount is not converted
-                there is function in Misc.php for this
-        # Details -> the amount dont fit with what I have on the invoice page !!
-        # Details -> keeping some options like in invoices.php  
-                - RESULT :       Minutes - Second
-                - EXPORT FORMAT :        See Invoice in HTML  or Export PDF
-                - CURRENCY : selection
-        # Details -> Status :                    Connected      DisConnected
-                only show Status : [the appropiated image ] Connected or DisConnected
-        
-Create Invoices 
-        # For card number: -> From card ID:
-        # When you create the invoice we need an option to choose if we send or not directly the mail
-        # INVOICE STATUS
-                UNPAID
-                SENT-UNPAID
-                SENT-PAID
-                PAID
-        
-        # A2B_entity_create_invoice.php no footer
-        
-
-Invoice_Customer
-        # Menu dont use _ -> Invoice Customer
-        
-        # Error page : Blank with "No User found"
-        Can we design good error pages !!
-        
-        # if there is no calls and no charge, only the logo appear :
-                there is nothing telling u that the invoice is empty!!
-                
-        # show the covert start date
-        
-        # keeping some options like in invoices.php
-                - RESULT :       Minutes - Second
-                - EXPORT FORMAT :        See Invoice in HTML  or Export PDF
-                - CURRENCY : selection
-
-CUSTOMER
-        # A2BCustomer_UI/invoices_customer.php
-                - if there is no calls and no charge, only the logo appear :
-                there is nothing telling u that the invoice is empty!!
-                - show the covert start date
-        # List of invoices
-                customer should be able to see his own history of invoices with their status
-                Status should be different here, only pay or unpay
-        
-        
-
-#### FEATURE : REVIEW NEW DID MANAGEMENT
-********************************************************************
-Reservation and release
-* To check
-
-######## CURRENCY MANAGEMENT IN CRONT SERVICE 
-********************************************************************
-Currency management in cront service
-
-
-#### VOUCHER
-********************************************************************
-if you want to refill you card with a voucher please dial...
-and its not understandable
-
-
-#### Review Audio
-********************************************************************
-Send mail to Vincent for Spanish recording
-
-#### DID CRONT - currency cc_charge
-********************************************************************
-1#  add currency
-        a2billing_bill_diduse.php
-        
-        
-#### JQUERY SLIDE
-********************************************************************
-Menu with Jquery
-
-
-#### NAMING
-********************************************************************
-REPLACE SIGNUP IN THE LEFT MENU -> MISC
-replace also SIGNUP  in ACL
-
-TARIFFGROUP -> CALL PLAN
-        TARIFFGROUPNAME -> NAME
-        Change in edit card, signup & AGI
-
-
-#### JQUERY SLIDE
-********************************************************************
-help.php
-
-
-#### Misc : FORMAT
-********************************************************************
-To tidy up the box for filtering, can you either reduce the font size or use symbols only, e.g. >  ;   >=  ; <=
-
-
-#### Misc : INVOICE
-********************************************************************
-1# 
-        http://trac.a2billing.net/cgi-bin/trac.cgi/changeset/981
-        we need to have all this way
-
-2#
-        if the description is long, for instance put in the description "Extra Charges are to allow the billing of one-off or re-occurring monthly charges. These may be used as setup or service charges, etc...Charges will appear to the user with the description you attach. Each charge that you create for a user will decrement his account."
-
-        it doesnt looks pretty, the description column is very small
-        
-        problem on :
-        A2B_entity_invoice_billedmail.php
-        A2B_entity_invoice_detail.php
-        ...
-
-3# 
-        if you click on payment button when u have few payement
-        then u click on the "sort button" or to display [10] [50] [100] it fails or show up the menu!!!
-
-        
-4#
-        images on 
-        <img src="<?php echo Images_Path;?>/asterisk01.jpg" align="middle">
-        
-        I added a new parameter on a2billing.conf,
-        ; filename of the image that will be display at the top of the invoice (if not defined no image will appear ; path to place the image templates/default/images/)
-        invoice_image = asterisk01.jpg
-        
-        we will handle this that way
-        
-5#
-        A2B_entity_invoice_billedmail.php?section=2&id=8&cardid=12&action=sendinvoice&exporttype=html
-        some images dont exist
-        Public/templates/default/images/spacer.jpg
-        
-6#
-        A2B_entity_invoice_billedmail.php
-        this need to use mailtemplate
-        $email_from = "admin@a2billing.org"; 
-        $email_subject = "A2Billing Invoice";
-        $email_message = "Dear Customer<br><br>\n\n Attached is the Invoice.\n\n <br><br>Sincerely<br>\n\nAdministrator A2Billing";
-        
-        
-7#
-        Refactoring this HUGE mess.
-        We have tons of pages to show up almost the same report
-        Find a centralized way to make it clean and compress
-
-
-8#
-        A2B_entity_invoice_billedmail.php
-        we still have the understandable stuff at the end :
-        Status : 
-    Connected      Disconnected
-        
-        do the same as : A2B_entity_invoice_detail.php
-        
-
-#### TO FIX
-********************************************************************
-to check the patch I made here :
-http://trac.a2billing.net/cgi-bin/trac.cgi/changeset/955
-
-and try to reproduce this all all the invoices pages
-this compress and make the code cleaner.
-
-do this work for all the files :
-A2B_entity_invoice_billedmail.php
-A2B_entity_invoice_detail.php
-A2B_entity_invoice_list.php
-A2B_entity_invoices.php
-A2B_entity_invoices_unbilled.php
-A2B_entity_invoice_unbilledmail.php
-
-#### MISC
-********************************************************************
-* Customer -> Call Details : add criteria - Answered call
-
-#### FORMAT
-********************************************************************
-Rates -> Browse Rates
-Reduce the size of the fonts in the batch up section e.g. 1.) Trunk – looks ok in firefox, but everything falls off the end in IE7 
-
-
-#### ADD SCROLLBAR ON ALL POPUP
-********************************************************************
-scrollbars=1 in the window.open
-Check Rev 977
-
-
-#### WRITE DOCUMENTATION: API SHOW RATECARD -> 
-********************************************************************
-WRITE FULL DOCUMENTATION FOR :
-trunk/A2Billing_UI/api/display_ratecard.php
-
-
-
-#### WRITE DOCUMENTATION: ALARM SYSTEM
-********************************************************************
-WRITE DOCUMENTATION: ALARM SYSTEM
-
-
-#### FEATURE : NEW INVOICING SYSTEM
-********************************************************************
-you will see, I dont describe here
-
-
-#### FEATURE : jump_voucher_if_min_credit
-********************************************************************
-When the user credit are below the minimum credit to call min_credit 
-we might have an option to decide if we jump directly to the voucher IVR menu instead of just disconecting
-
-option in a2billing.conf
-jump_voucher_if_min_credit = yes or no
-
-
-#### MANAGE MULTI LENGHT CARD NUMBER
-********************************************************************
-New parameter :
-[global]
-; len_cardnumber is removed
-; interval for the length of the cardnumber (number of digits), 
-; ie: 10-15 (cardnumber authorised 10, 11, 12, 13, 14, 15) ; 10,12,14 (cardnumber authorised 10, 12, 14)
-interval_len_cardnumber = 10-15
-
-
-We will support more than 1 lenght for the cardnumber.
-Admin Web interface :
-- Create customer : 
-        Add a drop-down button in the top page (below the help) to select the lenght for the card creation
-        -> if the drop-down is selected the page will refresh with the new value for the card lenght
-        by default we will use the minimum value of interval_len_cardnumber
-- Generate Customer :
-        Add a point 13) as a drop-down button, select the card lenght but no refresh needed here
-- AGI
-
-#### EXEC_SETLANGUAGE
-********************************************************************
-function exec_setlanguage($language='en')
-{
-  return $this->exec('SetLanguage', $language);
-}
-
-
-#### UPDATE a2billing_invoice_cront
-********************************************************************
-* use the conf parameter : invoice_system -> invoiceday
-* add cc_charge
-* invoice_history
-
-
-#### BUG CAPTCHA
-********************************************************************
-please have a look also at the captcha
-if u use caps letters, it wont work, all the pics are shows with caps
-
-#### HOURLY ALARM
-********************************************************************
-add in the alarm system an hourly check
-
-
-#### bug CallerID
-********************************************************************
-CID not working  when  ANSWER_CALL=NO
-iv changed back to ANSER_CALL=YES , AND WORKS
-
-
-#### missing text put text in Gettext
-********************************************************************
-CC_phonelist_import_analyse.php
-CC_ratecard_import_analyse.php
-CC_card_import_analyse.php
-
-also some more are missing on those files (check the javascript):
-CC_card_import.php
-CC_phonelist_import.php
-CC_ratecard_import.php
-
-
-#### ADD INVOICE DAY
-********************************************************************
-
-
-#### SAVE PAYMENT OPTION
-********************************************************************
-when go on edit paypal/moneybooker and click on Update
-I dont get any confirmation that the option has been saved
-
-
-#### PAYMENT OPTION
-********************************************************************
-put some help on the top
-
-#### IMPORT RATECARD
-********************************************************************
-ADD option to define if we want to import the price in cents or in units
-
-
-#### BAD ERROR MESSAGE
-********************************************************************
-when u import a csv file and the size is bigger the 500 k for example u get the error  file not found
-the error message its not defined correctly
-
-
-#### FEATURE
-********************************************************************
-REPORTING AND SUPPORT ALARMS :
-
-        
-        * ALOC (average length of call): Too low or too high.
-        * ASR (answer seize ratio): Too low or too high.
-        
-        maybe if possible :
-        * CIC (Consecutive Incomplete Calls): Too many.
-   
-We already have ALOC under the name of ACD in the page "CDR REPORT", we just need a new column for ASR and
-rename ACD -> ALOC
-
-
-ASR = Answer Seizure Ratio
-Its calculated by taking the number of sucessfully answered calls and dividing by the total number of calls attempted (seizures). Since busy signals and other rejections by the called number count as call failures, the calculated ASR value can vary depending on user behaviour. 
-
-
-For "Consecutive Incomplete Calls", we might find a way to display this I open to your suggestion. maybe a report as follow :
-Date ; total nb fails ; max of number fail calls succesively ; rate of fails (%)
-
-
-
-For the alarm let's build a new table and a new page in CRONT SERVICE.
-We need the user to be able to define different kind of alarm, for instance if I want
-to monitor a specific trunk and not all
-We can have in the table something like :
-- period (daily ; monday-sunday ; 01 - 31)
-- typealarm (asr, aloc, callfail)
-- trunk (all or the ID of the trunk)
-- etc...
-
-
-
-#### FEATURE : PACKAGES SYSTEM - FREE MINUTES
-********************************************************************
-Situation :
-We need to support a new relation call "FREE MINUTE" under kind of package according to the destination.
-We have an example : http://www.blueface.ie/
-There is several kind of packages :
-- Unlimited UK/Ireland where they can call as much as they want to this destination and pay for the rest.
-- 300 minutes free over 20 destinations + unlimited on Uk for instance
-- 300 minutes free over 20 destinations
-- pay as you go, standard
-
-We have to add in A2Billing this relation... For the unlimited calls we already have the routes at 0 cost.
-now we might need to assign the X free minutes relation over YZ destinations.
-
-
-- 300 minutes free over 20 destinations + unlimited on Uk for instance
-the relation unlimited is already defined in the rate-engine through the route with cost=0
-
-we need to add new table :
-table cc_package to define the type package & min free. 
-CREATE TABLE cc_package_offer (
-    id bigserial NOT NULL,
-    creationdate timestamp without time zone DEFAULT now(),
-    label text NOT NULL,
-    packagetype int NOT NULL,
-        billingtype int NOT NULL,
-        startday int NOT NULL,
-        freeminutes int NOT NULL
-);
--- packagetype : Free minute + Unlimited ; Free minute ; Unlimited ; Normal
--- billingtype : Monthly ; Weekly 
--- startday : according to billingtype ; if monthly value 1-31 ; if Weekly value 1-7 (Monday to Sunday) 
-I guess a field in cc_tariffgroup which will define the relation with cc_package_offer 
-and a field in cc_ratecard to define if the rate will take advantage of the package offer (part of X min free)
-
-We have also to think that the offer will be per month (per week, etc..) so we will need to keep the number of free-minutes used by month (period)
-and by user/card, Customer have to have the offer for each time period (since the creation date).
-Table cc_card_package (id_card, id_package_offer, time_used(secondes) )
-
-CREATE TABLE cc_card_package_offer (
-    id                                  bigserial NOT NULL,
-        id_cc_card                      bigint NOT NULL.
-        id_cc_package_offer bigint NOT NULL,
-    date_consumption    timestamp without time zone DEFAULT now(),
-        used_secondes           bigint NOT NULL
-);
-CREATE INDEX ind_cc_card_package_offer_id_card ON cc_card_package_offer USING btree (id_cc_card);
-CREATE INDEX ind_cc_card_package_offer_id_package_offer ON cc_card_package_offer USING btree (id_package_offer);
-CREATE INDEX ind_cc_card_package_offer_date_consumption ON cc_card_package_offer USING btree (date_consumption);
-
-ALTER TABLE cc_tariffgroup      ADD COLUMN id_cc_package_offer BIGINT NOT NULL DEFAULT 0;
-ALTER TABLE cc_ratecard         ADD COLUMN freeminute_package_offer INT NOT NULL DEFAULT 0;
-
-
-Other Billing difficulty : 
-When we reach the limite, we will have part of the call inside the offer (so not billed) and the rest of the minutes should be billed...
-
-
-CREATE TABLE cc_subscription_fee (
-    id                          BIGSERIAL NOT NULL,
-    label                       TEXT NOT NULL,  
-        fee                     NUMERIC(12,4) NOT NULL,
-        currency                CHARACTER VARYING(3) DEFAULT 'USD'::character varying,
-        status                  INTEGER NOT NULL DEFAULT 0,
-    numberofrun         INTEGER NOT NULL DEFAULT 0,
-    datecreate          timestamp(0) without time zone DEFAULT now(),
-    datelastrun         timestamp(0) without time zone DEFAULT now(),
-    emailreport         TEXT,
-    totalcredit         DOUBLE PRECISION NOT NULL DEFAULT 0,
-    totalcardperform INTEGER NOT NULL DEFAULT 0
-);
-ALTER TABLE ONLY cc_subscription_fee
-ADD CONSTRAINT cc_subscription_fee_pkey PRIMARY KEY (id);
-
-
-ALTER TABLE cc_charge   ADD COLUMN currency                             CHARACTER VARYING(3) DEFAULT 'USD'::CHARACTER VARYING;
-ALTER TABLE cc_charge   ADD COLUMN id_cc_subscription_fee       BIGINT DEFAULT 0;
-
-
-CREATE INDEX ind_cc_charge_id_cc_card                           ON cc_charge USING btree (id_cc_card);
-CREATE INDEX ind_cc_charge_id_cc_subscription_fee       ON cc_charge USING btree (id_cc_subscription_fee);
-CREATE INDEX ind_cc_charge_creationdate                         ON cc_charge USING btree (creationdate);
-
-
--- INSTEAD USE CC_CHARGE
---      CREATE TABLE cc_subscription_fee_card (
---          id                                          BIGSERIAL NOT NULL,
---          id_cc_card                          BIGINT NOT NULL,
---              id_cc_subscription_fee  BIGINT NOT NULL,
---          datefee                             TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),
---          fee                                         NUMERIC(12,4) NOT NULL,
---              fee_converted                   NUMERIC(12,4) NOT NULL,
---              currency                                CHARACTER VARYING(3) DEFAULT 'USD'::CHARACTER VARYING
---      );
---      ALTER TABLE ONLY cc_subscription_fee_card
---      ADD CONSTRAINT cc_subscription_fee_card_pkey PRIMARY KEY (id);
-
---      CREATE INDEX ind_cc_subscription_fee_card_id_card ON cc_subscription_fee_card USING btree (id_card);
---      CREATE INDEX ind_cc_subscription_fee_card_id_cc_subscription_fee ON cc_subscription_fee_card USING btree (id_cc_subscription_fee);
---      CREATE INDEX ind_cc_subscription_fee_card_datefee ON cc_subscription_fee_card USING btree (datefee);
-
-
-
---- MENU ---
-PACKAGE OFFER
-        * List package Offer
-        * Add package Offer
-        * details by card
-
-SERVICE
-        * List subscription service
-        * Add subscription service
-
-
-
-
-?? ADD CC_SUBSCRIPTION_FEE & CC_CHARGE CHANGES IN MYSQL SCHEMAS
-
-MISSING : 
-- AGI
-        http://trac.a2billing.net/cgi-bin/trac.cgi/changeset/789
-        
-        IF PACKAGE IN THE TARIFFGROUP
-                0#      add freetimetocall_package_offer in select ratecard
-                
-                1#      Get info from the package
-                        - billingtype ; startday ; freetimetocall
-                2# 
-                        According to billingtype (monthly 0 ; weekly 1)
-                        if (monthly){
-                                if (startday > last day of the month) startday = last day of the month;
-                                if (startday <= 0 ) startday = 1;
-                                dateclause >= year-month-startday
-                        }else{// weekly
-                                startday = startday % 7 (modulo)
-                                if (currentdayofweek < startday) currentdayofweek++7
-                                diffday = currentdayofweek - startday (current lundi 1 - mercredi 3 = 5) 
-                                dateclause >=                           
-                                # mysql -> SELECT DATE_SUB('2003-07-13 00:00:00', INTERVAL 14 DAY);
-                                # mysql -> SELECT DATE_SUB(NOW(), INTERVAL 14 DAY);
-                                # psql  -> SELECT (date('2003-07-13 00:00:00') - interval '14 day');