ContactActivityMarkStatisticsTable::upsert

static function upsert(array $data)
{
	$fields = array(
		'RESPONSIBLE_ID' => isset($data['RESPONSIBLE_ID']) ? (int)$data['RESPONSIBLE_ID'] : 0,
		'NONE_QTY' => isset($data['NONE_QTY']) ? (int)$data['NONE_QTY'] : 0,
		'POSITIVE_QTY' => isset($data['POSITIVE_QTY']) ? (int)$data['POSITIVE_QTY'] : 0,
		'NEGATIVE_QTY' => isset($data['NEGATIVE_QTY']) ? (int)$data['NEGATIVE_QTY'] : 0
	);

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

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