function addKml($returndata, $kmls, $topic) { $result = formatKml($returndata, $kmls); $dsn = getconfig('dsn'); $user = getconfig('user'); $pwd = getconfig('pwd'); $table = getconfig('table'); $db = new PDO($dsn, $user, $pwd); $arr[] = ''; $sql = "INSERT INTO {$table} (`storeId`,`distribution`,`rtNum`,`kmlStatus`,`itno`,`qty`,`docTime`,`createTime`,`updateTime`,`kmlPath`) VALUES "; foreach ($result as $k => $arr) { $sql .= '("' . $arr['storeId'] . '","' . $arr['distribution'] . '","' . $arr['rtNum'] . '","' . $arr['kmlStatus'] . '","' . $arr['itno'] . '","' . $arr['qty'] . '","' . $arr['docTime'] . '","' . $arr['createTime'] . '","' . date('Y-m-d H:i:s', time()) . '","' . $arr['kmlPath'] . '"),'; } $sql = substr($sql, 0, strlen($sql) - 1); $row = $db->exec($sql); if (empty($lastId)) { logs('error insert into, SQL:' . $sql, 2, 'consumer', $topic); } return $row; }
function insertKafka($kmldata, $f) { $formatArr = formatKml($kmldata, $f); if (!empty($formatArr)) { foreach ($formatArr as $k => $list) { $rows = array_chunk($list, 50); foreach ($rows as $row) { kafka::getInstance()->sendList($k, $row); } } } }