LessonPlanLesson.php - Load from path Load from Id

/classes/resources/LessonPlanLesson.php

https://github.com/VivekVish/Veda-Project-API · PHP · 316 lines · 229 code · 66 blank · 21 comment · 9 complexity · 6887cf1a61703fbb286f211f4536cb4d MD5 · raw file

<?php

require_once("classes/resources/Material.php");
require_once("classes/resources/LessonAddition.php");

class LessonPlanLesson
{
    protected $id = null;
    protected $lessonId = null;
    protected $lessonPath = null;
    protected $lessonPlanSectionId = null;
    protected $order = null;
    protected $content = null;
    protected $json = null;
    protected $name = null;
    protected $addition = null;
    protected $additionJSON = null;
    protected $customAddition = null;
    
    ########################################################
    #### Constructor and main function #####################
    ########################################################
    # Constructor
    public function __construct()
    {
        
    }
    
    ########################################################
    #### Helper functions for loading object ###############
    ########################################################
    # Load from path
    public function loadFromUri($uri)
    {
        $uriArr = explode("/",trim($uri,"/"));
        $query = sprintf("SELECT lesson_plan_lesson.id FROM lesson_plan_lesson LEFT JOIN lesson_plan_section ON lesson_plan_section.id=lesson_plan_lesson.section_id LEFT JOIN lesson_plan ON lesson_plan.id=lesson_plan_section.lesson_plan_id LEFT JOIN lesson ON lesson_plan_lesson.lesson_id=lesson.id WHERE lesson_plan_id=%s AND lesson_plan_section.name='%s' AND lesson.name='%s'",pg_escape_string($uriArr[2]),pg_escape_string($uriArr[3]),pg_escape_string($uriArr[4]));
        $result = $GLOBALS['transaction']->query($query,142);
        $this->loadFromId($result[0]['id']);
        
        return true;
    }
    
    # Load from Id
    public function loadFromId($id)
    {
        $query = sprintf("SELECT * FROM lesson_plan_lesson WHERE id=%s",pg_escape_string($id));
        $result = $GLOBALS['transaction']->query($query,142);

        $this->id=$id;
        $this->lessonPlanSectionId=$result[0]['section_id'];
        $this->order=$result[0]['lesson_order'];
        $this->lessonId=$result[0]['lesson_id'];
        
        $query = sprintf("SELECT * FROM lesson WHERE id=%s",pg_escape_string($this->lessonId));
        $result = $GLOBALS['transaction']->query($query,142);
        
        $this->content = $result[0]["content"];
        $this->name = $result[0]["name"];
        
        return true;
    }
    
    # Load from payload
    public function loadFromPayload($payload,$uri)
    {
        $uriArr = explode("/",trim($uri,"/"));

        $this->lessonId = Material::URIToId($payload->path,"lesson");
        $this->order = $payload->order;
        
        $query = sprintf("SELECT id from lesson_plan_section WHERE lesson_plan_id=%s and name='%s'", pg_escape_string($uriArr[2]),pg_escape_string($uriArr[3]));
        $result = $GLOBALS['transaction']->query($query,140);
        
        $this->lessonPlanSectionId = $result[0]['id'];
        
        return true;
    }
    
    # Build JSON
    public function buildJSON()
    {
        $jsonArray =array("id"=>$this->id,"content"=>$this->content,"name"=>$this->name);
        $this->json = json_encode($jsonArray);
        return true;
    }
    
    # Load addition
    public function loadAddition($additionType)
    {
        $this->addition = new LessonAddition($additionType);
        
        $query = sprintf("SELECT id FROM lesson_additions WHERE name='%s' and lesson_id=%s",$additionType,$this->lessonId);
        $result = $GLOBALS['transaction']->query($query,142);

        $this->addition->loadFromId($result[0]['id']);
        
        $query = sprintf("SELECT custom_content FROM lesson_plan_custom_addition WHERE lesson_addition_id=%s AND lesson_plan_lesson_id=%s",pg_escape_string($result[0]['id']), pg_escape_string($this->id));
        $result = $GLOBALS['transaction']->query($query);
        
        if($result!=="none")
        {
            $this->customAddition = json_decode($result[0]['custom_content']);
        }
        
        return true;
    }
    
    # Load custom addion by payload
    public function loadCustomAdditionByPayload($payload)
    {
        $this->customAddition = $payload;
        return true;
    }
    
    # Load addition JSON
    public function buildAdditionJSON()
    {
        $this->addition->buildJSON();
        $jsonArray = json_decode($this->addition->getJSON());
        if(!is_null($this->customAddition))
        {
            $jsonArray = (object)array_merge((array)$jsonArray,(array)$this->customAddition);
        }
        $this->additionJSON = json_encode($jsonArray);
    }
    
    ########################################################
    #### Database interface functions ######################
    ########################################################
    # Saves Lesson
    public function save()
    {
        $query = sprintf("INSERT INTO lesson_plan_lesson (lesson_id, section_id, lesson_order) VALUES (%s, %s, %s)", pg_escape_string($this->lessonId), pg_escape_string($this->lessonPlanSectionId), pg_escape_string($this->order));
        $GLOBALS['transaction']->query($query,139);
        
        $query = sprintf("SELECT id FROM lesson_plan_lesson WHERE lesson_id=%s AND section_id=%s AND lesson_order=%s",pg_escape_string($this->lessonId), pg_escape_string($this->lessonPlanSectionId), pg_escape_string($this->order));
        $result = $GLOBALS['transaction']->query($query,139);
        
        $this->id = $result[0]['id'];
        
        $query = sprintf("SELECT name FROM lesson_additions WHERE lesson_id=%s",pg_escape_string($this->lessonId));
        $result = $GLOBALS['transaction']->query($query);
        
        $query = sprintf("INSERT INTO lesson_plan_lesson_addition (lesson_plan_lesson_id,addition_type) VALUES (%s,'%s')",pg_escape_string($this->id),pg_escape_string("quiz"));
        $GLOBALS['transaction']->query($query,139);

        if($result!=="none")
        {
            foreach($result as $row)
            {
                $query = sprintf("INSERT INTO lesson_plan_lesson_addition (lesson_plan_lesson_id,addition_type) VALUES (%s,'%s')",pg_escape_string($this->id),pg_escape_string($row['name']));
                $GLOBALS['transaction']->query($query,139);
            }
        }
        
        return true;
    }
    
    public function saveCustomAddition()
    {
        $query = sprintf("SELECT * from lesson_plan_custom_addition WHERE lesson_addition_id=%s AND lesson_plan_lesson_id=%s",pg_escape_string($this->addition->getId()),pg_escape_string($this->id));
        $result = $GLOBALS['transaction']->query($query);
        
        if($result==="none")
        {
            $query = sprintf("INSERT INTO lesson_plan_custom_addition (lesson_addition_id,lesson_plan_lesson_id,custom_content) VALUES (%s, %s, '%s')", pg_escape_string($this->addition->getId()),pg_escape_string($this->id),pg_escape_string(json_encode($this->customAddition)));
            $GLOBALS['transaction']->query($query,147);
        }
        else
        {
            $query = sprintf("UPDATE lesson_plan_custom_addition SET custom_content='%s' WHERE lesson_addition_id=%s AND lesson_plan_lesson_id=%s",pg_escape_string(json_encode($this->customAddition)),pg_escape_string($this->addition->getId()),pg_escape_string($this->id));
            $result = $GLOBALS['transaction']->query($query,147);
        }
        
        return true;
    }
    
    public function setPosition($newPath,$newOrder,$oldPath)
    {
        $newPathArray = explode("/",trim($newPath,"/"));
        $oldPathArray = explode("/",trim($oldPath,"/"));
        $newLessonPlanId = $newPathArray[2];
        $oldLessonPlanId = $oldPathArray[2];

        $query = sprintf("SELECT id FROM lesson_plan_section WHERE lesson_plan_id=%s AND name='%s'",pg_escape_string($newLessonPlanId),pg_escape_string($newPathArray[3]));
        $result = $GLOBALS['transaction']->query($query);

        $newSectionId = $result[0]['id'];

        $query = sprintf("SELECT id FROM lesson_plan_section WHERE lesson_plan_id=%s AND name='%s'",pg_escape_string($oldLessonPlanId),pg_escape_string($oldPathArray[3]));
        $result = $GLOBALS['transaction']->query($query);

        $oldSectionId = $result[0]['id'];

        $query = sprintf("SELECT lesson_plan_lesson.id FROM lesson_plan_lesson LEFT JOIN lesson ON lesson_id=lesson.id WHERE lesson_plan_lesson.section_id=%s AND lesson.name='%s' AND lesson_plan_lesson.id!=%s",  pg_escape_string($newSectionId),  pg_escape_string($oldPathArray[4]), pg_escape_string($this->id));
        $result = $GLOBALS['transaction']->query($query);

        if($result!='none')
        {
            Error::generateError(100,"Old Path: $oldPath. New Path: $newPath");
        }

        if(strcmp($newPath,$oldPath)==0)
        {
            if($this->order>$newOrder)
            {
                $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = lesson_order+1 WHERE lesson_order<%s AND lesson_order>=%s AND section_id='%s'",
                                                pg_escape_string($this->order),
                                                pg_escape_string($newOrder),
                pg_escape_string($newSectionId));
            }
            else
            {
                $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = lesson_order-1 WHERE lesson_order>%s AND lesson_order<=%s AND section_id='%s'",
                                                pg_escape_string($this->order),
                                                pg_escape_string($newOrder),
                pg_escape_string($newSectionId));
            }

            $GLOBALS['transaction']->query($query,143);


            $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = %s WHERE id='%s'",
                        pg_escape_string($newOrder),
                        pg_escape_string($this->id));
            $GLOBALS['transaction']->query($query,143);
        }
        else
        {
            $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = lesson_order-1 WHERE lesson_order>%s AND section_id='%s'",
                pg_escape_string($this->order),
                pg_escape_string($oldSectionId));

            $GLOBALS['transaction']->query($query,143);

            $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = lesson_order+1 WHERE lesson_order>=%s AND section_id='%s'",
                                pg_escape_string($newOrder),
                                pg_escape_string($newSectionId));

            $GLOBALS['transaction']->query($query,143);

            $query = sprintf("UPDATE lesson_plan_lesson SET lesson_order = %s, section_id= %s WHERE id='%s'",
                                pg_escape_string($newOrder),
                                pg_escape_string($newSectionId),
                                pg_escape_string($this->id));

            $GLOBALS['transaction']->query($query,143);
        }

        return true;
    }
    
    public function delete()
    {
        $query = sprintf("DELETE FROM lesson_plan_custom_addition WHERE lesson_plan_lesson_id=%s",pg_escape_string($this->id));
        $GLOBALS['transaction']->query($query,144);
        
        $query = sprintf("DELETE FROM lesson_plan_lesson_addition WHERE lesson_plan_lesson_id=%s",pg_escape_string($this->id));
        $GLOBALS['transaction']->query($query,144);
        
        $query = sprintf("DELETE FROM lesson_plan_lesson WHERE id=%s",pg_escape_string($this->id));
        $GLOBALS['transaction']->query($query,144);
        
        return true;
    }
    
    public function addAddition($type)
    {
        $query = sprintf("SELECT * FROM lesson_plan_lesson_addition WHERE lesson_plan_lesson_id=%s AND addition_type='%s'",pg_escape_string($this->id),pg_escape_string($type));
        $result = $GLOBALS['transaction']->query($query);

        if($result=="none")
        {
            $query = sprintf("INSERT INTO lesson_plan_lesson_addition (lesson_plan_lesson_id,addition_type) VALUES (%s,'%s')",pg_escape_string($this->id),pg_escape_string($type));
            $GLOBALS['transaction']->query($query,153);
        }
        return true;
    }
    
    public function dropAddition($additionType)
    {
        if($additionType!="quiz")
        {
            $query = sprintf("SELECT id FROM lesson_additions WHERE lesson_id=%s AND name='%s'",pg_escape_string($this->lessonId),pg_escape_string($additionType));
            $result = $GLOBALS['transaction']->query($query,145);

            $query = sprintf("DELETE FROM lesson_plan_custom_addition WHERE lesson_plan_lesson_id=%s and lesson_addition_id=%s",pg_escape_string($this->id),pg_escape_string($result[0]['id']));
            $result = $GLOBALS['transaction']->query($query,145);
        }
        
        $query = sprintf("DELETE FROM lesson_plan_lesson_addition WHERE lesson_plan_lesson_id=%s AND addition_type='%s'",pg_escape_string($this->id),pg_escape_string($additionType));
        $GLOBALS['transaction']->query($query,145);
        
        return true;
    }
    
    ########################################################
    ### Getters and Setters ################################
    ########################################################
    public function getJSON()
    {
        return $this->json;
    }
    
    public function getAdditionJSON()
    {
        return $this->additionJSON;
    }
    
    public function getLessonId()
    {
        return $this->lessonId;
    }
}

?>