MVC Logic

   // Insert the Actual Record
        $ticket_data=array(
            'ticketid'=>'',
            'ticketmaskid'=>$ticketmaskid ,
            'departmentid'=>1 ,
            'ticketstatusid'=>1 ,
            'priorityid'=> 1,
            'emailqueueid'=>0 ,
            'userid'=>68 ,
            'staffid'=>2,
            'ownerstaffid'=>2,
            'assignstatus'=>1,
            'fullname'=>'someva' ,
            'email'=>$user_details['email'] ,
            'lastreplier'=>'someva' ,
            'replyto'=>$user_details['email'] ,
            'subject'=>'New Account is registered' ,
            'dateline'=>now() ,
            'lastactivity'=>now() ,
            'laststaffreplytime'=>now() ,
            'slaplanid'=>1 ,
            'duetime'=>0 ,
            'totalreplies'=>0 ,
            'ipaddress'=>'' ,
            'flagtype'=> 0,
            'hasnotes'=> 0,
            'hasattachments'=> 0,
            'isemailed'=> 0,
            'edited'=> 0,
            'editedbystaffid'=> 0,
            'editeddateline'=> 0,
            'creator'=> 1,
            'charset'=>'UTF-8' ,
            'transferencoding'=>'' ,
            'timeworked' =>0 ,
            'dateicon' =>0,
            'lastpostid'=>0,
            'firstpostid'=>0,
            'tgroupid'=>1 ,
            'messageid' =>$messageid ,
            'escalationruleid'=>0 ,
            'hasdraft'=>0 ,
            'hasbilling' =>0 ,
            'isphonecall' =>0 ,
            'isescalated'=>0 ,
            'phoneno'=>'' ,
            'autoclosetimeline' =>0 ,
            'islabeled' =>0 ,
            'lastuserreplytime' => now(),
            'escalatedtime' =>0 ,
            'followupcount'=>0 );
 
        $this->db1->insert('swtickets',$ticket_data);
        $ticketid=$this->db1->insert_id();
 
        $content="<p>Hi,</p>";
        $content.="<p>New account is registered with following details:</p>";
        $content.="<p> Full Name: ".$user_details['first_name']." ".$user_details['last_name'];
        $content.="</p><p> Email: ".$user_details['email']." </p>";
        $content.="<p> ".$this->get_orders()." </p>";
        $content.="<p></p>";
 
        $post_data=array(
            'ticketpostid'=>'' ,
            'ticketid'=>$ticketid ,
            'dateline'=>now() ,
            'userid'=>68 ,
            'fullname'=> 'someva',
            'email'=>$user_details['email'] ,
            'emailto'=>'' ,
            'subject'=>'New Account Registration' ,
            'ipaddress'=>'' ,
            'hasattachments'=>0 ,
            'edited'=>0 ,
            'editedbystaffid'=>0 ,
            'editeddateline'=>0 ,
            'creator'=>1 ,
            'ishtml'=>1 ,
            'isemailed'=>0 ,
            'staffid'=>2 ,
            'contents'=> $content,
            'contenthash'=>md5($content) ,
            'subjecthash'=>md5('New Account Registration')
        );
 
        $this->db1->insert('swticketposts',$post_data);
        $ticketpostid=$this->db1->insert_id();
 
 
 
        $ticket_message_data=array(
            'ticketmessageid'=>'',
            'messageid'=>$messageid ,
            'ticketid'=>$ticketid ,
            'ticketpostid'=>$ticketpostid ,
            'dateline' => now());
 
        $this->db1->insert('swticketmessageids',$ticket_message_data);
        $ticketmessageid=$this->db1->insert_id();
 
        //load default database
        $this->ci->load->database('default', TRUE);

 /**
     * Generates a Random Message ID
     */
    function generateRandomMessageID()
    {
        srand((double)microtime()*10000000);
        $messageid = base_convert(time(), 10, 36).".". base_convert(rand(), 10, 36);
        return $messageid;
 
    }
    /**
     * Generate a random Ticket Mask
     */
    function generateTicketMask()
    {
 
    //        $id=100;
        do
        {
 
            $prefix = strtoupper(chr(mt_rand(65,90)) . chr(mt_rand(65,90)) . chr(mt_rand(65,90)));
 
            $ticketmaskid = $prefix . "-" . mt_rand(100000,999999);
            //$_maskcheck =
 
            $query = $this->ci->db->get_where('swtickets', array('ticketmaskid' => $ticketmaskid));
            //ticketmaskid FROM '". TABLE_PREFIX ."' WHERE '' = '". $dbCore->escape() ."';");
            $id=$this->ci->db->count_all();
 
        } while ($id!=0);
 
        return $ticketmaskid;
 
    }