public function updatecatalogmasterlist($catalogmasterid, $catalogmastername, $description, $addedcatalogs, $removedcatalogs, $enabledcatalogs, $disabledcatalogs) { $affectedrows = 0; $temp = commonclass::to_ist(commonclass::to_gmt(time())); $createdon = date("y-m-d H:i:s", $temp); $catalogmasterid = empty($catalogmasterid) ? $this->addNewCatalogmaster($catalogmastername, $description, $createdon) : $catalogmasterid; if (!empty($removedcatalogs)) { $affectedrows = $this->removecatalogvalues($removedcatalogs); } if (!empty($addedcatalogs)) { $affectedrows = $this->addNewcatalogvalues($addedcatalogs, $catalogmasterid, $createdon); } if (!empty($enabledcatalogs)) { $affectedrows = $this->enablecatalogvalues($enabledcatalogs); } if (!empty($disabledcatalogs)) { $affectedrows = $this->disablecatalogvalues($disabledcatalogs); } return $affectedrows > 0 ? $catalogmasterid : 0; }
<?php $temp = commonclass::to_ist(commonclass::to_gmt(time())); $today = date("y-m-d H:i:s", $temp); $updateObject = array(); $returnValue = array(); try { if (!empty($entity['eventid'])) { $duplicate = $this->internalDB->queryFirstRow("select id from events where name='" . $entity['eventname'] . "' AND id!=" . $entity['eventid']); if (!empty($duplicate)) { return array("Exception" => "Specified event name already exists"); } isset($entity['eventname']) ? $updateObject['name'] = $entity['eventname'] : ''; isset($entity['description']) ? $updateObject['description'] = $entity['description'] : ''; isset($entity['icons']) ? $updateObject['icons'] = $entity['icons'] : ''; isset($entity['file_name']) ? $updateObject['images'] = $entity['file_name'] : ''; isset($ritualIds) ? $updateObject['rituals'] = $ritualIds : ''; isset($serviceIds) ? $updateObject['services'] = $serviceIds : ''; $this->internalDB->update('events', $updateObject, "id=%i", $entity['eventid']); $returnValue['Id'] = $entity['eventid']; } else { $duplicate = $this->internalDB->queryFirstRow("select id from events where name='" . $entity['eventname'] . "'"); if (!empty($duplicate)) { return array('Exception' => "Specified event name already exists"); } isset($entity['eventname']) ? $updateObject['name'] = $entity['eventname'] : ''; isset($entity['description']) ? $updateObject['description'] = $entity['description'] : ''; isset($entity['icons']) ? $updateObject['icons'] = $entity['icons'] : ''; isset($entity['file_name']) ? $updateObject['images'] = $entity['file_name'] : ''; isset($ritualIds) ? $updateObject['rituals'] = $ritualIds : ''; isset($serviceIds) ? $updateObject['services'] = $serviceIds : '';
public function updatecatalogmasterlist($catalogmasterid, $catalogmastername, $description, $addedcatalogs, $removedcatalogs, $enabledcatalogs, $disabledcatalogs) { $response = array(); $affectedrows = 0; try { $temp = commonclass::to_ist(commonclass::to_gmt(time())); $createdon = date("y-m-d H:i:s", $temp); $catalogmasterid = empty($catalogmasterid) ? $this->addNewCatalogmaster($catalogmastername, $description, $createdon) : $catalogmasterid; if (!empty($removedcatalogs)) { $affectedrows = $this->removecatalogvalues($removedcatalogs); } if (!empty($addedcatalogs)) { $affectedrows = $this->addNewcatalogvalues($addedcatalogs, $catalogmasterid, $createdon); } if (!empty($enabledcatalogs)) { $affectedrows = $this->enablecatalogvalues($enabledcatalogs); } if (!empty($disabledcatalogs)) { $affectedrows = $this->disablecatalogvalues($disabledcatalogs); } } catch (Exception $ex) { $response['Exception'] = $ex->getMessage(); } return $response; $affectedrows > 0 ? $response['Id'] = $catalogmasterid : ($response['Exception'] = "Error in saving Catalogs"); return $response; }
<?php $today = commonclass::to_ist(commonclass::to_gmt(time())); $today = date("y-m-d H:i:s", $candidate_registered_on); if ($data['orderid'] != 0) { try { $orderid = $data['id']; $candobj = $this->internalDB->queryFirstRow("select * from d_order where id=" . $orderid); $datatoupdate = array(); !empty($data['name']) ? $datatoupdate['name'] = trim($data['name']) : ''; !empty($data['season']) ? $datatoupdate['season'] = trim($data['season']) : ''; !empty($data['mercandiser']) ? $datatoupdate['mercandiser'] = trim($data['mercandiser']) : ''; !empty($data['quantity']) ? $datatoupdate['quantity'] = trim($data['quantity']) : ''; !empty($data['gsm']) ? $datatoupdate['gsm'] = trim($data['gsm']) : ''; !empty($data['excess_percent']) ? $datatoupdate['excess_percent'] = trim($data['excess_percent']) : ''; !empty($data['delivery_date']) ? $datatoupdate['delivery_date'] = commonclass::cleandate($data['delivery_date']) : ''; !empty($data['order_date']) ? $datatoupdate['order_date'] = commonclass::cleandate($data['order_date']) : ''; !empty($data['delivery_type']) ? $datatoupdate['delivery_type'] = $data['delivery_type'] : ''; $datatoupdate['modified_on'] = $today; $candidatetable = $this->internalDB->update('d_order', $datatoupdate, "id=%i", $orderid); $affectedrows = $this->internalDB->affectedRows(); if ($affectedrows >= 0) { $this->createlog("Order {$orderid} updated"); return 1; } } catch (Exception $ex) { return getMessage(); } } else { $candidate_registered_ip = commonclass::GetIP(); $insertData = array();