顧客管理システム -

顧客管理システム

フリーの顧客管理システムを使ってみた備忘録です
こちらで配布されているフリーの顧客管理システムL03

下記の内容は名古屋のホームページ制作 SPOT » SPOTのブログフリーの顧客管理システムL03の項目数をふやしてみたと同じです。

カスタマイズした箇所
▪️customer/config.php

<span onclick="Customer.increment(10)">追加</span>
                  ↓
<span onclick="Customer.increment(30)">追加</span>

▪️application/model/customer.php

for ($i = 0; $i < 10; $i++) {
       $this->schema[sprintf('customer_item%02d', $i)] = array();
}
                  ↓
for ($i = 0; $i < 30; $i++) {
       $this->schema[sprintf('customer_item%02d', $i)] = array();
}

▪️データベースにカラム追加

# mysql -u root -p customer
Enter password: 

MariaDB [customer]> show databases;
+--------------------+
| Database           |
+--------------------+
| customer           |
| mysql              |
| performance_schema |
+--------------------+

MariaDB [customer]> ALTER TABLE customer_customer ADD COLUMN customer_item29 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item28 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item27 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item26 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item25 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item24 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item23 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item22 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item21 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item20 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item19 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item18 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item17 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item16 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item15 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item14 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item13 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item12 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item11 TEXT AFTER customer_item09,
   -> ADD COLUMN customer_item10 TEXT AFTER customer_item09;
Query OK, 1 row affected (0.68 sec)                
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [customer]> SHOW COLUMNS FROM customer_customer;

追加されていることが確認できます。

LAB.ISHIGE-JP

顧客管理システム