Project/plc调度节点/tool/mysql_statistics.h

//
// Created by huli on 2024/3/19.
//

#ifndef NNXX_TESTS_MYSQL_STATISTICS_H
#define NNXX_TESTS_MYSQL_STATISTICS_H

#include <iostream>
#include "../error_code/error_code.h"
//#include "LogFiles.h"
#include <glog/logging.h>
#include <string>
#include <iostream>

//#include "../communication/communication_socket_base.h"

#include "../tool/thread_pool.h"
#include "../system/system_communication.h"
#include "../system/system_executor.h"
#include "../rabbitmq/rabbitmq_base.h"

#include "../dispatch/dispatch_manager.h"
#include "../dispatch/dispatch_communication.h"
#include "../dispatch/dispatch_coordinates.h"
#include "../dispatch/database_controller.h"

#include "../tool/common_data.h"
#include "../tool/time_tool.h"
#include "../tool/mysql_statistics.h"

#include "../rabbitmq/ttt.h"

#include <algorithm>    // std::for_each
#include <google/protobuf/text_format.h>

void sql_test();
int sql_ttt_1(string car_number);
int sql_ttt_2(string car_number);
int sql_ttt_3();
int sql_ttt_4();

//统计进车数量（指定的单元指定的日期）
int mysql_collect_count_for_enqueue(int year, int month, int day, int unit, bool is_insert_row);
//统计一个月的进车数量（指定的单元指定的日期）
int mysql_collect_daily_data_all_unit(int year, int month, int first_day, int end_day);



class mysql_statistics
{

};


#endif //NNXX_TESTS_MYSQL_STATISTICS_H