Changeset 858

Show
Ignore:
Timestamp:
06/24/08 12:30:41 (2 months ago)
Author:
rach
Message:

Card Group :
Link Card <-> Card Group

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/admin/Public/form_data/FG_var_card_group.inc

    r856 r858  
    88 
    99$HD_Form -> FG_DEBUG = 0; 
     10 
     11 
     12$HD_Form -> FG_TABLE_DEFAULT_ORDER = "name"; 
     13$HD_Form -> FG_TABLE_DEFAULT_SENS = "DESC"; 
     14 
     15// Code Here for Deleting the Dependent Records 
     16// Dependent Tables 
     17$HD_Form -> FG_FK_DELETE_ALLOWED = true; 
     18$HD_Form -> FG_FK_DELETE_CONFIRM = true; 
     19$HD_Form -> FG_FK_WARNONLY = true; 
     20$HD_Form -> FG_FK_TABLENAMES = array("cc_card"); 
     21$HD_Form -> FG_FK_EDITION_CLAUSE = array(" id_group "); 
     22 
     23$HD_Form -> FG_FK_DELETE_MESSAGE = gettext("You have some cards using this Customers Group! Please comfirm that you really want to remove this Customers Group ? "); 
     24 
     25 
    1026 
    1127 

  • trunk/admin/Public/form_data/FG_var_card.inc

    r770 r858  
    154154if (!($popup_select>=1))  $HD_Form -> AddViewElement("<acronym title=\"CARDALIAS\">".gettext("ALIAS")."</acronym>", "useralias", "12%", "center", "sort"); 
    155155$HD_Form -> AddViewElement(gettext("LASTNAME"), "lastname", "10%", "center", "sort", "15"); 
     156$HD_Form -> AddViewElement(gettext("GROUP"), "id_group", "8%", "center", "sort", "15", "lie", "cc_card_group", "name", "id='%id'", "%1"); 
    156157$HD_Form -> AddViewElement("<acronym title=\"BALANCE\">".gettext("BA")."</acronym>", "credit", "5%", "center", "sort", "", "", "", "", "", "", ""); 
    157158 
    …… 
    166167        $HD_Form -> AddViewElement("<acronym title=\"AMOUNT OF CALL DONE\">".gettext("ACD")."</acronym>", "nbused", "4%", "center", "sort"); 
    167168        if(stristr($_SERVER['REQUEST_URI'], 'A2B_entity_card_multi.php')) { 
    168                 $FG_COL_QUERY='id, tag, username, useralias, lastname, credit, tariff, status, language, inuse, currency, sip_buddy, iax_buddy, nbused'; 
     169                $FG_COL_QUERY='id, tag, username, useralias, lastname,id_group, credit, tariff, status, language, inuse, currency, sip_buddy, iax_buddy, nbused'; 
    169170        } else { 
    170                 $FG_COL_QUERY='id, username, useralias, lastname, credit, tariff, status, language, inuse, currency, sip_buddy, iax_buddy, nbused '; 
     171                $FG_COL_QUERY='id, username, useralias, lastname,id_group, credit, tariff, status, language, inuse, currency, sip_buddy, iax_buddy, nbused '; 
    171172        } 
    172173}else{ 
    173         $FG_COL_QUERY='id, username, lastname, credit'; 
     174        $FG_COL_QUERY='id, username, lastname, id_group, credit'; 
    174175} 
    175176 
    …… 
    290291                           "" , "", "", "", "", "",     "", gettext("Password for customer to access to the web interface and view the balance.") ); 
    291292 
     293$HD_Form -> AddEditElement (gettext("CARD GROUP"), 
     294                           "id_group", 
     295                           "", 
     296                           "SELECT", 
     297                           "", "", "", 
     298                           "sql", 
     299                           "cc_card_group", 
     300                           "name, id", 
     301                           "", "", "%1", "", ""); 
    292302 
    293303$HD_Form -> AddEditElement (gettext("BALANCE"), 
    …… 
    784794 
    785795 
    786 $HD_Form -> FieldEditElement ('username, useralias, uipass, credit, language, tariff, id_didgroup, id_agent, callback, status,  activatedbyuser, simultaccess, currency, runservice, autorefill, initialbalance, typepaid, creditlimit,       firstusedate, enableexpire, expirationdate, expiredays, voicemail_permitted, voicemail_activated, invoiceday, vat, lastname, firstname, email, address, city, state, country, zipcode, id_timezone, phone, fax, sip_buddy, iax_buddy, mac_addr, inuse, template_invoice, template_outstanding, credit_notification, notify_email, email_notification' ); 
     796$HD_Form -> FieldEditElement ('username, useralias, uipass,id_group, credit, language, tariff, id_didgroup, id_agent, callback, status,  activatedbyuser, simultaccess, currency, runservice, autorefill, initialbalance, typepaid, creditlimit,      firstusedate, enableexpire, expirationdate, expiredays, voicemail_permitted, voicemail_activated, invoiceday, vat, lastname, firstname, email, address, city, state, country, zipcode, id_timezone, phone, fax, sip_buddy, iax_buddy, mac_addr, inuse, template_invoice, template_outstanding, credit_notification, notify_email, email_notification' ); 
    787797 
    788798 

  • trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r856 r858  
    979979--insert default group 
    980980 
    981 INSERT INTO cc_card_group ( 
    982 id , 
    983 name , 
    984 id_agi_conf 
    985 ) 
    986 VALUES ( 
    987 NULL , 'DEFAULT', '-1' 
    988 ); 
    989  
     981INSERT INTO cc_card_group (id ,name ,id_agi_conf) 
     982VALUES ('1' , 'DEFAULT', '-1'); 
     983 
     984ALTER TABLE cc_card ADD id_group INT NOT NULL DEFAULT '1'; 


Google