function create_queue($classname, $connection)
{
$prepare = new ex_class($connection);
$sql = "SHOW TABLES LIKE 'queue_{$classname}'";
$res = $prepare->get_sql_array($sql);
//echo $sql;
if (count($res) == 0) {
$sql = "CREATE TABLE IF NOT EXISTS `queue_{$classname}` ( " . " `id` int(11) NOT NULL," . " `date` datetime NOT NULL," . " `queuename` varchar(50) NOT NULL," . " `metod` varchar(50) NOT NULL," . " `q` varchar(500) NOT NULL," . " `bodyq` longtext NOT NULL" . " ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\r\n";
$res = $prepare->get_sql_array($sql);
$sql = " ALTER TABLE `queue_{$classname}`" . " ADD PRIMARY KEY (`id`)," . " ADD FULLTEXT KEY `queuename` (`queuename`);\r\n";
$res = $prepare->get_sql_array($sql);
$sql = " ALTER TABLE `queue_{$classname}`" . " MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;";
$res = $prepare->get_sql_array($sql);
}
}
public function insert_into_kih($id)
{
$result = $id;
$connectionInfo = array("type" => "MSSQL", "host" => "192.168.10.30", "db" => "CMS_1C_EXCHENGE_TEST", "user" => "sa", "pass" => "1CAdmin");
$MSSQL_class = new ex_class($connectionInfo);
$array = $this->get_by_id('queue', $id);
$tag = $array[0];
$input = $tag['q'];
$query = explode('/', $input);
$json = $tag['bodyq'];
$forsql['id'] = $id;
$forsql['date'] = str_ireplace(" ", "T", $tag['date']);
//strtotime($tag['date']);//
$forsql['mode'] = $query[0];
$forsql['messageid'] = $query[1];
$forsql['data'] = $json;
$msaddon['dbo'] = "[CMS_1C_EXCHENGE_TEST].[dbo].";
$result = $MSSQL_class->insert("ats24", $forsql, $msaddon);
return $result;
}
public function __construct($connectionInfo)
{
parent::__construct($connectionInfo);
}
