Adding company_id attribute for client.

filip

2010-11-04 baec2b27041db30bf08a8d421553eb8cc6b68a60

Adding company_id attribute for client. 

(It's used in several countries to identify company)

 install/sql/incremental/upd_0005.sql

New file
@@ -0,0 +1,2 @@
ALTER TABLE client ADD COLUMN company_id varchar(30);


 install/sql/ispconfig3.sql

@@ -1649,6 +1649,8 @@

INSERT INTO `help_faq` VALUES (1,1,0,'I\'d like to know ...','Yes, of course.',1,1,'riud','riud','r');

ALTER TABLE client ADD COLUMN company_id varchar(30);

-- --------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 1;

 interface/web/client/form/client.tform.php

@@ -305,6 +305,17 @@
            'rows'        => '',
            'cols'        => ''
        ),
        'company_id' => array (
            'datatype'    => 'VARCHAR',
            'formtype'    => 'TEXT',
            'default'    => '',
            'value'        => '',
            'separator'    => '',
            'width'        => '30',
            'maxlength'    => '20',
            'rows'        => '',
            'cols'        => ''
        ),
        'notes' => array (
            'datatype'    => 'TEXT',
            'formtype'    => 'TEXTAREA',

 interface/web/client/lib/lang/cz_client.lng

@@ -98,4 +98,5 @@
$wb['customer_no_txt'] = 'Customer No.';
$wb['vat_id_txt'] = 'VAT ID';
$wb['required_fields_txt'] = '* Required fields';
$wb['company_id_txt'] = 'IČO';
?>

 interface/web/client/lib/lang/en_client.lng

@@ -101,4 +101,5 @@
$wb["customer_no_txt"] = 'Customer No.';
$wb["vat_id_txt"] = 'VAT ID';
$wb["required_fields_txt"] = '* Required fields';
$wb['company_id_txt'] = 'Company/Entrepreneur ID';
?>

 interface/web/client/templates/client_edit_address.htm

@@ -92,6 +92,10 @@
          <label for="vat_id">{tmpl_var name='vat_id_txt'}</label>

        <input name="vat_id" id="vat_id" value="{tmpl_var name='vat_id'}" size="30" maxlength="255" type="text" class="textInput" />

      </div>

      <div class="ctrlHolder">

          <label for="company_id">{tmpl_var name='company_id_txt'}</label>

        <input name="company_id" id="company_id" value="{tmpl_var name='company_id'}" size="30" maxlength="255" type="text" class="textInput" />

      </div>

      <div class="ctrlHolder">

          <label for="notes">{tmpl_var name='notes_txt'}</label>

        <textarea name="notes" id="notes" rows='10' cols='30'>{tmpl_var name='notes'}</textarea>