/** * 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; }