/**
* Make a SQL INSERT Statement
*
* @param string $tablename
* @param array $values
* @param int $debug = 0 Set to 1 to debug sql-String
* @param array $options
* @return int UID of created record
*/
public static function doInsert($tablename, $values, $debug = 0, array $options = array())
{
if ($options['eleminateNonTcaColumns']) {
$values = tx_mklib_util_TCA::eleminateNonTcaColumnsByTable($tablename, $values);
}
$newUid = tx_rnbase_util_DB::doInsert($tablename, self::insertCrdateAndTimestamp($values, $tablename), $debug);
self::log('doInsert', $tablename, '1=1 AND `' . $tablename . '`.`uid`=\'' . $newUid . '\'', $values);
return $newUid;
}
/**
* Add a reference to a DAM media file
*
* @param string $tableName
* @return int
*/
public static function addReference($tableName, $fieldName, $itemId, $uid)
{
$data = array();
$data['uid_foreign'] = $itemId;
$data['uid_local'] = $uid;
$data['tablenames'] = $tableName;
$data['ident'] = $fieldName;
$id = tx_rnbase_util_DB::doInsert('tx_dam_mm_ref', $data);
// Now count all items
self::updateImageCount($tableName, $fieldName, $itemId);
return $id;
}
/**
* Fügt eine Referenz hinzu
*
* @param string $sTableName
* @param string $sFieldName
* @param int $iItemId (Referenz Datensatz)
* @param int $iUid (DAM Datensatz)
* @param boolean $bUpdateCount
* @return int
*/
public static function addReference($sTableName, $sFieldName, $iItemId, $iUid, $bUpdateCount = true)
{
if (!self::isLoaded()) {
return 0;
}
$aData = array();
$aData['uid_foreign'] = $iItemId;
$aData['uid_local'] = $iUid;
$aData['tablenames'] = $sTableName;
$aData['ident'] = $sFieldName;
$iId = tx_rnbase_util_DB::doInsert('tx_dam_mm_ref', $aData);
// Now count all items
if ($bUpdateCount) {
self::updateImageCount($sTableName, $sFieldName, $iItemId);
}
return $iId;
}
/**
* Create a new record
*
* @param array $data
* @param string $table
* @return int UID of just created record
*/
public function create(array $data)
{
$model = $this->getDummyModel();
$table = $model->getTableName();
tx_rnbase::load('tx_rnbase_util_DB');
$newUid = tx_rnbase_util_DB::doInsert($table, self::insertCrdateAndTimestamp($data, $table));
return $newUid;
}
/**
* Add a reference to a DAM media file
*
* @param string $tableName
* @param string $fieldName
* @param int $itemId
* @param int $mediaUid
* @param int $pId
* @return int
*/
public static function addReference($tableName, $fieldName, $itemId, $mediaUid, $pId = 0)
{
$data = array();
$data['pid'] = $pId;
$data['uid_foreign'] = $itemId;
$data['uid_local'] = $mediaUid;
$data['tstamp'] = $data['crdate'] = time();
$data['tablenames'] = $tableName;
$data['fieldname'] = $fieldName;
$data['sorting_foreign'] = 1;
$data['table_local'] = 'sys_file';
$id = tx_rnbase_util_DB::doInsert('sys_file_reference', $data);
// Now count all items
self::updateImageCount($tableName, $fieldName, $itemId);
return $id;
}
