Giter Club home page Giter Club logo

qr2assistme's Introduction

qr2assistme

What is it?

QR2AssistMe is an open source web system to control equipments or objects for technical services companies using QR Codes help tracking them.

QR2AssistMe uses Codeigniter 4 framework as a base for development and additionally uses other key libraries and components described bellow.

Installation & Configuration

  • Download the source code
  • Create a MySQL or MariaDB database called "qrassist" and take note of user/password information
  • Copy .env.default to .env
  • Edit .env accordingly (set base URL, Google and Facebook client credentials and mysql information)
  • Run composer install to install required packages and libraries
  • Run refersh.sh (for linux) or refresh.bat (for windows)
  • That should be enought!
  • After that it is a normal codeigniter application to work with

Custom Classes

There are a number of new classes created to add an abstraction layer on codeigniter and create functionality to help ordinary tasks:

  • BaseModel
  • BaseView
  • BaseAdminLteView
  • BaseAdminLteCRUDView
  • BaseEntity
  • BaseTableMigration
  • BaseProcedureMigration
  • BaseController
  • BaseAdminLteController
  • BaseAdminLteCRUDController

Licencing

QR2AssistMe available under GNU GPLv3 licence.

Libraries and components used

I'd like to thank all developpers envolved on following projects:

Library Version Description
AdminLTE v3 Free Bootstrap Admin Template by AdminLTE.IO
nimiq/qr-scanner v3 Javascript QR Code Scanner based on Cosmo Wolfe's javascript port of Google's ZXing library.
brick/math 0.9.2 Arbitrary-precision arithmetic library
chillerlan/php-qrcode 3.4.0 A QR code generator. PHP 7.2+
chillerlan/php-settings-container 1.2.1 A container class for immutable settings objects. Not a DI container. PHP 7.2+
codeigniter4/framework v4.1.2 The CodeIgniter framework v4
composer/ca-bundle 1.2.10 Lets you find a path to the system CA bundle, and includes a fallback to the Mozilla CA bundle.
composer/composer 2.1.3 Composer helps you declare, manage and install dependencies of PHP projects. It ensures you have the right stack everywhere.
composer/metadata-minifier 1.0.0 Small utility library that handles metadata minification and expansion.
composer/semver 3.2.5 Semver library that offers utilities, version constraint parsing and validation.
composer/spdx-licenses 1.5.5 SPDX licenses list and validation library.
composer/xdebug-handler 2.0.1 Restarts a process without Xdebug.
doctrine/instantiator 1.4.0 A small, lightweight utility to instantiate objects in PHP without invoking their constructors
dominikb/composer-license-checker 2.2.0 Utility to check for licenses of dependencies and block/allow them.
facebook/graph-sdk 5.7.0 Facebook SDK for PHP
fakerphp/faker v1.14.1 Faker is a PHP library that generates fake data for you.
firebase/php-jwt v5.2.1 A simple library to encode and decode JSON Web Tokens (JWT) in PHP. Should conform to the current spec.
google/apiclient v2.9.1 Client library for Google APIs
google/apiclient-services v0.176.0 Client library for Google APIs
google/auth v1.15.1 Google Auth Library for PHP
guzzlehttp/guzzle 7.3.0 Guzzle is a PHP HTTP client library
guzzlehttp/promises 1.4.1 Guzzle promises library
guzzlehttp/psr7 1.8.2 PSR-7 message implementation that also provides common utility methods
justinrainbow/json-schema 5.2.10 A library to validate a json schema.
kint-php/kint 3.3 Kint - debugging tool for PHP developers
laminas/laminas-escaper 2.7.0 Securely and safely escape HTML, HTML attributes, JavaScript, CSS, and URLs
laminas/laminas-zendframework-bridge 1.2.0 Alias legacy ZF class names to Laminas Project equivalents.
mikey179/vfsstream v1.6.8 Virtual file system to mock the real file system in unit tests.
monolog/monolog 2.2.0 Sends your logs to files, sockets, inboxes, databases and various web services
myclabs/deep-copy 1.10.2 Create deep copies (clones) of your objects
nikic/php-parser v4.10.5 A PHP parser written in PHP
paragonie/constant_time_encoding v2.4.0 Constant-time Implementations of RFC 4648 Encoding (Base-64, Base-32, Base-16)
paragonie/random_compat v9.99.100 PHP 5.x polyfill for random_bytes() and random_int() from PHP 7
phar-io/manifest 2.0.1 Component for reading phar.io manifest information from a PHP Archive (PHAR)
phar-io/version 3.1.0 Library for handling version information and constraints
phpdocumentor/reflection-common 2.2.0 Common reflection classes used by phpdocumentor to reflect the code structure
phpdocumentor/reflection-docblock 5.2.2 With this component, a library can provide support for annotations via DocBlocks or otherwise retrieve information that is embedded in a...
phpdocumentor/type-resolver 1.4.0 A PSR-5 based resolver of Class names, Types and Structural Element Names
phpseclib/phpseclib 3.0.8 PHP Secure Communications Library - Pure-PHP implementations of RSA, AES, SSH2, SFTP, X.509 etc.
phpspec/prophecy 1.13.0 Highly opinionated mocking framework for PHP 5.3+
phpunit/php-code-coverage 9.2.6 Library that provides collection, processing, and rendering functionality for PHP code coverage information.
phpunit/php-file-iterator 3.0.5 FilterIterator implementation that filters files based on a list of suffixes.
phpunit/php-invoker 3.1.1 Invoke callables with a timeout
phpunit/php-text-template 2.0.4 Simple template engine.
phpunit/php-timer 5.0.3 Utility class for timing
phpunit/phpunit 9.5.4 The PHP Unit Testing framework.
psr/cache 1.0.1 Common interface for caching libraries
psr/container 1.1.1 Common Container Interface (PHP FIG PSR-11)
psr/http-client 1.0.1 Common interface for HTTP clients
psr/http-message 1.0.1 Common interface for HTTP messages
psr/log 1.1.4 Common interface for logging libraries
psr/simple-cache 1.0.1 Common interfaces for simple caching
ralouphie/getallheaders 3.0.3 A polyfill for getallheaders.
ramsey/collection 1.1.3 A PHP 7.2+ library for representing and manipulating collections.
ramsey/uuid 4.1.1 A PHP library for generating and working with universally unique identifiers (UUIDs).
react/promise v2.8.0 A lightweight implementation of CommonJS Promises/A for PHP
sebastian/cli-parser 1.0.1 Library for parsing CLI options
sebastian/code-unit 1.0.8 Collection of value objects that represent the PHP code units
sebastian/code-unit-reverse-lookup 2.0.3 Looks up which function or method a line of code belongs to
sebastian/comparator 4.0.6 Provides the functionality to compare PHP values for equality
sebastian/complexity 2.0.2 Library for calculating the complexity of PHP code units
sebastian/diff 4.0.4 Diff implementation
sebastian/environment 5.1.3 Provides functionality to handle HHVM/PHP environments
sebastian/exporter 4.0.3 Provides the functionality to export PHP variables for visualization
sebastian/global-state 5.0.2 Snapshotting of global state
sebastian/lines-of-code 1.0.3 Library for counting the lines of code in PHP source code
sebastian/object-enumerator 4.0.4 Traverses array structures and object graphs to enumerate all referenced objects
sebastian/object-reflector 2.0.4 Allows reflection of object attributes, including inherited and non-public ones
sebastian/recursion-context 4.0.4 Provides functionality to recursively process PHP variables
sebastian/resource-operations 3.0.3 Provides a list of PHP built-in functions that operate on resources
sebastian/type 2.3.1 Collection of value objects that represent the types of the PHP type system
sebastian/version 3.0.2 Library that helps with managing the version number of Git-hosted PHP projects
seld/jsonlint 1.8.3 JSON Linter
seld/phar-utils 1.1.1 PHAR file format utilities, for when PHP phars you up
symfony/cache v5.3.0 Provides an extended PSR-6, PSR-16 (and tags) implementation
symfony/cache-contracts v2.4.0 Generic abstractions related to caching
symfony/console v5.3.2 Eases the creation of beautiful and testable command line interfaces
symfony/css-selector v5.3.0 Converts CSS selectors to XPath expressions
symfony/deprecation-contracts v2.4.0 A generic function and convention to trigger deprecation notices
symfony/dom-crawler v5.3.0 Eases DOM navigation for HTML and XML documents
symfony/filesystem v5.3.0 Provides basic utilities for the filesystem
symfony/finder v5.3.0 Finds files and directories via an intuitive fluent interface
symfony/polyfill-ctype v1.22.1 Symfony polyfill for ctype functions
symfony/polyfill-intl-grapheme v1.23.0 Symfony polyfill for intl's grapheme_* functions
symfony/polyfill-intl-normalizer v1.23.0 Symfony polyfill for intl's Normalizer class and related functions
symfony/polyfill-mbstring v1.23.0 Symfony polyfill for the Mbstring extension
symfony/polyfill-php73 v1.23.0 Symfony polyfill backporting some PHP 7.3+ features to lower PHP versions
symfony/polyfill-php80 v1.23.0 Symfony polyfill backporting some PHP 8.0+ features to lower PHP versions
symfony/process v5.3.2 Executes commands in sub-processes
symfony/service-contracts v2.4.0 Generic abstractions related to writing services
symfony/string v5.3.2 Provides an object-oriented API to strings and deals with bytes, UTF-8 code points and grapheme clusters in a unified way
symfony/var-exporter v5.3.2 Allows exporting any serializable PHP data structure to plain PHP code
theseer/tokenizer 1.2.0 A small library for converting tokenized PHP source code into XML and potentially other formats
webmozart/assert 1.10.0 Assertions to validate method input/output with nice error messages

qr2assistme's People

Contributors

joelsodias avatar

Stargazers

Umair Ali avatar

Watchers

avatar

qr2assistme's Issues

Mysql error

I am on windows 10. Mysql 5.7. I see following error

refresh.bat
starting refresh database

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:20 UTC-03:00

Rolling back migrations to batch: 0
Done rolling back migrations.
Running all new migrations...

[mysqli_sql_exception]

Invalid default value for 'created_at'

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('CREATE TABLE user_access (
created_at TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
updated_at TIMESTAMP NULL DEFAULT 'CURRENT_TIMESTAMP',
deleted_at TIMESTAMP NULL,
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_uid CHAR(36) NOT NULL,
grant_key VARCHAR(30) NOT NULL,
permission ENUM("deny","allow") NOT NULL,
CONSTRAINT pk_user_access PRIMARY KEY(id),
KEY user_uid (user_uid),
UNIQUE KEY user_uid_grant_key (user_uid, grant_key)
) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('CREATE TABLE user_access (
created_at TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
updated_at TIMESTAMP NULL DEFAULT 'CURRENT_TIMESTAMP',
deleted_at TIMESTAMP NULL,
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_uid CHAR(36) NOT NULL,
grant_key VARCHAR(30) NOT NULL,
permission ENUM("deny","allow") NOT NULL,
CONSTRAINT pk_user_access PRIMARY KEY(id),
KEY user_uid (user_uid),
UNIQUE KEY user_uid_grant_key (user_uid, grant_key)
) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('CREATE TABLE user_access (
created_at TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
updated_at TIMESTAMP NULL DEFAULT 'CURRENT_TIMESTAMP',
deleted_at TIMESTAMP NULL,
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_uid CHAR(36) NOT NULL,
grant_key VARCHAR(30) NOT NULL,
permission ENUM("deny","allow") NOT NULL,
CONSTRAINT pk_user_access PRIMARY KEY(id),
KEY user_uid (user_uid),
UNIQUE KEY user_uid_grant_key (user_uid, grant_key)
) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci')

4 SYSTEMPATH\Database\Forge.php:513
CodeIgniter\Database\BaseConnection()->query('CREATE TABLE user_access (
created_at TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
updated_at TIMESTAMP NULL DEFAULT 'CURRENT_TIMESTAMP',
deleted_at TIMESTAMP NULL,
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_uid CHAR(36) NOT NULL,
grant_key VARCHAR(30) NOT NULL,
permission ENUM("deny","allow") NOT NULL,
CONSTRAINT pk_user_access PRIMARY KEY(id),
KEY user_uid (user_uid),
UNIQUE KEY user_uid_grant_key (user_uid, grant_key)
) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci')

5 APPPATH\Database\Migrations\20210414-214700_user_access.php:42
CodeIgniter\Database\Forge()->createTable('user_access')

6 SYSTEMPATH\Database\MigrationRunner.php:863
App\Database\Migrations\UserAccessTable()->up()

7 SYSTEMPATH\Database\MigrationRunner.php:186
CodeIgniter\Database\MigrationRunner()->migrate('up', Object(stdClass))

8 SYSTEMPATH\Commands\Database\Migrate.php:84
CodeIgniter\Database\MigrationRunner()->latest(null)

9 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Migrate()->run([...])

10 SYSTEMPATH\CLI\BaseCommand.php:112
CodeIgniter\CLI\Commands()->run('migrate', [...])

11 SYSTEMPATH\Commands\Database\MigrateRefresh.php:85
CodeIgniter\CLI\BaseCommand()->call('migrate', [...])

12 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\MigrateRefresh()->run([...])

13 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('migrate:refresh', [])

14 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([])

15 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'migrate:refresh')

16 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

17 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

18 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

19 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed table 'customer'

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:24 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.customer' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('INSERT INTO customer (customer_uid, customer_email, customer_name) VALUES ('1ec6f1b3-a2b4-6ed8-a94d-5539f8a47590', '[email protected]', 'Kléber Padrão')', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('INSERT INTO customer (customer_uid, customer_email, customer_name) VALUES ('1ec6f1b3-a2b4-6ed8-a94d-5539f8a47590', '[email protected]', 'Kléber Padrão')')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('INSERT INTO customer (customer_uid, customer_email, customer_name) VALUES ('1ec6f1b3-a2b4-6ed8-a94d-5539f8a47590', '[email protected]', 'Kléber Padrão')')

4 SYSTEMPATH\Database\BaseBuilder.php:1771
CodeIgniter\Database\BaseConnection()->query('INSERT INTO customer (customer_uid, customer_email, customer_name) VALUES (:customer_uid:, :customer_email:, :customer_name:)', [...], false)

5 SYSTEMPATH\Model.php:239
CodeIgniter\Database\BaseBuilder()->insert()

6 SYSTEMPATH\BaseModel.php:738
CodeIgniter\Model()->doInsert([...])

7 SYSTEMPATH\Model.php:625
CodeIgniter\BaseModel()->insert([...], true)

8 APPPATH\Models\CustomerModel.php:75
CodeIgniter\Model()->insert(Object(App\Entities\CustomerEntity), true)

9 APPPATH\Database\Seeds\CustomerSeeder.php:15
App\Models\CustomerModel()->createCustomer()

10 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\CustomerSeeder()->run()

11 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\CustomerSeeder')

12 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

13 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

14 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

15 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'CustomerSeeder')

16 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

17 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

18 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

19 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed table 'worker'

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:28 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.worker' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('INSERT INTO worker (worker_uid, worker_type, worker_name, worker_email, worker_avatar, worker_description) VALUES ('1ec6f1b3-ae55-61b6-a212-b1d548b2ba60', 'attendant', 'Arthur Teles', '[email protected]', '/images/avatar/worker.png', 'description for worker')', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('INSERT INTO worker (worker_uid, worker_type, worker_name, worker_email, worker_avatar, worker_description) VALUES ('1ec6f1b3-ae55-61b6-a212-b1d548b2ba60', 'attendant', 'Arthur Teles', '[email protected]', '/images/avatar/worker.png', 'description for worker')')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('INSERT INTO worker (worker_uid, worker_type, worker_name, worker_email, worker_avatar, worker_description) VALUES ('1ec6f1b3-ae55-61b6-a212-b1d548b2ba60', 'attendant', 'Arthur Teles', '[email protected]', '/images/avatar/worker.png', 'description for worker')')

4 SYSTEMPATH\Database\BaseBuilder.php:1771
CodeIgniter\Database\BaseConnection()->query('INSERT INTO worker (worker_uid, worker_type, worker_name, worker_email, worker_avatar, worker_description) VALUES (:worker_uid:, :worker_type:, :worker_name:, :worker_email:, :worker_avatar:, :worker_description:)', [...], false)

5 SYSTEMPATH\Model.php:239
CodeIgniter\Database\BaseBuilder()->insert()

6 SYSTEMPATH\BaseModel.php:738
CodeIgniter\Model()->doInsert([...])

7 SYSTEMPATH\Model.php:625
CodeIgniter\BaseModel()->insert([...], true)

8 APPPATH\Database\Seeds\WorkerSeeder.php:34
CodeIgniter\Model()->insert(Object(App\Entities\WorkerEntity), true)

9 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\WorkerSeeder()->run()

10 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\WorkerSeeder')

11 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

12 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

13 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

14 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'WorkerSeeder')

15 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

16 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

17 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

18 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed 'chat_user' table

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:28 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.chat_user' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('INSERT INTO chat_user (chat_user_uid, user_name, user_email, user_avatar, user_type) VALUES ('1ec6f1b3-b5f0-6f4c-9688-a39fb646817a', 'Dr. Giovana Sônia Bezerra Neto', '[email protected]', 'https://source.unsplash.com/300x300/?face&1ec6f1b3-b5f0-6f4c-9688-a39fb646817a\', 'attendee')', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('INSERT INTO chat_user (chat_user_uid, user_name, user_email, user_avatar, user_type) VALUES ('1ec6f1b3-b5f0-6f4c-9688-a39fb646817a', 'Dr. Giovana Sônia Bezerra Neto', '[email protected]', 'https://source.unsplash.com/300x300/?face&1ec6f1b3-b5f0-6f4c-9688-a39fb646817a\', 'attendee')')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('INSERT INTO chat_user (chat_user_uid, user_name, user_email, user_avatar, user_type) VALUES ('1ec6f1b3-b5f0-6f4c-9688-a39fb646817a', 'Dr. Giovana Sônia Bezerra Neto', '[email protected]', 'https://source.unsplash.com/300x300/?face&1ec6f1b3-b5f0-6f4c-9688-a39fb646817a\', 'attendee')')

4 SYSTEMPATH\Database\BaseBuilder.php:1771
CodeIgniter\Database\BaseConnection()->query('INSERT INTO chat_user (chat_user_uid, user_name, user_email, user_avatar, user_type) VALUES (:chat_user_uid:, :user_name:, :user_email:, :user_avatar:, :user_type:)', [...], false)

5 SYSTEMPATH\Model.php:239
CodeIgniter\Database\BaseBuilder()->insert()

6 SYSTEMPATH\BaseModel.php:738
CodeIgniter\Model()->doInsert([...])

7 SYSTEMPATH\Model.php:625
CodeIgniter\BaseModel()->insert([...], true)

8 APPPATH\Database\Seeds\ChatUserSeeder.php:39
CodeIgniter\Model()->insert(Object(App\Entities\ChatUserEntity), true)

9 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\ChatUserSeeder()->run()

10 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\ChatUserSeeder')

11 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

12 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

13 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

14 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'ChatUserSeeder')

15 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

16 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

17 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

18 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed table 'chat_session'

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:29 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.chat_user' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('SELECT *
FROM chat_user
WHERE user_type = 'attendee'
AND chat_user_uid NOT IN (SELECT attendee_uid FROM chat_session)
LIMIT 1', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('SELECT *
FROM chat_user
WHERE user_type = 'attendee'
AND chat_user_uid NOT IN (SELECT attendee_uid FROM chat_session)
LIMIT 1')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('SELECT *
FROM chat_user
WHERE user_type = 'attendee'
AND chat_user_uid NOT IN (SELECT attendee_uid FROM chat_session)
LIMIT 1')

4 SYSTEMPATH\Database\BaseBuilder.php:1455
CodeIgniter\Database\BaseConnection()->query('SELECT *
FROM chat_user
WHERE user_type = :user_type:
AND chat_user_uid NOT IN :chat_user_uid:
LIMIT 1', [...], false)

5 APPPATH\Models\ChatUserModel.php:79
CodeIgniter\Database\BaseBuilder()->get()

6 APPPATH\Database\Seeds\ChatSessionSeeder.php:16
App\Models\ChatUserModel()->getRandomChatUserWithNoChatSessions('attendee')

7 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\ChatSessionSeeder()->run()

8 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\ChatSessionSeeder')

9 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

10 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

11 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

12 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'ChatSessionSeeder')

13 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

14 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

15 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

16 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed Customer table 'qrobject'

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:30 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.customer' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('SELECT *
FROM customer
ORDER BY RAND()
LIMIT 1', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('SELECT *
FROM customer
ORDER BY RAND()
LIMIT 1')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('SELECT *
FROM customer
ORDER BY RAND()
LIMIT 1')

4 SYSTEMPATH\Database\BaseBuilder.php:1455
CodeIgniter\Database\BaseConnection()->query('SELECT *
FROM customer
ORDER BY RAND()
LIMIT 1', [], false)

5 APPPATH\Models\CustomerModel.php:25
CodeIgniter\Database\BaseBuilder()->get()

6 APPPATH\Database\Seeds\QrObjectSeeder.php:100
App\Models\CustomerModel()->getRandomCustomer()

7 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\QrObjectSeeder()->run()

8 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\QrObjectSeeder')

9 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

10 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

11 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

12 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'QrObjectSeeder')

13 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

14 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

15 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

16 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

starting seed Customer table 'schedule'

CodeIgniter v4.1.6 Command Line Tool - Server Time: 2022-01-06 15:05:31 UTC-03:00

[mysqli_sql_exception]

Table 'qrassist.worker' doesn't exist

at SYSTEMPATH\Database\MySQLi\Connection.php:292

Backtrace:
1 SYSTEMPATH\Database\MySQLi\Connection.php:292
mysqli()->query('SELECT *
FROM worker
WHERE worker_type = 'field'
LIMIT 1', 0)

2 SYSTEMPATH\Database\BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute('SELECT *
FROM worker
WHERE worker_type = 'field'
LIMIT 1')

3 SYSTEMPATH\Database\BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery('SELECT *
FROM worker
WHERE worker_type = 'field'
LIMIT 1')

4 SYSTEMPATH\Database\BaseBuilder.php:1455
CodeIgniter\Database\BaseConnection()->query('SELECT *
FROM worker
WHERE worker_type = :worker_type:
LIMIT 1', [...], false)

5 APPPATH\Models\WorkerModel.php:64
CodeIgniter\Database\BaseBuilder()->get(1, 0)

6 APPPATH\Database\Seeds\ScheduleSeeder.php:47
App\Models\WorkerModel()->getRandomWorker('field')

7 SYSTEMPATH\Database\Seeder.php:147
App\Database\Seeds\ScheduleSeeder()->run()

8 SYSTEMPATH\Commands\Database\Seed.php:77
CodeIgniter\Database\Seeder()->call('App\Database\Seeds\ScheduleSeeder')

9 SYSTEMPATH\CLI\Commands.php:63
CodeIgniter\Commands\Database\Seed()->run([])

10 SYSTEMPATH\CLI\CommandRunner.php:70
CodeIgniter\CLI\Commands()->run('db:seed', [...])

11 SYSTEMPATH\CLI\CommandRunner.php:56
CodeIgniter\CLI\CommandRunner()->index([...])

12 SYSTEMPATH\CodeIgniter.php:823
CodeIgniter\CLI\CommandRunner()->_remap('index', 'db:seed', 'ScheduleSeeder')

13 SYSTEMPATH\CodeIgniter.php:412
CodeIgniter\CodeIgniter()->runController(Object(CodeIgniter\CLI\CommandRunner))

14 SYSTEMPATH\CodeIgniter.php:320
CodeIgniter\CodeIgniter()->handleRequest(null, Object(Config\Cache), false)

15 SYSTEMPATH\CLI\Console.php:48
CodeIgniter\CodeIgniter()->run()

16 ROOTPATH\spark:66
CodeIgniter\CLI\Console()->run()

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.