function ciniki_conferences_roomUpdate(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'room_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference Room'), 'conference_id' => array('required' => 'no', 'blank' => 'no', 'name' => 'Conference'), 'name' => array('required' => 'no', 'blank' => 'no', 'name' => 'Name'), 'sequence' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Order')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.roomUpdate');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.conferences');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the Conference Room in the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectUpdate');
$rc = ciniki_core_objectUpdate($ciniki, $args['business_id'], 'ciniki.conferences.room', $args['room_id'], $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.conferences');
return $rc;
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.conferences');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'conferences');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.conferences.room', 'object_id' => $args['room_id']));
return array('stat' => 'ok');
}
function ciniki_conferences_sessionAdd(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'conference_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Conference'), 'room_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Room'), 'name' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Name'), 'session_start' => array('required' => 'yes', 'blank' => 'no', 'type' => 'datetimetoutc', 'name' => 'Start'), 'session_end' => array('required' => 'yes', 'blank' => 'no', 'type' => 'datetimetoutc', 'name' => 'End')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'conferences', 'private', 'checkAccess');
$rc = ciniki_conferences_checkAccess($ciniki, $args['business_id'], 'ciniki.conferences.sessionAdd');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.conferences');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Add the conference session to the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectAdd');
$rc = ciniki_core_objectAdd($ciniki, $args['business_id'], 'ciniki.conferences.session', $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.conferences');
return $rc;
}
$session_id = $rc['id'];
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.conferences');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'conferences');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.conferences.session', 'object_id' => $session_id));
return array('stat' => 'ok', 'id' => $session_id);
}
function ciniki_artistprofiles_artistAdd(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'name' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Name'), 'subname' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Sub Name'), 'sort_name' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Sort Name'), 'permalink' => array('required' => 'no', 'blank' => 'no', 'name' => 'Permalink'), 'status' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Status'), 'flags' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Options'), 'primary_image_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Primary Image'), 'primary_image_caption' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Primary Image Caption'), 'synopsis' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Synopsis'), 'description' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Description'), 'setup_image_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Setup Image'), 'setup_image_caption' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Setup Image Caption'), 'setup_description' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Description'), 'categories' => array('required' => 'no', 'blank' => 'yes', 'type' => 'list', 'delimiter' => '::', 'name' => 'Categories')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'checkAccess');
$rc = ciniki_artistprofiles_checkAccess($ciniki, $args['business_id'], 'ciniki.artistprofiles.artistAdd');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// If not specified, setup the sort name
//
if (!isset($args['sort_name']) || $args['sort_name'] == '') {
$args['sort_name'] = $args['name'];
}
//
// Setup permalink
//
if (!isset($args['permalink']) || $args['permalink'] == '') {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, $args['name']);
}
//
// Make sure the permalink is unique
//
$strsql = "SELECT id, name, permalink " . "FROM ciniki_artistprofiles " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND permalink = '" . ciniki_core_dbQuote($ciniki, $args['permalink']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.events', 'event');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2888', 'msg' => 'You already have an artist with this name, please choose another name'));
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.artistprofiles');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Add the artist to the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectAdd');
$rc = ciniki_core_objectAdd($ciniki, $args['business_id'], 'ciniki.artistprofiles.artist', $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.artistprofiles');
return $rc;
}
$artist_id = $rc['id'];
//
// Update the categories
//
if (isset($args['categories'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'tagsUpdate');
$rc = ciniki_core_tagsUpdate($ciniki, 'ciniki.artistprofiles', 'tag', $args['business_id'], 'ciniki_artistprofiles_tags', 'ciniki_artistprofiles_history', 'artist_id', $artist_id, 10, $args['categories']);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.artistprofiles');
return $rc;
}
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.artistprofiles');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'artistprofiles');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.artistprofiles.artist', 'object_id' => $artist_id));
return array('stat' => 'ok', 'id' => $artist_id);
}
function ciniki_merchandise_productAdd(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'code' => array('required' => 'no', 'blank' => 'yes', 'trimblanks' => 'yes', 'name' => 'Product Code'), 'name' => array('required' => 'yes', 'blank' => 'no', 'trimblanks' => 'yes', 'name' => 'Product Name'), 'permalink' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Permalink'), 'status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Status'), 'sequence' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Sequence'), 'flags' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Options'), 'unit_amount' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Price'), 'unit_discount_amount' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Discount Amount'), 'unit_discount_percentage' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Discount Percentage'), 'taxtype_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Tax Type'), 'inventory' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Inventory'), 'shipping_other' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping Cost Other'), 'shipping_CA' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping Canada'), 'shipping_US' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping USA'), 'primary_image_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Image'), 'synopsis' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Synopsis'), 'description' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Description'), 'object' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Object'), 'object_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Object ID'), 'image_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Additional Image'), 'categories' => array('required' => 'no', 'blank' => 'yes', 'type' => 'list', 'delimiter' => '::', 'name' => 'Categories')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.productAdd');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Make sure code is unique
//
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1)) {
if (!isset($args['code']) || $args['code'] == '') {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.10', 'msg' => 'You must specify a code.'));
}
$strsql = "SELECT id, code, permalink " . "FROM ciniki_merchandise " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND code = '" . ciniki_core_dbQuote($ciniki, $args['code']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'item');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.11', 'msg' => 'You already have a product with that code, please choose another.'));
}
}
//
// Setup permalink
//
if (!isset($args['permalink']) || $args['permalink'] == '') {
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1)) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, $args['code'] . '-' . $args['name']);
} else {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, $args['name']);
}
}
//
// Make sure the permalink is unique
//
$strsql = "SELECT id, name, permalink " . "FROM ciniki_merchandise " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND permalink = '" . ciniki_core_dbQuote($ciniki, $args['permalink']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'item');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.12', 'msg' => 'You already have a merchandise product with that name, please choose another.'));
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Add the merchandise product to the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectAdd');
$rc = ciniki_core_objectAdd($ciniki, $args['business_id'], 'ciniki.merchandise.product', $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
$product_id = $rc['id'];
//
// Update the categories
//
if (isset($args['categories'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'tagsUpdate');
$rc = ciniki_core_tagsUpdate($ciniki, 'ciniki.merchandise', 'tag', $args['business_id'], 'ciniki_merchandise_tags', 'ciniki_merchandise_history', 'product_id', $product_id, 10, $args['categories']);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
}
//
// Add additional image if supplied
//
if (isset($args['image_id']) && $args['image_id'] > 0) {
//
// Get a UUID for use in permalink
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbUUID');
$rc = ciniki_core_dbUUID($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.13', 'msg' => 'Unable to get a new UUID', 'err' => $rc['err']));
}
$args['uuid'] = $rc['uuid'];
//
// Setup permalink
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, $args['uuid']);
$args['name'] = '';
//
// Add the product image to the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectAdd');
$rc = ciniki_core_objectAdd($ciniki, $args['business_id'], 'ciniki.merchandise.productimage', $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
$productimage_id = $rc['id'];
}
//
// If the object is specified
//
if (isset($args['object']) && $args['object'] != '' && isset($args['object_id']) && $args['object_id'] != '') {
$rc = ciniki_core_objectAdd($ciniki, $args['business_id'], 'ciniki.merchandise.objref', array('product_id' => $product_id, 'object' => $args['object'], 'object_id' => $args['object_id'], 'sequence' => 1), 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'merchandise');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.merchandise.product', 'object_id' => $product_id));
return array('stat' => 'ok', 'id' => $product_id);
}
function ciniki_merchandise_imageUpdate(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'productimage_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Image'), 'product_id' => array('required' => 'no', 'blank' => 'no', 'name' => 'Product'), 'name' => array('required' => 'no', 'blank' => 'no', 'name' => 'Name'), 'permalink' => array('required' => 'no', 'blank' => 'no', 'name' => 'Permalink'), 'sequence' => array('required' => 'no', 'blank' => 'no', 'name' => 'Sequence'), 'flags' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Options'), 'image_id' => array('required' => 'no', 'blank' => 'no', 'name' => 'Image'), 'description' => array('required' => 'no', 'blank' => 'no', 'name' => 'Description')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.imageUpdate');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (isset($args['name'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, $args['name']);
//
// Make sure the permalink is unique
//
$strsql = "SELECT id, name, permalink " . "FROM ciniki_merchandise_images " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND permalink = '" . ciniki_core_dbQuote($ciniki, $args['permalink']) . "' " . "AND id <> '" . ciniki_core_dbQuote($ciniki, $args['productimage_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'item');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.9', 'msg' => 'You already have an image with this name, please choose another.'));
}
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the Image in the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectUpdate');
$rc = ciniki_core_objectUpdate($ciniki, $args['business_id'], 'ciniki.merchandise.image', $args['productimage_id'], $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'merchandise');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.merchandise.image', 'object_id' => $args['productimage_id']));
return array('stat' => 'ok');
}
function ciniki_merchandise_productUpdate(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'product_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Merchandise Product'), 'code' => array('required' => 'no', 'blank' => 'yes', 'trimblanks' => 'yes', 'name' => 'Product Code'), 'name' => array('required' => 'no', 'blank' => 'no', 'trimblanks' => 'yes', 'name' => 'Product Name'), 'permalink' => array('required' => 'no', 'blank' => 'no', 'name' => 'Permalink'), 'status' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Status'), 'sequence' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Sequence'), 'flags' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Options'), 'unit_amount' => array('required' => 'no', 'blank' => 'no', 'type' => 'currency', 'name' => 'Price'), 'unit_discount_amount' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Discount Amount'), 'unit_discount_percentage' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Discount Percentage'), 'taxtype_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Tax Type'), 'inventory' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Inventory'), 'shipping_other' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping Cost Other'), 'shipping_CA' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping Canada'), 'shipping_US' => array('required' => 'no', 'blank' => 'yes', 'type' => 'currency', 'name' => 'Shipping USA'), 'primary_image_id' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Image'), 'synopsis' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Synopsis'), 'description' => array('required' => 'no', 'blank' => 'yes', 'name' => 'Description'), 'categories' => array('required' => 'no', 'blank' => 'yes', 'type' => 'list', 'delimiter' => '::', 'name' => 'Categories')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Make sure this module is activated, and
// check permission to run this function for this business
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'merchandise', 'private', 'checkAccess');
$rc = ciniki_merchandise_checkAccess($ciniki, $args['business_id'], 'ciniki.merchandise.productUpdate');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Check if product already exists
//
$strsql = "SELECT id, code, name " . "FROM ciniki_merchandise " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND id = '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'product');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (!isset($rc['product'])) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.20', 'msg' => 'That product does not exist.'));
}
$product = $rc['product'];
//
// Check to make sure code is unique
//
if (isset($args['code'])) {
$strsql = "SELECT id, code, permalink " . "FROM ciniki_merchandise " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND code = '" . ciniki_core_dbQuote($ciniki, $args['code']) . "' " . "AND id <> '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'item');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.21', 'msg' => 'You already have a product with that code, please choose another.'));
}
}
if (isset($args['name']) || isset($args['code'])) {
if (ciniki_core_checkModuleFlags($ciniki, 'ciniki.merchandise', 0x1)) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, (isset($args['code']) ? $args['code'] : $product['code']) . '-' . isset($args['name']) ? $args['name'] : $product['name']);
} else {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'makePermalink');
$args['permalink'] = ciniki_core_makePermalink($ciniki, isset($args['name']) ? $args['name'] : $product['name']);
}
//
// Make sure the permalink is unique
//
$strsql = "SELECT id, code, name, permalink " . "FROM ciniki_merchandise " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND permalink = '" . ciniki_core_dbQuote($ciniki, $args['permalink']) . "' " . "AND id <> '" . ciniki_core_dbQuote($ciniki, $args['product_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.merchandise', 'item');
if ($rc['stat'] != 'ok') {
return $rc;
}
if ($rc['num_rows'] > 0) {
return array('stat' => 'fail', 'err' => array('code' => 'ciniki.merchandise.22', 'msg' => 'You already have an merchandise product with this name, please choose another.'));
}
}
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the Merchandise Product in the database
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectUpdate');
$rc = ciniki_core_objectUpdate($ciniki, $args['business_id'], 'ciniki.merchandise.product', $args['product_id'], $args, 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
//
// Update the categories
//
if (isset($args['categories'])) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'tagsUpdate');
$rc = ciniki_core_tagsUpdate($ciniki, 'ciniki.merchandise', 'tag', $args['business_id'], 'ciniki_merchandise_tags', 'ciniki_merchandise_history', 'product_id', $args['product_id'], 10, $args['categories']);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.merchandise');
return $rc;
}
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.merchandise');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'merchandise');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.merchandise.product', 'object_id' => $args['product_id']));
return array('stat' => 'ok');
}
function ciniki_artistprofiles_artistDelete(&$ciniki)
{
//
// Find all the required and optional arguments
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'prepareArgs');
$rc = ciniki_core_prepareArgs($ciniki, 'no', array('business_id' => array('required' => 'yes', 'blank' => 'no', 'name' => 'Business'), 'artist_id' => array('required' => 'yes', 'blank' => 'yes', 'name' => 'Artist')));
if ($rc['stat'] != 'ok') {
return $rc;
}
$args = $rc['args'];
//
// Check access to business_id as owner
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'artistprofiles', 'private', 'checkAccess');
$rc = ciniki_artistprofiles_checkAccess($ciniki, $args['business_id'], 'ciniki.artistprofiles.artistDelete');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Get the current settings for the artist
//
$strsql = "SELECT id, uuid " . "FROM ciniki_artistprofiles " . "WHERE business_id = '" . ciniki_core_dbQuote($ciniki, $args['business_id']) . "' " . "AND id = '" . ciniki_core_dbQuote($ciniki, $args['artist_id']) . "' " . "";
$rc = ciniki_core_dbHashQuery($ciniki, $strsql, 'ciniki.artistprofiles', 'artist');
if ($rc['stat'] != 'ok') {
return $rc;
}
if (!isset($rc['artist'])) {
return array('stat' => 'fail', 'err' => array('pkg' => 'ciniki', 'code' => '2881', 'msg' => 'Airlock does not exist.'));
}
$artist = $rc['artist'];
//
// Start transaction
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionStart');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionRollback');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbTransactionCommit');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbDelete');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'objectDelete');
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'dbAddModuleHistory');
$rc = ciniki_core_dbTransactionStart($ciniki, 'ciniki.artistprofiles');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Remove the artist
//
$rc = ciniki_core_objectDelete($ciniki, $args['business_id'], 'ciniki.artistprofiles.artist', $args['artist_id'], $artist['uuid'], 0x4);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.artistprofiles');
return $rc;
}
//
// Remove any tags
//
if (($ciniki['business']['modules']['ciniki.artistprofiles']['flags'] & 0x10) > 0) {
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'tagsDelete');
$rc = ciniki_core_tagsDelete($ciniki, 'ciniki.artistprofiles', 'tag', $args['business_id'], 'ciniki_artistprofiles_tags', 'ciniki_artistprofiles_history', 'artist_id', $args['artist_id']);
if ($rc['stat'] != 'ok') {
ciniki_core_dbTransactionRollback($ciniki, 'ciniki.artistprofiles');
return $rc;
}
}
//
// Commit the transaction
//
$rc = ciniki_core_dbTransactionCommit($ciniki, 'ciniki.artistprofiles');
if ($rc['stat'] != 'ok') {
return $rc;
}
//
// Update the last_change date in the business modules
// Ignore the result, as we don't want to stop user updates if this fails.
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'businesses', 'private', 'updateModuleChangeDate');
ciniki_businesses_updateModuleChangeDate($ciniki, $args['business_id'], 'ciniki', 'artistprofiles');
//
// Update the web index if enabled
//
ciniki_core_loadMethod($ciniki, 'ciniki', 'core', 'private', 'hookExec');
ciniki_core_hookExec($ciniki, $args['business_id'], 'ciniki', 'web', 'indexObject', array('object' => 'ciniki.artistprofiles.artist', 'object_id' => $args['artist_id']));
return array('stat' => 'ok');
}
