50 Demo CRM.p

<?php

class DemoCRM {

    static $pDB;

    function __construct() {
        self::$pDB = $GLOBALS['PHYLOBYTEDB'];
        $this->create_tables();
    }

    function create_tables() {
        $driver = self::$pDB->getAttribute(PDO::ATTR_DRIVER_NAME);

        $customer_table_sql = "
            CREATE TABLE IF NOT EXISTS dcrm_customers (
                id " . ($driver == 'sqlite' ? 'INTEGER PRIMARY KEY AUTOINCREMENT' : 'INT PRIMARY KEY AUTO_INCREMENT') . ",
                customer_name VARCHAR(255) NOT NULL,
                customer_state VARCHAR(255),
                customer_city VARCHAR(255),
                customer_zipcode VARCHAR(10),
                customer_email VARCHAR(255),
                customer_phone VARCHAR(20)
            );
        ";

        $order_table_sql = "
            CREATE TABLE IF NOT EXISTS dcrm_orders (
                id " . ($driver == 'sqlite' ? 'INTEGER PRIMARY KEY AUTOINCREMENT' : 'INT PRIMARY KEY AUTO_INCREMENT') . ",
                key_customer_id INT NOT NULL,
                date_placed DATE,
                order_description TEXT,
                order_amount DECIMAL(10, 2),
                FOREIGN KEY (key_customer_id) REFERENCES dcrm_customers(id)
            );
        ";

        try {
            self::$pDB->exec($customer_table_sql);
            self::$pDB->exec($order_table_sql);
        } catch (PDOException $e) {
            phylobyte::messageAddError('Error creating tables: ' . $e->getMessage());
        }

    }
}

new DemoCRM();
?>