Inheritance: implements IQuery
Exemplo n.º 1
0
 public function run()
 {
     $faker = Faker::create();
     foreach (range(1, 10) as $index) {
         $size = rand(100, 300);
         $user_id = rand(1, 10);
         UnitType::create(['name' => $faker->word(), 'project_id' => rand(1, 7), 'building_area' => $size, 'land_area' => $size + rand(100, 300), 'base_price' => rand(100000000, 500000000), 'added_facility_price' => rand(1000000, 5000000), 'added_area_price' => rand(1000000, 5000000), 'created_by' => $user_id, 'changed_by' => $user_id, 'change_reason' => $faker->realText(100)]);
     }
 }
Exemplo n.º 2
0
 public static function setUnitType($newUnitType)
 {
     if (UnitType::exists($newUnitTye)) {
         $db = self::getInstance();
         $user = new User();
         $userId = $user->data()->id;
         $sql = "UPDATE `Unit` SET `Unit`.`UnitType` = ? WHERE `Unit`.`Name` = ? AND `Unit`.`user` = ?;";
         if ($db->query($sql, [$newUnitType, $userId])) {
             return true;
         } else {
             return false;
         }
     } else {
         return false;
     }
 }
Exemplo n.º 3
0
 public static function delete($id)
 {
     $connection = Flight::dbMain();
     try {
         /* Begin Transaction */
         $connection->beginTransaction();
         /*Query 1 Select unit*/
         $sql = "SELECT * FROM unit WHERE id = :id;";
         $query = $connection->prepare($sql);
         $query->bindParam(':id', $id, PDO::PARAM_INT);
         $query->execute();
         $rows = $query->fetchAll(PDO::FETCH_ASSOC);
         $row = $rows[0];
         $unit = new Unit();
         $unit->Id = (int) $row['id'];
         $unit->Imei = $row['unit_imei'];
         $unit->DtCreated = $row['unit_dt_created'];
         $unit->SerialNumber = $row['unit_serial_number'];
         $unit->Sim = Sim::select($row['sim_id']);
         $unit->UnitStatus = UnitStatus::select($row['e_status_unit_id']);
         $unit->UnitType = UnitType::select($row['unit_type_id']);
         $unit->Company = Company::select($row['company_id']);
         /*Query 2 Delete unit*/
         $sql = "\n\t\t\tDELETE FROM unit \n\t\t\tWHERE\n\t\t\tid = :id";
         $query = $connection->prepare($sql);
         $query->bindParam(':id', $id, PDO::PARAM_INT);
         $query->execute();
         /*Query 3 Drop data_unit.imei table*/
         $year = date('Y');
         $schema = "app_data_{$year}";
         $imei = $unit->Imei;
         $tableName = "data_{$imei}";
         $sql = "\n\t\t\t\n\t\t\tDROP TABLE IF EXISTS {$schema}.{$tableName};\n\n\t\t\t";
         $query = $connection->prepare($sql);
         $query->execute();
         $connection->commit();
         $result = new Result();
         $result->Status = Result::DELETED;
         $result->Message = 'Done';
         $result->Id = $id;
         return $result;
     } catch (PDOException $pdoException) {
         $connection->rollBack();
         throw $pdoException;
     } catch (Exception $exception) {
         $connection->rollBack();
         throw $exception;
     } finally {
         $connection = null;
     }
 }
Exemplo n.º 4
0
 /**
  * function for send ajax request to view
  *
  * @return Response
  */
 public function listingJson()
 {
     $query = UnitType::select('id', 'name', 'project_id', 'building_area', 'base_price', 'changed_by')->with('User')->with('Project')->get();
     return Datatable::collection($query)->addColumn('name', function ($model) {
         return ucfirst($model->name);
     })->addColumn('project_id', function ($model) {
         // return $model->project_id;
         return ucfirst($model->project->name);
     })->addColumn('building_area', function ($model) {
         return $model->building_area;
     })->addColumn('base_price', function ($model) {
         return $model->base_price;
     })->addColumn('changed_by', function ($model) {
         return $model->user->name;
     })->addColumn('show', function ($model) {
         return '<a href="' . action('UnitTypesController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>';
     })->addColumn('edit', function ($model) {
         return '<a href="' . action('UnitTypesController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>';
     })->addColumn('delete', function ($model) {
         return '<form action="' . action('UnitTypesController@delete', $model->id) . '" method="POST"><button  type="submit" class="btn  btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>';
     })->searchColumns('block', 'additional_land_area', 'status_id')->orderColumns('id', 'block', 'unit_type_id', 'additional_land_area', 'additional_facility')->make();
 }
Exemplo n.º 5
0
        </div>
        <div class="row">
          <div class="col-md-3">
            Unit Type <span class="pull-right">:</span>
          </div>
          <div class="col-md-9">
            <a href="{{ URL::action('UnitTypesController@detail', $unit->unit_type_id) }}">{{{ucfirst($unit->unitType->name)}}}</a>
          </div>
        </div>
        <div class="row">
          <div class="col-md-3">
            Project Name <span class="pull-right">:</span>
          </div>
          <div class="col-md-9">
            <?php 
$unit_type = UnitType::findOrFail($unit->unitType->id);
?>
            <a href="{{ URL::action('ProjectsController@detail', $unit_type->project->id) }}">{{{ucfirst($unit_type->project->name)}}}</a>
          </div>
        </div>
        <div class="row">
          <div class="col-md-3">
            Additional Land Area <span class="pull-right">:</span>
          </div>
          <div class="col-md-9">
            {{{$unit->additional_land_area}}} meters
          </div>
        </div>
        <div class="row">
          <div class="col-md-3">
            Additional Facility <span class="pull-right">:</span>
Exemplo n.º 6
0
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('PUT /v1/main/unittype/@id', function ($id) {
    try {
        $object = UnitType::update($id);
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('DELETE /v1/main/unittype/@id', function ($id) {
    try {
        $object = UnitType::delete($id);
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
//=============================================================================
//UnitStatus
//=============================================================================
Flight::route('GET /v1/main/unitstatus', function () {
    try {
        $array = UnitStatus::selectAll();
        Flight::ok($array);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
Exemplo n.º 7
0
 /**
  * function for send ajax request to view
  *
  * @return Response
  */
 public function listingJson()
 {
     $query = BookedUnit::select('id', 'unit_id', 'customer_id', 'is_valid', 'changed_by')->with('User')->with('Unit')->with('Customer')->get();
     return Datatable::collection($query)->addColumn('unit_id_block', function ($model) {
         return ucfirst($model->unit->block);
     })->addColumn('unit_id', function ($model) {
         $unit_type = UnitType::findOrFail($model->unit->id);
         return ucfirst($unit_type->name);
         // return $model->unit_id;
     })->addColumn('customer_id', function ($model) {
         return $model->customer->name;
         // return $model->project->name . $model->project_id;
     })->addColumn('is_valid', function ($model) {
         $is_valid = $model->is_valid == '1' ? 'Yes' : 'No';
         return $is_valid;
     })->addColumn('changed_by', function ($model) {
         return $model->user->name;
     })->addColumn('show', function ($model) {
         return '<a href="' . action('BookedUnitsController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>';
     })->addColumn('edit', function ($model) {
         return '<a href="' . action('BookedUnitsController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>';
     })->addColumn('delete', function ($model) {
         return '<form action="' . action('BookedUnitsController@delete', $model->id) . '" method="POST"><button  type="submit" class="btn  btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>';
     })->searchColumns('id', 'unit_id_block', 'customer_id')->orderColumns('id', 'unit_id_block', 'customer_id', 'is_valid', 'changed_by')->make();
 }