public function testInsert() { $c = new Company(); $c->name = 'Model Persister Company'; $c->insert(); $this->assertNotNull($c->id); }
/** * @param : array $data * @return int $id */ public static function insert($data) { if (!is_array($data) || !count($data)) { return; } $shipFromData = $data['shipFrom']; $shipToData = $data['shipTo']; $itemData = $data['item']; $companyData = $data['company']; $shipFromId = ShipFrom::insert($shipFromData); $shipToId = ShipTo::insert($shipToData); $itemId = Item::insert($itemData); $companyId = Company::insert($companyData); $orderData = array('reference_no' => 'SPR-' . rand(), 'created_on' => date('Y-m-d'), 'user_id' => User::getUserId(), 'ship_to' => $shipToId, 'ship_from' => $shipFromId, 'item_id' => $itemId, 'company_id' => $companyId); $id = DB::table('order')->insertGetId($orderData); return $id; }
<?php include_once $CFG->dirroot . "/lib/classes/" . "application/Company.Class.php5"; include_once $CFG->dirroot . "/lib/classes/" . "application/SubGroup.Class.php5"; $companyObj = new Company(); $dCreated = date('Y-m-d H:i:s'); $GeneralObj->getRequestVars(); $companyObj->setAllVar(); if ($mode == "Add") { # echo "<pre>"; print_r($_FILES) ; exit; $redirect_file = "index.php?file=m-companyadd"; $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vCompanyCodeId'), $redirect_file, "Organization ID Already Exists ", $iCompanyId); $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vCompanyName'), $redirect_file, "Organization Name Already Exists ", $iCompanyId); $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vEmail'), $redirect_file, "Email Already Exists ", $iCompanyId); // $userObj->setdCreated($dCreated); $iCompanyId = $companyObj->insert(); $group = new SubGroup(); $group->createDefaultGroup($iCompanyId); $msg = MSG_ADD; $url = 'index.php?file=Company&AX=Yes&var_msg=' . $msg; header("Location:" . $url); exit; } else { if ($mode == "Update") { $update_sql = "UPDATE SubGroup sg SET sg.eStatus = '" . $eStatus . "'\n\t\t\tWHERE sg.iCompanyId IN(" . $iCompanyId . ")"; $obj->sql_query($update_sql); $redirect_file = "index.php?file=m-companyadd&mode=" . $mode . "&iCompanyId=" . $iCompanyId . ""; $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vCompanyCodeId'), $redirect_file, "Organization ID Already Exists ", $iCompanyId); $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vCompanyName'), $redirect_file, "Organization Name Already Exists ", $iCompanyId); $GeneralObj->checkDuplicate('iCompanyId', 'Company', array('vEmail'), $redirect_file, "Email Already Exists ", $iCompanyId); $companyObj->update($iCompanyId);
Flight::ok($array); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('GET /v1/main/company/@id', function ($id) { try { $object = Company::select($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('POST /v1/main/company', function () { try { $object = Company::insert(); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('PUT /v1/main/company/@id', function ($id) { try { $object = Company::update($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('DELETE /v1/main/company/@id', function ($id) { try {
Company::insert($company); } } else { //分支将会被移出 foreach ($_REQUEST as $key => $value) { $key = strtolower($key); $nokeys = array("type", "module", "action"); if (!in_array($key, $nokeys)) { $company = new Company(); $company->content = empty($value) ? "" : $value; $company->companyKey = $key; if ($action == "update" && Company::exist($key)) { //存在,并且需要更新 Company::update($company); } else { Company::insert($company); } } } } } else { if ($action == "del") { $id = isset($_REQUEST["companyId"]) ? $_REQUEST["companyId"] : 0; //是否允许重置添 $company = new Company(_NONE); $company->id = $id; Company::delete($company); } } } catch (Exception $e) { $result = $e->getMessage();