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