LeadConversionStatisticsTable::upsert

static function upsert(array $data)
{
	$fields = array(
		'CREATED_DATE' => isset($data['CREATED_DATE']) ? $data['CREATED_DATE'] : null,
		'RESPONSIBLE_ID' => isset($data['RESPONSIBLE_ID']) ? $data['RESPONSIBLE_ID'] : 0,
		'CONTACT_QTY' => isset($data['CONTACT_QTY']) ? $data['CONTACT_QTY'] : 0,
		'COMPANY_QTY' => isset($data['COMPANY_QTY']) ? $data['COMPANY_QTY'] : 0,
		'DEAL_QTY' => isset($data['DEAL_QTY']) ? $data['DEAL_QTY'] : 0,
		'TOTALS_DATE' => isset($data['TOTALS_DATE']) ? $data['TOTALS_DATE'] : null,
	);

	$connection = Main\Application::getConnection();
	$queries = $connection->getSqlHelper()->prepareMerge(
		'b_crm_lead_conv_stat',
		array('OWNER_ID', 'ENTRY_DATE'),
		array_merge(
			$fields,
			array(
				'OWNER_ID' => isset($data['OWNER_ID']) ? $data['OWNER_ID'] : 0,
				'ENTRY_DATE' => isset($data['ENTRY_DATE']) ? $data['ENTRY_DATE'] : null
			)
		),
		$fields
	);

	foreach($queries as $query)
	{
		$connection->queryExecute($query);
	}
}