<?php if (strtolower(basename(__DIR__)) === 'powerorm') { require 'Application.php'; } else { require __DIR__ . '/application/libraries/powerorm/Application.php'; } Application::consoleRun(['baseDir' => __DIR__]);
* @param int $campaignId * @param int $userId * @param string $giftbagCode */ private function insertMapping($campaignId, $userId, $giftbagCode) { $campaignId = (int) $campaignId; $userId = (int) $userId; $giftbagCode = addslashes($giftbagCode); $this->mappingValues[] = "{$campaignId},{$userId},'{$giftbagCode}'"; if (count($this->mappingValues) > 1000) { $this->insertMappingFlush(); } } /** * 批量插入 giftbag code - campaign - user的mapping的最终操作 */ private function insertMappingFlush() { if (empty($this->mappingValues) == false) { $db = DatabaseFactory::open(); $db->createCommand(' INSERT INTO g_campaign_mapping_giftbag (campaignId,userId, giftbagCode) VALUES (' . implode('),(', $this->mappingValues) . ') ')->execute(); $this->mappingValues = array(); } } } Application::consoleRun();