private static function addSite($url)
{
$data = [];
$data['format'] = self::getFormatFromURL($url);
$data['name'] = '链接';
$site = new Sites();
$site->save($data);
return $site;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aUsuaris !== null) {
if ($this->aUsuaris->isModified() || $this->aUsuaris->isNew()) {
$affectedRows += $this->aUsuaris->save($con);
}
$this->setUsuaris($this->aUsuaris);
}
if ($this->aGestioMenus !== null) {
if ($this->aGestioMenus->isModified() || $this->aGestioMenus->isNew()) {
$affectedRows += $this->aGestioMenus->save($con);
}
$this->setGestioMenus($this->aGestioMenus);
}
if ($this->aSites !== null) {
if ($this->aSites->isModified() || $this->aSites->isNew()) {
$affectedRows += $this->aSites->save($con);
}
$this->setSites($this->aSites);
}
if ($this->aNivells !== null) {
if ($this->aNivells->isModified() || $this->aNivells->isNew()) {
$affectedRows += $this->aNivells->save($con);
}
$this->setNivells($this->aNivells);
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = UsuarisMenusPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setNew(false);
} else {
$affectedRows += UsuarisMenusPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Sites();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Sites'])) {
$model->attributes = $_POST['Sites'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
function add($request, $response, $args)
{
$add = false;
$body = $request->getParsedBody();
$body['dateStarted'] = $this->formatDate($body['dateStarted']);
if ($body['dateFinished']) {
$body['dateFinished'] = $this->formatDate($body['dateFinished']);
}
$stillUsing = false;
if (isset($body['stillUsing'])) {
$stillUsing = $body['stillUsing'];
}
$site = new Sites();
$result = $site::where('title', $body['title'])->first();
if ($result) {
if ($body['title'] !== $result->title) {
$add = true;
} else {
$error['duplicate'] = $body['title'] . " is already present";
}
} else {
$add = true;
}
if ($add) {
$site->title = $body['title'];
$site->url = $body['url'];
$site->dateStarted = $body['dateStarted'];
$site->dateFinished = $body['dateFinished'];
$site->stillUsing = $stillUsing;
$site->save();
foreach ($body['skills'] as $skill) {
$association = [$skill];
$site->skills()->attach($association);
}
foreach ($body['images'] as $image) {
$association = [$image];
$site->images()->attach($association);
}
}
}
public function createAction()
{
$this->view->disable();
$status = "OK";
$params = json_decode(file_get_contents('php://input'));
$model = Sites::findFirst("url='{$params->url}'");
if ($model == null) {
$model = new Sites();
$model->url = $params->url;
$model->save();
}
$monitorModel = new SiteMonitors();
$monitorModel->site_id = $model->id;
$monitorModel->monitor = $params->monitor;
$monitorModel->ref_site_id = $params->ref_site_id;
$monitorModel->ref_site_url = $params->ref_site_url;
//SiteMonitors::getRcbLink($params->monitor, $params->ref_site_id);
if (!$monitorModel->save()) {
$status = "NG";
}
echo json_encode(array("status" => $status));
}
