Exemplo n.º 1
0
 function execute($param, $post)
 {
     if (count($param) > 0 && $param[0] == "act") {
         $obj = json_decode($post["json"]);
         $group = GetSingleByCondition(DRINKERCYCLE_TABLE, array("Name" => $obj->Name));
         if ($group instanceof DrinkerCycle) {
             if ($obj->Action == "exists") {
                 $groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id));
                 return ReturnBoolean($groupRela != null);
             } else {
                 if ($obj->Action == "add") {
                     $drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
                     if ($drinker instanceof Drinker) {
                         $presGroupRelation = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
                         if ($presGroupRelation == null) {
                             $groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id));
                             $newRela = new DrinkerCyclesDrinkersRelation();
                             $newRela->DrinkerId = $drinker->Id;
                             $newRela->DrinkerCycleId = $group->Id;
                             $newRela->IsAuthenticated = $groupRela == null;
                             return ReturnBoolean(Insert(DRINKERCYCLESDRINKERSRELATION_TABLE, $newRela));
                         }
                         return ReturnBoolean(true);
                     } else {
                         return ReturnNotFound($obj->Guid, "Drinker");
                     }
                 } else {
                     if ($obj->Action == "remove") {
                         $drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
                         if ($drinker instanceof Drinker) {
                             $groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
                             if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
                                 return ReturnBoolean(DeleteById(DRINKERCYCLESDRINKERSRELATION_TABLE, $groupRela->Id));
                             } else {
                                 return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
                             }
                         } else {
                             return ReturnNotFound($obj->Guid, DRINKER_TABLE);
                         }
                     } else {
                         if ($obj->Action == "authenticate" || $obj->Action == "deauthenticate") {
                             $newVal = true;
                             if ($obj->Action == "deauthenticate") {
                                 $newVal = false;
                             }
                             $drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
                             if ($drinker instanceof Drinker) {
                                 $groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
                                 if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
                                     //can change others status
                                     if ($groupRela->IsAuthenticated) {
                                         $otherDrinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->AuthGuid));
                                         if ($otherDrinker instanceof Drinker) {
                                             $otherGroupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $otherDrinker->Id));
                                             if ($otherGroupRela instanceof DrinkerCyclesDrinkersRelation) {
                                                 $otherGroupRela->IsAuthenticated = $newVal;
                                                 return ReturnBoolean(Update(DRINKERCYCLESDRINKERSRELATION_TABLE, $otherGroupRela));
                                             } else {
                                                 return RelationNotFound($group->Id, $otherDrinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
                                             }
                                         } else {
                                             return ReturnNotFound($obj->AuthGuid, "Drinker");
                                         }
                                     } else {
                                         //not authenticated
                                         return ReturnBoolean(false);
                                     }
                                 } else {
                                     return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
                                 }
                             } else {
                                 return ReturnNotFound($obj->Guid, "Drinker");
                             }
                         } else {
                             if ($obj->Action == "removeforeign") {
                                 $drinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->Guid));
                                 if ($drinker instanceof Drinker) {
                                     $groupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $drinker->Id));
                                     if ($groupRela instanceof DrinkerCyclesDrinkersRelation) {
                                         //can change others status
                                         if ($groupRela->IsAuthenticated) {
                                             $otherDrinker = GetSingleByCondition(DRINKER_TABLE, array("Guid" => $obj->AuthGuid));
                                             if ($otherDrinker instanceof Drinker) {
                                                 $otherGroupRela = GetSingleByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $group->Id, "DrinkerId" => $otherDrinker->Id));
                                                 if ($otherGroupRela instanceof DrinkerCyclesDrinkersRelation) {
                                                     return ReturnBoolean(Delete(DRINKERCYCLESDRINKERSRELATION_TABLE, $otherGroupRela));
                                                 } else {
                                                     return RelationNotFound($group->Id, $otherDrinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
                                                 }
                                             } else {
                                                 return ReturnNotFound($obj->AuthGuid, "Drinker");
                                             }
                                         } else {
                                             //not authenticated
                                             return ReturnBoolean(false);
                                         }
                                     } else {
                                         return RelationNotFound($group->Id, $drinker->Id, DRINKERCYCLESDRINKERSRELATION_TABLE);
                                     }
                                 } else {
                                     return ReturnNotFound($obj->Guid, "Drinker");
                                 }
                             } else {
                                 return ReturnError(LINK_INVALID);
                             }
                         }
                     }
                 }
             }
         }
         if ($obj->Action == "exists") {
             return ReturnBoolean(false);
         } else {
             if ($obj->Action == "add") {
                 $newGroup = new DrinkerCycle();
                 $newGroup->Name = $obj->Name;
                 $newGroup->Guid = GenerateGuid();
                 if (Insert(DRINKERCYCLE_TABLE, $newGroup)) {
                     return $this->execute($param, $post);
                 } else {
                     return ReturnCrudError($newGroup, "add");
                 }
             } else {
                 return ReturnNotFound($obj->Guid, DRINKERCYCLE_TABLE);
             }
         }
     } else {
         if (ValidateGuid($param[0])) {
             //construct model puh
             $drinker = GetByGuid("Drinker", $param[0]);
             if ($drinker != null && $drinker instanceof Drinker) {
                 $relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $drinker->Id));
                 $cyclesEnt = array();
                 $cycles = array();
                 $authCycles = array();
                 foreach ($relations as $relation) {
                     if ($relation instanceof DrinkerCyclesDrinkersRelation) {
                         $cycle = GetById(DRINKERCYCLE_TABLE, $relation->DrinkerCycleId);
                         if ($cycle instanceof DrinkerCycle) {
                             if ($relation->IsAuthenticated) {
                                 $cycl = new DrinkerCycleEntity($cycle);
                                 $cycl->IsAuthenticated = true;
                                 $authCycles[] = $cycle;
                                 $cyclesEnt[] = $cycl;
                             } else {
                                 $cycles[] = $cycle;
                                 $cycl = new DrinkerCycleEntity($cycle);
                                 $cycl->IsAuthenticated = false;
                                 $cyclesEnt[] = $cycl;
                             }
                         }
                     }
                 }
                 $drinkers = array();
                 foreach ($authCycles as $cycle) {
                     $userRelations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerCycleId" => $cycle->Id));
                     foreach ($userRelations as $userRelation) {
                         if ($userRelation instanceof DrinkerCyclesDrinkersRelation) {
                             //exclude self
                             if ($drinker->Id != $userRelation->DrinkerId) {
                                 if (!isset($drinkers[$userRelation->DrinkerId])) {
                                     $user = GetById(DRINKER_TABLE, $userRelation->DrinkerId);
                                     if ($user instanceof Drinker) {
                                         $drinkers[$userRelation->DrinkerId] = new DrinkerEntity($user);
                                     }
                                 }
                                 if ($drinkers[$userRelation->DrinkerId] instanceof DrinkerEntity) {
                                     if ($userRelation->IsAuthenticated) {
                                         $drinkers[$userRelation->DrinkerId]->AuthDrinkerCycles[] = $cycle->Guid;
                                     } else {
                                         $drinkers[$userRelation->DrinkerId]->NonAuthDrinkerCycles[] = $cycle->Guid;
                                     }
                                 }
                             }
                         }
                     }
                 }
                 $coll = new DrinkerCycleResponse();
                 $coll->DrinkerCycles = $cyclesEnt;
                 foreach ($drinkers as $drinker) {
                     $coll->Drinkers[] = $drinker;
                 }
                 return json_encode($coll);
             } else {
                 return ReturnNotFound($param[0], "Drinker");
             }
         } else {
             return ReturnError(LINK_INVALID);
         }
     }
 }
Exemplo n.º 2
0
 function execute($param, $post)
 {
     if (count($param) > 0) {
         if ($param[0] == "act") {
             $obj = json_decode($post["json"]);
             $user = GetByGuid("Drinker", $obj->Guid);
             if ($obj->Action == "exists") {
                 return ReturnBoolean($user != null);
             } else {
                 if ($obj->Action == "update") {
                     if ($user instanceof Drinker) {
                         $user->Name = $obj->UserInformations->Name;
                         $user->Color = $obj->UserInformations->Color;
                         return ReturnBoolean(Update(DRINKER_TABLE, $user));
                     } else {
                         $user = new Drinker();
                         $user->Name = $obj->UserInformations->Name;
                         $user->Color = $obj->UserInformations->Color;
                         $user->Guid = $obj->Guid;
                         return ReturnBoolean(Insert(DRINKER_TABLE, $user));
                     }
                 } else {
                     if ($obj->Action == "remove") {
                         if ($user instanceof Drinker) {
                             //remove all DrinkerCycleRelations
                             $relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $user->Id));
                             if (DeleteAll($relations)) {
                                 return ReturnBoolean(Delete(DRINKER_TABLE, $user));
                             } else {
                                 return ReturnCrudError($relations, "DeleteAll");
                             }
                         } else {
                             return ReturnNotFound($obj->Guid, "Drinker");
                         }
                     }
                 }
             }
         } else {
             if (ValidateGuid($param[0])) {
                 $user = GetByGuid("Drinker", $param[0]);
                 if ($user instanceof Drinker) {
                     $drinker = new DrinkerEntity($user);
                     $relations = GetAllByCondition(DRINKERCYCLESDRINKERSRELATION_TABLE, array("DrinkerId" => $drinker->Id));
                     foreach ($relations as $relation) {
                         if ($relation instanceof DrinkerCyclesDrinkersRelation) {
                             $cycle = GetById(DRINKER_TABLE, $relation->DrinkerCycleId);
                             if ($cycle instanceof DrinkerCycle) {
                                 if ($relation->IsAuthenticated) {
                                     $drinker->AuthDrinkerCycles[] = $cycle->Guid;
                                 } else {
                                     $drinker->NonAuthDrinkerCycles[] = $cycle->Guid;
                                 }
                             }
                         }
                     }
                     $resp = new DrinkerResponse();
                     $resp->Drinker = $drinker;
                     return json_encode($resp);
                 } else {
                     return ReturnNotFound($param[0], "Drinker");
                 }
             }
         }
     }
     return ReturnError(LINK_INVALID);
 }
Exemplo n.º 3
0
 function execute($param, $post)
 {
     if (count($param) > 0) {
         if ($param[0] == "act") {
             $obj = json_decode($post["json"]);
             $drinker = GetByGuid("Drinker", $obj->Guid);
             if ($drinker instanceof Drinker) {
                 if ($obj->Action == "remove") {
                     $existingBeers = array();
                     foreach ($obj->Beers as $beer) {
                         $existingBeer = GetSingleByCondition("Beers", array("Guid" => $beer->Guid));
                         if ($existingBeer != null) {
                             $existingBeers[] = $existingBeer;
                         }
                     }
                     return ReturnBoolean(DeleteAll($existingBeers) && $this->refreshDrinkerProperties($drinker));
                 } else {
                     if ($obj->Action == "add") {
                         $newBeers = array();
                         foreach ($obj->Beers as $beer) {
                             $existingBeer = GetSingleByCondition("Beers", array("Guid" => $beer->Guid));
                             if ($existingBeer == null) {
                                 $newbeer = new Beer();
                                 $newbeer->Guid = $beer->Guid;
                                 $newbeer->DrinkTime = ConvertToDatabaseDateTime($beer->DrinkTime);
                                 $newbeer->DrinkerId = $drinker->Id;
                                 $newBeers[] = $newbeer;
                             }
                         }
                         return ReturnBoolean(InsertAll($newBeers) && $this->refreshDrinkerProperties($drinker));
                     } else {
                         if ($obj->Action == "sync") {
                             $beercount = $this->countExistingBeers($drinker);
                             if ($beercount !== $obj->ExpectedCount) {
                                 return ReturnBoolean(false);
                             }
                             $beers = GetAllByCondition("Beers", array("DrinkerId" => $drinker->Id), "DrinkTime DESC", " LIMIT " . count($obj->Beers));
                             for ($i = 0; $i < count($beers); $i++) {
                                 if ($beers[$i]->Guid != $obj->Beers[$i]->Guid) {
                                     return ReturnBoolean(false);
                                 }
                             }
                             return ReturnBoolean(true);
                         } else {
                             return ReturnError(LINK_INVALID);
                         }
                     }
                 }
             }
             return ReturnNotFound($param[0], "Drinker");
         } else {
             if (ValidateGuid($param[0])) {
                 $drinker = GetByGuid("Drinker", $param[0]);
                 if ($drinker != null && $drinker instanceof Drinker) {
                     /*
                     $limit = 0;
                     if (count($param) > 1 && is_numeric($param[1])) {
                         $beerCount = $this->countExistingBeers($drinker);
                         if ($beerCount > $param[1]) {
                             $limit = $beerCount - $param[0];
                         }
                     }
                     $limitstring = " LIMIT " . $limit;
                     if ($limit == 0)
                         $limitstring = "";
                     */
                     $beers = GetAllByCondition("Beers", array("DrinkerId" => $drinker->Id), " DrinkTime DESC ");
                     $resp = new BeerResponse();
                     foreach ($beers as $beer) {
                         $resp->Beers[] = new BeerEntity($beer);
                     }
                     return json_encode($resp);
                 } else {
                     return ReturnNotFound($param[0], "Drinker");
                 }
             }
         }
     }
     return ReturnError(LINK_INVALID);
 }