Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- {
- function logging_1c($params = array()) {
- { /* reset some values */
- if (!(($params['do'] == 'set' && !isset($params['ros_name'][1])) || $params['do'] == 'get')) {
- $params['do'] = 'get';
- }
- $params['status'] = $params['status'] ? $params['status'] : "S";
- $params['time_start'] = date('Y:m:d H:i:s');
- }
- function check_table (&$params) {
- $params['mysql_link'] = mysql_connect('localhost', 'pl', 'pl');
- if (mysql_select_db('pl', $params['mysql_link'])) {
- return mysql_query('CREATE TABLE IF NOT EXISTS logging_1c (
- id SERIAL,
- ros_name VARCHAR(200) NOT NULL,
- time_finish TIMESTAMP NOT NULL DEFAULT 00000000000000,
- time_start TIMESTAMP NOT NULL,
- status VARCHAR(1) NOT NULL,
- action VARCHAR(100) NOT NULL,
- PRIMARY KEY (id)
- )', $params['mysql_link']);
- }
- return false;
- }
- function set (&$params) {
- function set_add_row (&$params) {
- return mysql_query('INSERT INTO logging_1c SET
- ros_name="'.$params['ros_name'].'",
- time_finish="'.$params['time_finish'].'",
- time_start="'.$params['time_start'].'",
- status="'.$params['status'].'",
- action="'.$params['action'].'"'
- );
- };
- function set_update_row (&$params) {
- return mysql_query('UPDATE logging_1c
- SET
- status="'.$params['status'].'",
- time_finish="'.$params['time_start'].'"
- WHERE
- id="'.$params['id'].'"'
- );
- };
- $ar_res = mysql_fetch_assoc(mysql_query('SELECT id, ros_name, time_start FROM logging_1c WHERE status="S"'));
- if ($ar_res) {
- $params['id'] = $ar_res['id'];
- if ($ar_res['ros_name'] == $params['ros_name'] && $params['status'] == "F") {
- set_update_row($params);
- }
- elseif ($ar_res['ros_name'] == $params['ros_name'] || (date('U') - strtotime($ar_res['time_start']) > 3600)) {
- set_add_row($params);
- $params['status'] = "W";
- set_update_row($params);
- }
- else {
- $params['status'] = "B";
- $params['time_finish'] = $params['time_start'];
- set_add_row($params);
- return false;
- }
- }
- else {
- set_add_row($params);
- }
- return true;
- };
- // $get = function () use ($params) {
- // };
- return check_table($params) && call_user_func($params['do'], $params);
- }
- }
- logging_1c(array('do' => 'set', 'ros_name' => 'ГРК', 'action' => 'Обмен заказами'));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement