public function getForCompanyID($id) { $data = array(); //get proviers $ids = $this->db->getQueryBuilderSelect('relations')->columns('provider')->where('client', $id)->loadValueArray(); $companies = $this->companyModel->getByIDs($ids); foreach ($companies as $company) { $item = $company->getItem(); $data[] = array('id' => $item->id, 'name' => $item->name, 'relation' => HLang::get(Lang::generic_provider)); } //get clients $ids = $this->db->getQueryBuilderSelect('relations')->columns('client')->where('provider', $id)->loadValueArray(); $companies = $this->companyModel->getByIDs($ids); foreach ($companies as $company) { $item = $company->getItem(); $data[] = array('id' => $item->id, 'name' => $item->name, 'relation' => HLang::get(Lang::generic_client)); } //get agreements $company = $this->companyModel->getByID($id); $companies = $company->getCompaniesInAgreement(); foreach ($companies as $company) { $item = $company->getItem(); $data[] = array('id' => $item->id, 'name' => $item->name, 'relation' => HLang::get(Lang::generic_agreement)); } return $data; }
public function destroy() { $id = $this->request->get('id'); $relation = $this->relationModel->getByID($id); if ($relation) { if ($relation->inAgrement()) { $this->server->sendConflict(HLang::get(Lang::alert_cant_delete_relation__in_agreement)); } $relation->getItem()->delete(); $this->server->sendOK(); } else { $this->server->sendNotFound(); } }
public function destroy() { $id = $this->request->get('id'); $company = $this->companyModel->getByID($id); if ($company) { if ($company->hasRelations()) { $this->server->sendConflict(HLang::get(Lang::alert_cant_delete_company__in_relation)); } $company->getItem()->delete(); $this->server->sendOK(); } else { $this->server->sendNotFound(); } }
<?php use JNMFW\helpers\HLang; use dokify2\langs\Lang; ?> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title><?php echo HLang::get(Lang::app_title); ?> </title> <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css"> <link rel="stylesheet" href="bower_components/AlertifyJS/build/css/alertify.min.css"> <link rel="stylesheet" href="bower_components/AlertifyJS/build/css/themes/default.min.css"> <link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css"> <link rel="stylesheet" href="css/app.css"> <script data-main="require/main" src="bower_components/requirejs/require.js"></script> </head>
echo HLang::get(Lang::generic_modify); ?> </button> <button type="button" class="delete btn btn-danger hidden"><?php echo HLang::get(Lang::generic_delete); ?> </button> </div> <form class="add col-md-4" autocomplete="off"> <div class="col-md-10"> <input maxlength="127" required type="text" class="name form-control" placeholder="<?php echo HLang::get(Lang::generic_company_name); ?> "> </div> <div class="col-md-2"> <button type="submit" class="btn btn-success"><?php echo HLang::get(Lang::generic_add); ?> </button> </div> </form> </div> <hr> <div class="row"> <div class="col-md-2"></div> <div class="col-md-8 relations"></div> <div class="col-md-2"></div> </div> </div>
<hr> <form id="agreement_create" class="form-horizontal row" autocomplete="off"> <div class="form-group col-md-5"> <label class="col-md-2 control-label"><?php echo HLang::get(Lang::generic_name); ?> </label> <div class="col-md-10"> <input maxlength="127" required type="text" class="name form-control"> </div> </div> <div class="form-group col-md-5"> <label class="col-md-2 control-label"><?php echo HLang::get(Lang::generic_relation); ?> </label> <div class="col-md-10"> <select required class="relation form-control"> <option value=""></option> </select> </div> </div> <div class="form-group col-md-2"> <button type="submit" class="btn btn-success"><?php echo HLang::get(Lang::generic_create_agreement); ?> </button> </div> </form> </div>