[php] ads
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
- class AssetRegistration {
- static listCompany(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 100
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `com.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND (com.name LIKE ${q} ) ` : ``}
- AND com.asset_code <> ""
- `;
- let data = ` com.* `
- let table = ` tb_company AS com `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listTPM(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 10
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `tpm.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( OR tpm.name_th LIKE ${q} OR tpm.code LIKE ${q} )` : ``}
- `;
- let data = `
- tpm.id AS id,
- tpm.code AS code,
- tpm.name_th AS title,
- tpm.status AS status,
- '0' AS isRemove
- `;
- let table = ` tb_tpm_inventory AS tpm `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listCST(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 10
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `cst.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( cst.code LIKE ${q} OR cst.title LIKE ${q} )` : ``}
- `;
- let data = `
- cst.id AS id,
- cst.code AS code,
- cst.title AS title,
- '' AS status,
- cst.is_remove AS isRemove
- `;
- let table = ` tb_cst_inventory_item AS cst `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listHRM(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 10
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `hrm.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( hrm.code LIKE ${q} OR hrm.name LIKE ${q} )` : ``}
- `;
- let data = `
- hrm.id AS id,
- hrm.code AS code,
- hrm.name AS title,
- hrm.status AS status,
- '0' AS isRemove
- `;
- let table = ` tb_global_inventory AS hrm `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listITS(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 10
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `its.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( its.code LIKE ${q} OR its.title LIKE ${q} OR its.model LIKE ${q} )` : ``}
- `;
- let data = `
- its.id AS id,
- its.code AS code,
- its.model AS title,
- its.status AS status,
- its.isRemove AS isRemove
- `;
- let table = ` tb_its_inventory AS its `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listQAS(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 10
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `qas.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( qas.code LIKE ${q} OR qas.title LIKE ${q} OR qas.model LIKE ${q} )` : ``}
- `;
- let data = `
- qas.id AS id,
- qas.code AS code,
- qas.title AS title,
- qas.status AS status,
- '0' AS isRemove
- `;
- let table = ` tb_qas_inventory AS qas `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listType(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 99999
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( title LIKE ${q} OR title_eng LIKE ${q} )` : ``}
- `;
- let data = ` * `;
- let table = ` tb_asset_type `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static listSub(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 99999
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- if (!req.params.type) {
- return res.json({ rows: [], total: 0 });
- }
- let primary = `id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id} ` : ''}
- ${q ? ` AND ( title LIKE ${q} OR description LIKE ${q} )` : ``}
- AND status <> "remove"
- `;
- let data = ` * `;
- let table = ` tb_asset_category `;
- let join = ` `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static list(req, res) {
- let page = req.body.page ? parseInt(req.body.page) : 1
- let rows = req.body.rows ? parseInt(req.body.rows) : 100
- let start = ((rows * page) - rows);
- let q = req.body.q ? req.mysql.escape(`%${req.body.q}%`) : '';
- let current = req.body.current ? req.mysql.escape(req.body.current) : 0;
- let id = req.params.id ? req.mysql.escape(req.params.id) : 0;
- let primary = `ar.id`;
- let condition = `
- ${id ? ` AND ${primary} = ${id}` : ``}
- ${q ? ` AND ( ar.title LIKE ${q} OR ar.code LIKE ${q} ) ` : ``}
- ${req.body.fromDate ? ` AND ar.entry_date >= ${req.mysql.escape(`${req.body.fromDate} 00:00:00`)} ` : ``}
- ${req.body.toDate ? ` AND ar.entry_date <= ${req.mysql.escape(`${req.body.toDate} 23:59:59`)} ` : ``}
- ${req.body.owner ? ` AND dep.code LIKE ${req.mysql.escape(`%${req.body.owner}%`)} ` : ``}
- ${req.body.code ? ` AND ar.code LIKE ${req.mysql.escape(`%${req.body.code}%`)} ` : ``}
- ${req.body.title ? ` AND ar.title LIKE ${req.mysql.escape(`%${req.body.title}% `)} ` : ``}
- ${req.body.status ? ` AND ar.status = ${req.mysql.escape(req.body.status)}` : ``}
- AND ar.status <> "remove"
- `;
- let data = `
- ar.*,
- DATE_FORMAT(ar.entry_date, "%Y-%m-%d") AS entry_date,
- DATE_FORMAT(ar.update_date, "%Y-%m-%d") AS update_date,
- ar.code AS code,
- CONCAT(entry_em.firstname," ",entry_em.lastname) AS entryFullname,
- dep.code AS depCode,
- dep.title AS depTitle,
- ( CASE
- WHEN dep.code = "TPM" THEN (SELECT code FROM tb_tpm_inventory AS tpm WHERE ar.asset = tpm.id)
- WHEN dep.code = "CST" THEN (SELECT code FROM tb_cst_inventory_item AS cst WHERE ar.asset = cst.id)
- WHEN dep.code = "HRM" THEN (SELECT code FROM tb_global_inventory AS hrm WHERE ar.asset = hrm.id)
- WHEN dep.code = "ITS" THEN (SELECT code FROM tb_its_inventory AS its WHERE ar.asset = its.id)
- WHEN dep.code = "QAS" THEN (SELECT code FROM tb_qas_inventory AS qas WHERE ar.asset = qas.id)
- ELSE ""
- END ) AS assetCode,
- ( CASE
- WHEN dep.code = "TPM" THEN (SELECT status FROM tb_tpm_inventory AS tpm WHERE ar.asset = tpm.id)
- WHEN dep.code = "CST" THEN ''
- WHEN dep.code = "HRM" THEN (SELECT status FROM tb_global_inventory AS hrm WHERE ar.asset = hrm.id)
- WHEN dep.code = "ITS" THEN (SELECT status FROM tb_its_inventory AS its WHERE ar.asset = its.id)
- WHEN dep.code = "QAS" THEN (SELECT status FROM tb_qas_inventory AS qas WHERE ar.asset = qas.id)
- ELSE ""
- END ) AS assetStatus
- `;
- let table = ` tb_asset_registration AS ar `;
- let join = `
- LEFT JOIN tb_employee AS entry_em ON entry_em.id = ar.entry_by
- LEFT JOIN tb_department AS dep ON dep.id = ar.owner
- `;
- let orderby = ` ORDER BY ${primary} DESC `
- let limit = req.body.page == 0 || req.body.page == "0" ? '' : ` LIMIT ${start},${rows} `
- let UNION = !q ? (current ? `UNION ( SELECT ${data} FROM ${table} ${join} WHERE ${primary} = ${current} ) ` : '') : ''
- let sql = `SELECT COUNT(${primary}) AS total FROM ${table} ${join} WHERE 1 ${condition};`
- sql += `( SELECT ${data} FROM ${table} ${join} WHERE 1 ${condition} ${orderby} ${limit} ) ${UNION} `
- data = { rows: [], total: 0 }
- return new Promise(function (fulfill, reject) {
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.rows = result[1]
- data.total = result[0][0].total
- }
- return req.body.pivot ? fulfill(data) : res.json(data);
- });
- });
- }
- static insert(req, res) {
- let data = { success: false, errorMsg: '' }
- delete req.body.action
- req.body['entry_by'] = req.headers.user;
- req.body['entry_date'] = $moment().format('YYYY-MM-DD HH:mm:ss');
- let [fields, value, count, length] = ['', '', 0, Object.keys(req.body).length];
- for (let key in req.body) {
- count++;
- if (req.body[key]) {
- fields += `${key}${count < length ? "," : ""}`;
- value += `${req.mysql.escape(req.body[key])}${count < length ? "," : ""}`;
- }
- }
- let sql = `INSERT INTO tb_asset_registration (${fields}) VALUES (${value})`
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.success = true
- data.errorMsg = ''
- data.id = result.insertId
- }
- res.json(data)
- })
- }
- static save(req, res) {
- let data = { success: false, errorMsg: '' }
- delete req.body.action
- delete req.body.current
- if (!req.body.id) {
- data.errorMsg = "Error : object without id"
- return res.json(data)
- }
- req.body['update_by'] = req.headers.user;
- req.body['update_date'] = $moment().format('YYYY-MM-DD HH:mm:ss');
- let [set, count, length] = ['', 0, Object.keys(req.body).length];
- for (let key in req.body) {
- count++;
- set += `${key} = '${req.body[key]}' ${count < length ? "," : ""} `;
- }
- let sql = `UPDATE tb_asset_registration SET ${set} WHERE id = ${req.mysql.escape(req.body.id)}`
- req.con.query(sql, function (err, result) {
- if (err) {
- data.errorMsg = err
- console.error(err)
- } else {
- data.success = true
- data.errorMsg = ''
- }
- res.json(data)
- })
- }
- static remove(req, res) {
- let data = { success: false, errorMsg: '' }
- delete req.body.action
- if (!req.body.id) {
- data.errorMsg = "Error : object without id"
- return res.json(data)
- }
- req.body = {
- 'id': req.body.id,
- 'status': 'remove'
- };
- AssetRegistration.save(req, res);
- }
- // static async pivot(req, res) {
- // req.body.pivot = true;
- // let data = AssetRegistration.list(req, res);
- // data = await data.then(result => result)
- // await res.json(data)
- // }
- }
Editor
You can edit this paste and save as new:
File Description
- ads
- Paste Code
- 24 Jan-2022
- 19.09 Kb
You can Share it:
Latest Code Pastes