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); }