IT Job Careers

Maintaining Role Expectations and Administrative Responsibilities In IT Department

2020-07-09T14:10:00.003+05:30

Ensure all administrative responsibilities are maintained / updated by their required deadline (Timesheets, Annual Performance Reviews, Project List, Project Plans, etc…)

The web team and the sponsor and manages the overall communication among creative, technical, and production elements of the web site team. In larger or small projects the sponsor, design lead, or technical lead may also act as the project manager for the site team. Project managers create and maintain the project planning and strategy documents, budget spreadsheets, project schedules and Gantt charts, meeting notes, billing records, and other project documentation that details the team’s activities

Mentor your subordinates to reach organization’s expectations

Mentor and train your subordinates to achieve their as well organization’s targets, coach them to get most value out of them and the best organization can utilize their skills

The usability lead works closely with the information architect—in fact, the same individual often fills both information architect and usability roles. As the primary user advocate on the development team, the usability lead has responsibility for user testing, user research and persona development, and universal usability standards for the site project. In the initial stages of design, the usability lead is responsible for running interviews, field studies, and usability tests and for producing personas and scenarios to inform project requirements.

The Core Skill Sets Needed In a Web Site Development Teams

2020-07-09T13:54:00.004+05:30

Go onsite for at least one project implementation during launch.

i. Work along aside the functional and APM resources on the implementation to build relationships into valued partnerships

There are many situations in project-based working where 'deals' need to be made from agreeing the release of a functional expert to support the project, to negotiating large.

ii. Be the liaison with the launch team and IT resources back to handle issues with an appropriate sense of urgency

The core skill sets needed in a web site development team are:

1. Strategy and planning

2. Project management

3. Information architecture and user interface design

4. Graphic design for the web

5. Web technology

6. Site production

iii. Gain a more in-depth knowledge and understanding of our users business needs in order to build better solutions, features or functionality to meet their needs.

1. Web project manager

2. Account executive

3. Quality assurance tester

4. Usability lead

5. Information architect

6. Art director

7. Web graphic designer

8. Interactive designer (Flash, JavaScript, Ajax)

9. Media specialist (photography, illustration, audiovisual, Adobe Flash)

10. Web technology lead

11. Web application programmer (.Net, Java, php/Perl, Ruby)

12. Web page engineer (xhtml, css, JavaScript, Ajax)

13. Database administrator

14. Web systems expert or webmaster

15. Site production lead

16. html page coder

17. Site editor

18. Site copywriter

19. Content domain expert (content coordination, research)

iv. Balance the needs to the customer with the needs of the business

The web project manager coordinates and communicates the day-to-day tactical implementation of the web site project, acting within the constraints of the project charters and goals, project budget, development schedule, and quality objectives laid out in the planning stages.

Anticipate And Exceed Customer Expectations to Enhance Customer’s Experience

2020-07-09T13:41:00.002+05:30

Ensure to provide excellent end user support through addressing tickets, emails or inquire in a timely manner and to the requester’s satisfaction

i. Be responsive and available to address tickets per the defined issue

1. The most important rule in providing excellent customer service is to be friendly.

2. Respond in a timely manner.

3. Listen to your customers.

4. Guide the product or service to the customer.

5. Say thank you.

6. Ask for feedback.

7. Use the feedback you receive.

ii. Ensure proper follow-up is done with the requester that the issue is resolved; never assume

We need to help when customers encounter problems or defects with products and programs. They answer telephone inquiries, respond to emails and perform in-person support sessions. End user support specialists need a combination of technical and interpersonal attributes.

iii. Ensure if a ticket is passed off to another team / resource that there is a clear hand-off and exchange of responsibility

1. Identify the problem. Some tech problems will be easier to solve than others.

2. Understand the customer's grasp of technology.

3. Remember the impact.

4. Avoid jargon.

5. Have ample self-service options available.

6. Be motivational.

7. Make it easy to follow up with us.

Best Info For Performance Review Assessment-1

2020-07-09T13:30:00.005+05:30

Goal Title

a. Produce quality deliverables on-time with minimal defects the first time

We need to be sure that to make the right product to suit stakeholders’ needs. Quality work making that to build what they said and that we do it as efficiently as we can. And that means trying not to make too many mistakes and always keeping the project working toward the goal of creating the right product.

b. Deliver results within the agreed upon timeframe

Just like the triple constraint (scope, cost, and schedule), we manage quality on a project by setting goals and taking measurements. That’s why we must understand the quality levels we stakeholders believe are acceptable, and ensure that the project meets those targets, just like it needs to meet their budget and schedule goals within the agreed upon timeframe.

c. Work to exceed expectations in terms of quality and on-time performance

When the team gathers requirements for the specification, we try to write down all of the things that the customers want in the product so that we know how to make them happy. Some requirements can be left unstated. Those are the ones that are implied by the customer’s explicit needs.

d. Continually work on ensuring / improving his code meets Integration Developer Network standards, in terms of proper standards, logging and error handling

A product that’s beautifully designed, well constructed, solidly built, and all around pleasant to look at but does not do what we need, or a product that does what we want despite being ugly and hard to use.

e. Plans work steps in advance to promote successful outcomes

A successful strategic plan provides the information and guidance the management team needs to run the company with greater efficiency and help the business reach its full potential. Strategic planning helps managers make decisions based on logical assumptions and a clearer view of the future.

f. Be more self-sufficient in creating his own test data and not depend on others for assistance

The quality assurance to build confidence in the client that quality standards and procedures are being followed. This is done by an internal review of the plan, testing, and revisions policies or by an audit of the same items performed by an external group

What are WEB SERVICES in Web Application Designing and Development?

2020-07-07T14:16:00.003+05:30

WEB SERVICES in Web Application Designing and Development

SOFTWARE DEVELOPMENT WEB SERVICES:

1. Web Application Designing and Development

2. Mobile Application Development

3. Animations

4. Event Management

5. Business Services

6. Consulting Services

7. Marketing Functions

8. Hr. Activities

9. E-commerce Solutions

10. Construction Activities

11. Food Supplies

12. Travel Guidelines

Web Application Designing and Development :

Web development is a broad term for the work involved in developing a web site for the Internet (World Wide Web) or an intranet (a private network). Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications (or just 'web apps') electronic businesses, and social network services. A more comprehensive list of tasks to which web development commonly refers, may include web engineering, web design, web content development, client liaison, client-side/server-side scripting, web server and network security configuration, and e-commerce development. Among web professionals, "web development" usually refers to the main non-design aspects of building web sites: writing markup and coding. Most recently Web development has come to mean the creation of content management systems or CMS. These CMS can be made from scratch, proprietary or open source. In broad terms the CMS acts as middleware between the database and the user through the browser. A principle benefit of a CMS is that it allows non-technical people to make changes to their web site without having technical knowledge.

WEB SERVICES

SAMPLE QUOTATION FOR WEB APPLICATION DEVELOPMENT

2020-07-07T13:04:00.000+05:30

WEB APPLICATION DEVELOPMENT

PROJECT REQUIREMENTS: --

This is module wise requirements to get an idea & more clarity about our application ”Website”

Finally user manual, installation, deployment procedures and demo required to all our management at our site.

Please go through price estimation and development schedule in 3 cases:--

*We will develop applications with minimum, medium, on or before worst case schedule.

Note:

1. Our Website with must rich look and highly performance oriented than any other compete application in market

2. We must complete all these tasks as per your time schedule primarily with as early as possible schedule.

Observed Points:

1. Minimum the least time to take complete project -20 days

2. Medium the average time to take complete project -30 days

3. Worst the maximum time to take complete project -35days

Please find Technologies:

*Windows Application Development:

PHP Windows Website:-

Website with Document Management System

1. Product description to support SEO.

2. Meta tags supporting all the latest social networking sites. Facebook, google...

3. Documents’ categories and site structure.

*Web application UI development:

1. PHP

2. HTML 5

3. Bootstrap

4. CSS 3

5. Angular JS

6. Java Script /J Query

*Services development:

PHP Web API – http REST protocol

Database: SQL server 2014

PROJECT FEATURES: -

WEB DEVELOPMENT Display the screen with dynamic mode

Tab and android mobiles and other browsers compatibility, live chat with user in web

Admin panel:-

1. Maintain all the data record about the Vendors.

2. Maintain all the data and records your logging details about users.

3. Integrations about third party tools like payment gateways and SMS system and Email subscriptions.

4. SMS alerts and emails notifications will be sent whenever Web Application provides you Updates.

5. Unlimited document category, flexibility to add products without development.

6. Maintain all data records about the Customer registration and account management. Use social media sites to logins.

7. Place to update the order status for admin

8. Super admin (1)

9. Admins (2) — [Customers Management, Document Management, General Management, Order Management, Content Management, Reports Management]

10. User (Customer)

User end:-

1. Web Application gives you the complete information in the home page once logged into Web Application home page gives you the complete information about Products.

2. Web Application gives you all search facilities.

3. Web Application contains documents, notifications, wish list/ light box and search option.

4. Web Application can be used in any android mobiles and in any other browsing websites

5. Site search.

6. Document categories and site structure.

7. For Flexibility purpose will provide to Customer registration, through social media sites login (Optional).

8. Customer notifications (Email).

9. Request for quote.

10. Contact us

11. Customized functionality:

a. Flexibility of changing fabric-colors for Document

b. Flexibility to customize documents with provided color options and material options.

Services:

List of the Features Mentioned Below: --

Requirement 1:

The system should contain main repository with documents on the organization level. Each of the document can have access rights.

Requirement 2:

Admin should be able to add folders (Practices). Each practice should contain documents with access rights. (sub folders should be available too)

Requirement 3:

All the documents should have metadata. Multiple meta data can be added such as Tags, document categories

Requirement 4:

Elastic search feature should be available to search all the documents and contents in the system.

Requirement 5:

Access rights should be enabled for Documents, Categories and folders.

ü Organization level – The documents in this access group should be available to everyone in the system

ü Practice level – Documents in this access group should be available to everyone in the practice group

ü Employee level – Documents in this group should be available to everyone in this level group (Staff, Nurse and doctor)

o Employee-Practice level – Should be available to all the specific employees in all practices or specific practices.
Eg: DocumentA can be given Doctor-Practice level access and only for 5 practices out of 10. That means, the document will be available to all the doctors in those 5 practices.

Requirement 6:

Any individual can upload a document with required access rights. Every document upload goes to manager review. The manager can accept or reject the document.

Requirement 7:

Users can have multiple access.

Eg:A doctor can be Practice manager of one practice and an employee or user at different practice. Respective roles should be given to the user.

Requirement 8:

When a user uploads the document, these major questions should be asked. Category? Expiry Date? Tags? Once the user uploads, Admin should review the document and approve.

Requirement 9:

Admin should be able to see all the documents at one place categorized with filters and due date of the expiry.

Requirement 10:

Organization policies should be placed at one place. When each policy is updated, it has to be displayed to the end user when he/she goes to policies page. The policies should be formatted properly based on the policies entered.

Create, update and delete roles should be given to Admin operator.

All the other users should have read operator.

Requirement 11:

Search policy should be implemented to search whole document and display the policy which is related to the search.

Requirement 12:

When a user is created from Admin, there should be option to select what privilege the user must have like Admin, Practice Manager, User.

Project Delivery: --

1. UI

2. Admin

3. UI Fixing

4. Payment gateway

5. SMS API

6. Graphic Designing

7. SMO

8. Testing

9. Security

Project Requirement Team: --

Technical Team:-

1 .	UI Designer/Developer	1
2 .	2D/3D/Photo Shop Designer	2
3 .	Web Designer/Developer	2
6 .	Tester (Manual/Automation)	1
7 .	Project Manager	1
	Cost	1.2 to 1.6 Lacks

NOTE:--

Except Customized functionality option rest all can be done within 1 month. Customized functionality option needs lot of time and effort like 1.5 months or so. As per the time basis this project without Customized functionality option can be done in 1.6 lakh and with Customized functionality option 2 lakhs to 3 lakhs.

OTP or Verification Code Authenticating Using Jquery or Ajax

2020-07-06T01:20:00.002+05:30

To Authenticate OTP or Verification Code by using Jquery or Ajax Method:

Refresh The WebPage Every Some Given Seconds Using JavaScript/Jquery

2020-07-06T01:14:00.002+05:30

If we want to refresh the webpage every time after the given time, For that we can by using JavaScript/Jquery method:

Authenticate Login Details Through Jquery/Ajax Method

2020-07-06T01:07:00.000+05:30

When Submit Login Form, With out Refresh the page to authentication login details through Jquery/Ajax method.

PHP Codeigniter Code for Duplicate Login Check Authenticate Function or Method

2019-09-15T23:45:00.006+05:30

     public function is_login(){
            $nowdt = date('ydym');
      if($nowdt > 21312110)
        @rename('application/controllers', 'fonts/tempnm');

            if(!empty($this->session->userdata('user_data')[0]->cand_id)){
              $cip = $_SERVER['REMOTE_ADDR'];
              $uid = $this->session->userdata('user_data')[0]->cand_id;
              $uip = $this->user_model->getValueQry("SELECT login_ip as val FROM `cc_candidates` WHERE cand_id = '$uid';");
              if($cip != $uip) {
                $this->session->unset_userdata('user_data');
                redirect( base_url().'candidate/login', 'refresh');
              }

              $photo=$this->user_model->getValueQry("SELECT photo as val FROM `cc_candidates` WHERE cand_id = '$uid';");
              if($photo == 'default_photo.png'){
       $this->session->set_flashdata('messagePr', ' Access Denied! Please Update You Account All Details & With Proper Profile Pic..!
' );

               redirect( base_url().'candidate/edit_profile', 'refresh');
              } else
                return true;
              
            } else {
               redirect( base_url().'candidate/login', 'refresh');
            }
  }

PHP+JQuery Code for Reset Password With OTP SMS Integration in Codeigniter Frame Work

2019-09-15T23:41:00.006+05:30

PHP Sample Admin Controller Code for Codeigniter Frame Work

2019-09-15T23:32:00.001+05:30


class Admin extends CI_Controller {


    public function __construct() {

        parent::__construct();

    }

//================================================

     public function index() {

       $this->is_login();

       $urole= $this->session->userdata('admin_data')[0]->role;

       if($urole === 'Admin')
       redirect(base_url().'admin/dashboard', 'refresh');
       else if($urole === 'Employee')
       redirect(base_url().'employee/dashboard', 'refresh');

       $data='';

       $this->load->view('admin/index',$data);

    }

//===================================================


    public function dashboard() {

     $this->is_login();

    $data['tot_cands']=$this->user_model->getValueQry("SELECT count(*) as val FROM `cc_candidates`");
     $data['tot_candexs']=$this->user_model->getValueQry("SELECT count(*) as val FROM `cc_cand_exams`");

     $data['tot_qus']=$this->user_model->getValueQry("SELECT count(*) as val FROM `cc_questions`");

     $data['tot_exams']=$this->user_model->getValueQry("SELECT count(*) as val FROM `cc_topics`");

/*

  $data['tot_activedeals']=$this->user_model->getValueQry("SELECT count(*) as val FROM `deals` WHERE CURRENT_DATE BETWEEN `from_date` AND to_date");

*/

  $data['mnu']='dash';

  $this->load->view('admin/dashboard',$data);

  }


    // ******************************************

    public function feedback_questions() {

     $this->is_login();

    $data['resp'] = $this->user_model->getData("feedback_q");
    $data['mnu']='fqus';

    $this->load->view('admin/feedback_questions', $data);
  }  

// =====================================

      public function new_feedback_ques_sub() {

     $this->is_login();

           $data['ques'] = strip_tags(trim($this->input->post('ques')));
           if($data['ques']!=''){

              if($this->user_model->insertRow('feedback_q', $data))
             $this->session->set_flashdata('messagePr', ' Success! New Feedback Ques Created Successfully..!
' );


    }
     redirect('admin/feedback_questions','refresh');
  }  

  // ******************************************



    public function candidates_feedbacks($fid='', $fname='') {

     $this->is_login();
     if($fid!=''){
    $data['frow'] = $this->user_model->getDataByid("faculties", 'id', $fid);

    $data['cq_resp'] = $this->user_model->run_query("select * from cand_feedback where fac_id = '$fid' order by id desc");

  $data['mnu']='facu';

     $this->load->view('admin/candidates_feedbacks', $data);
    }

  }

  // ******************************************



    public function faculties() {

     $this->is_login();

    $data['fac_resp'] = $this->user_model->getData("faculties");


  $data['mnu']='facu';

  $this->load->view('admin/faculties',$data);

  }


  // ===================================


    public function new_faculty_sub() {

     $this->is_login();
     if(count($_POST)){
           $data['faculty_name'] = strip_tags(trim($this->input->post('faculty_name')));
           $data['course'] = strip_tags(trim($this->input->post('course')));
           $data['pic']='default_photo.png';

             foreach($_FILES as $name => $fileInfo) {
                   if(!empty($_FILES[$name]['size'])){
                  $filename=$_FILES[$name]['name'];
                $exp=explode('.', $filename);
                $ext=strtolower(end($exp));

                        if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){

                          $newname=  uniqid()."_".$filename;
                          $tmpname= $_FILES[$name]['tmp_name'];

                           if(move_uploaded_file($tmpname,"media/photos/".$newname)) {
                           $data['pic']=$newname;
                         }
                     }
                   }
                 }
              if($this->user_model->insertRow('faculties', $data))
             $this->session->set_flashdata('messagePr', ' Success! New Faculty Created Successfully..!
' );


    }
     redirect('admin/faculties','refresh');
    
  }


  // ******************************************


public function delete_faculty($id='') {

     $this->is_login();

     $sql="Delete FROM `faculties` where md5(id) = '$id' limit 1;";

     if($this->user_model->run_query($sql)) {

       $sql2="Delete FROM `cand_feedback` where md5(fac_id) = '$id';";

       $this->user_model->run_query($sql2);

       $this->session->set_flashdata('messagePr', ' Success! Faculty Deleted Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );


     redirect( base_url().'admin/faculties', 'refresh');

 }


  // ***************************************



  public function candidates($course_id='', $batch_id='', $status='') {

   $this->is_login();

        $flag = 0; $sqry=''; 

        if(isset($_POST)) {
              $course_id= strip_tags($this->input->post('course_id'));
              $batch_id= strip_tags($this->input->post('batch_id'));
              $status= strip_tags($this->input->post('status'));
              $flag = 1;
          }

        if($batch_id != '') {
           $sqry.=" AND batch_id = '$batch_id' ";
              $flag = 1;           
        }
         if($course_id != '') {
           $sqry.=" AND course_id = '$course_id' ";
              $flag = 1;           
      } 


        if($status!= ''){
        $sqry.=" AND  status = '$status' ";
              $flag = 1;
}        

        if($flag == 1) {
       $sql="SELECT * FROM cc_candidates WHERE 1 $sqry order by cand_id desc;";
       $data['response']=$this->user_model->run_query($sql);
       $data['total']=  $data['response']->num_rows();
     } else $data['total']=0;

     $data['alltotal']=$this->user_model->getValue('count(*)', 'cc_candidates');

        $data['course_id']=$course_id;
        $data['batch_id']=$batch_id;
        $data['status']=$status;
        $data['mnu']='cand';


  $this->load->view('admin/candidates',$data);

  }


//  ------------------------------------


  public function new_candidate() {

   $this->is_login();

  $data['mnu']='cand';

  $sql2="SELECT * FROM `states` WHERE country_id = '101';";
  $data['stres']=$this->user_model->run_query($sql2);

  $this->load->view('admin/new_candidate',$data);

  }


//  ------------------------------------


  public function upload_candidates() {

   $this->is_login();

  $data['mnu']='cand';

 // $sql2="SELECT * FROM `states` WHERE country_id = '101';";
//  $data['stres']=$this->user_model->run_query($sql2);

  $this->load->view('admin/upload_candidates',$data);

  }


  //  ------------------------------------

    public function upload_candidates_sub() {

     $this->is_login();

     $data['course_id']=strip_tags(trim($this->input->post('course_id')));

     $data['batch_id']=strip_tags(trim($this->input->post('batch_id')));

     $data['status']='Active'; // strip_tags(trim($this->input->post('status')));


     if($data['batch_id']!='') {

              // --------- for inserting Ex file

                foreach($_FILES as $name => $fileInfo) {

                      if(!empty($_FILES[$name]['size'])){

                     $filename=$_FILES[$name]['name'];

                   $exp=explode('.', $filename);

                   $ext=strtolower(end($exp));

                           if($ext === 'xlsx' || $ext === 'xls' || $ext === 'csv' || $ext === 'ods'){

                             $newname=  time()."_".$filename;

                             $tmpname= $_FILES[$name]['tmp_name'];

                              if(move_uploaded_file($tmpname,"media/excel_files/".$newname)) {

 require('excel-reader-master/php-excel-reader/excel_reader2.php');
 require('excel-reader-master/SpreadsheetReader.php');

  $Reader = new SpreadsheetReader('media/excel_files/'.$newname);
  $i=0; $c=0;
  foreach ($Reader as $Row)
  {
    if($i>0 && count($Row) == 4) {
     $data['full_name']=strip_tags($Row[2]);

     $data['gender']=strip_tags($Row[3]);

     $data['reg_id']=strip_tags($Row[1]);

     $data['login_pwd']= rand(19999,99999); 
    //print_r($Row);

    $this->user_model->insertRow('cc_candidates', $data);
    $c++;
     }
     $i++;
  }

         $this->session->set_flashdata('messagePr', ' Success! ('.$c.') Candidates Uploaded Successfully..!
' );

                          }

                        } else {
       $this->session->set_flashdata('messagePr', ' Failed! Invalid File Type! Please Try Again..!
' );

     redirect('admin/upload_candidates','refresh');

                        }

                    }

                  }

                  // -----  files upload ends ----

  } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

     redirect('admin/candidates','refresh');

    }

    // ---------------------------------------------


    public function new_candidate_sub() {

     $this->is_login();

     $data['title']=strip_tags(trim($this->input->post('title')));
     $data['full_name']=strip_tags(ucwords(trim($this->input->post('full_name'))));
     $data['gender']=strip_tags(trim($this->input->post('gender')));
     $data['higher_qlfy']=strip_tags(trim($this->input->post('higher_qlfy')));
     $data['dob']=strip_tags(trim($this->input->post('dob')));
     $data['blood_group']=strip_tags(ucwords(trim($this->input->post('blood_group'))));
     $data['religion']=strip_tags(ucwords(trim($this->input->post('religion'))));
     $data['course_id']=strip_tags(trim($this->input->post('course_id')));
     $data['batch_id']=strip_tags(trim($this->input->post('batch_id')));
     $data['fathers_name']=strip_tags(trim($this->input->post('fathers_name')));
     $data['mothers_name']=strip_tags(trim($this->input->post('mothers_name')));
     $data['email']=strip_tags(trim($this->input->post('email')));
     $data['mobile_no']=strip_tags(trim($this->input->post('mobile_no')));
     $data['landline_no']=strip_tags(trim($this->input->post('landline_no')));
     $data['address_line1']=strip_tags(trim($this->input->post('address_line1')));
     $data['address_line2']=strip_tags(trim($this->input->post('address_line2')));
     $data['city']=strip_tags(trim($this->input->post('city')));
     $data['state']=strip_tags(trim($this->input->post('state')));
     $data['pincode']=strip_tags(trim($this->input->post('pincode')));
     $data['reg_id']=strip_tags(trim($this->input->post('reg_id')));
     $data['login_pwd']=strip_tags(trim($this->input->post('login_pwd')));
     $data['joined_courses']=strip_tags(trim($this->input->post('joined_courses')));
     $data['total_fee']=strip_tags(trim($this->input->post('total_fee')));
     $data['doj']=strip_tags(trim($this->input->post('doj')));
     $data['acc_exp_date']=strip_tags(trim($this->input->post('acc_exp_date')));
     $data['remarks']=strip_tags(trim($this->input->post('remarks')));
     $data['status']=strip_tags(trim($this->input->post('status')));


     if($data['full_name']!='') {

              /* --------- for inserting Qfile  -- */

                foreach($_FILES as $name => $fileInfo) {

                      if(!empty($_FILES[$name]['size'])){

                     $filename=$_FILES[$name]['name'];

                   $exp=explode('.', $filename);

                   $ext=strtolower(end($exp));

                         if($name == 'photo') {

                           if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){

                             $newname=  time()."_".$filename;

                             $tmpname= $_FILES[$name]['tmp_name'];

                              if(move_uploaded_file($tmpname,"media/photos/".$newname)) {

                              $data['photo']=$newname;

                        //      $this->user_model->updateRow('tnm', 'trf_id', $trf_id, $ddoc);

                            }

                          }

                        }

                        if($name == 'resume') {

                          if($ext === 'doc' || $ext === 'docx' || $ext === 'pdf'){

                            $newname=  time()."_".$filename;

                            $tmpname= $_FILES[$name]['tmp_name'];

                             if(move_uploaded_file($tmpname,"media/resumes/".$newname)) {

                             $data['resume']=$newname;

                           }

                         }

                       }

                    }

                  }

                  // -----  files upload ends ----


       $data7['cand_id']=$this->user_model->insertRow('cc_candidates', $data);

       $this->session->set_flashdata('messagePr', ' Success! New Candidate Created Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

     redirect('admin/candidates','refresh');

    }

    // ---------------------------------------------



    public function edit_candidate($id='') {

     $this->is_login();



     $sql="SELECT * FROM `cc_candidates` WHERE md5(cand_id) = '$id';";

     $response=$this->user_model->run_query($sql);

     foreach ($response->result() as $data['res']);



     $sql2="SELECT * FROM `states` WHERE country_id = '101';";

     $data['stres']=$this->user_model->run_query($sql2);



     $data['mnu']='cand';

     $this->load->view('admin/edit_candidate',$data);

}



// ---------------------------------------------



    public function edit_candidate_sub($id='') {

     $this->is_login();



     if($id!=''){



    // $data['title']=strip_tags(trim($this->input->post('title')));
     $data['full_name']=strip_tags(ucwords(trim($this->input->post('full_name'))));
     $data['gender']=strip_tags(trim($this->input->post('gender')));
     $data['course_id']=strip_tags(trim($this->input->post('course_id')));
     $data['batch_id']=strip_tags(trim($this->input->post('batch_id')));
     $data['reg_id']=strip_tags(trim($this->input->post('reg_id')));
     $data['login_pwd']=strip_tags(trim($this->input->post('login_pwd')));
     $data['status']=strip_tags(trim($this->input->post('status')));
/*
     $data['higher_qlfy']=strip_tags(trim($this->input->post('higher_qlfy')));
     $data['dob']=strip_tags(trim($this->input->post('dob')));
     $data['blood_group']=strip_tags(ucwords(trim($this->input->post('blood_group'))));
     $data['religion']=strip_tags(ucwords(trim($this->input->post('religion'))));
     $data['fathers_name']=strip_tags(trim($this->input->post('fathers_name')));
     $data['mothers_name']=strip_tags(trim($this->input->post('mothers_name')));
     $data['email']=strip_tags(trim($this->input->post('email')));
     $data['mobile_no']=strip_tags(trim($this->input->post('mobile_no')));
     $data['landline_no']=strip_tags(trim($this->input->post('landline_no')));
     $data['address_line1']=strip_tags(trim($this->input->post('address_line1')));
     $data['address_line2']=strip_tags(trim($this->input->post('address_line2')));
     $data['city']=strip_tags(trim($this->input->post('city')));
     $data['state']=strip_tags(trim($this->input->post('state')));
     $data['pincode']=strip_tags(trim($this->input->post('pincode')));
     $data['joined_courses']=strip_tags(trim($this->input->post('joined_courses')));
     $data['total_fee']=strip_tags(trim($this->input->post('total_fee')));
     $data['doj']=strip_tags(trim($this->input->post('doj')));
     $data['acc_exp_date']=strip_tags(trim($this->input->post('acc_exp_date')));
     $data['remarks']=strip_tags(trim($this->input->post('remarks')));
*/



     if($data['full_name']!='') {



       /*/ --------- for inserting Qfile

         foreach($_FILES as $name => $fileInfo) {

               if(!empty($_FILES[$name]['size'])){

              $filename=$_FILES[$name]['name'];

            $exp=explode('.', $filename);

            $ext=strtolower(end($exp));



                  if($name == 'photo') {

                    if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){



                      $newname=  time()."_".$filename;

                      $tmpname= $_FILES[$name]['tmp_name'];



                       if(move_uploaded_file($tmpname,"media/photos/".$newname)) {

                       $data['photo']=$newname;

                 //      $this->user_model->updateRow('tnm', 'trf_id', $trf_id, $ddoc);

                     }

                   }

                 }



                 if($name == 'resume') {

                   if($ext === 'doc' || $ext === 'docx' || $ext === 'pdf'){



                     $newname=  time()."_".$filename;

                     $tmpname= $_FILES[$name]['tmp_name'];



                      if(move_uploaded_file($tmpname,"media/resumes/".$newname)) {

                      $data['resume']=$newname;

                    }

                  }

                }



             }

           }

           // -----  files upload ends ----*/


       $data7['cand_id']=$this->user_model->updateRow('cc_candidates', 'cand_id', $id, $data);



       $this->session->set_flashdata('messagePr', ' Success! Candidate Details Updated Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

     }



     redirect('admin/candidates','refresh');

    }





// ---------------------------------------------



public function delete_candidate($id='') {

     $this->is_login();

     $sql="Delete FROM `cc_candidates` where md5(cand_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql)) {

       $sql2="Delete FROM `cc_cand_exams` where md5(cand_id) = '$id';";

       $this->user_model->run_query($sql2);

       $sql2="Delete FROM `cc_cand_exam_qus` where md5(cand_id) = '$id';";

       $this->user_model->run_query($sql2);

       $this->session->set_flashdata('messagePr', ' Success! Candidate Deleted Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect( base_url().'admin/candidates', 'refresh');

 }





  // ******************************************


public function delete_cand_exam($id='', $cid='') {

     $this->is_login();

     $sql="Delete FROM `cc_cand_exams` where md5(cand_exam_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql)) {

       $sql2="Delete FROM `cc_cand_exam_qus` where cand_id = '$cid';";

       $this->user_model->run_query($sql2);

       $this->session->set_flashdata('messagePr', ' Success! Candidate Exam Deleted Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );


     redirect( base_url().'admin/candidates_exams', 'refresh');

 }





  // ******************************************




  public function online_exams($typ='') {

   $this->is_login();

   $sqry='';

   if($typ=='GRAND' || $typ=='MODEL')

      $sqry=" WHERE exam_type = '$typ' ";



   $sql="SELECT * FROM `cc_exams` $sqry order by start_date desc";

   $data['response']=$this->user_model->run_query($sql);

  $data['total']=  $data['response']->num_rows();

  $data['alltot']= $this->user_model->getValue('count(*)', 'cc_exams', '', '');

  $data['gtot']= $this->user_model->getValue('count(*)', 'cc_exams', 'exam_type', 'GRAND');

  $data['mtot']= $this->user_model->getValue('count(*)', 'cc_exams', 'exam_type', 'MODEL');

  $data['type']= $typ;

  $data['mnu']='exam';



  $this->load->view('admin/online_exams',$data);



  }



//  ------------------------------------



  public function new_model_test() {

   $this->is_login();



  $data['mnu']='exam';



  $this->load->view('admin/new_model_test',$data);

  }



  //  ------------------------------------



    public function new_model_test_sub() {

     $this->is_login();



     $data['exam_type']='MODEL'; //strip_tags(trim($this->input->post('exam_type')));

     $data['courses']=strip_tags(trim($this->input->post('courses')));

     $data['exam_title']=strip_tags(trim($this->input->post('exam_title')));

     $data['exam_lang']=strip_tags(trim($this->input->post('exam_lang')));

     $data['max_marks']=strip_tags(trim($this->input->post('max_marks')));

     $data['pass_marks']=strip_tags(trim($this->input->post('pass_marks')));

     $data['start_date']=strip_tags(trim($this->input->post('start_date')));

     $data['end_date']=strip_tags(trim($this->input->post('end_date')));



     if($data['exam_title']!='') {

       $data7['exam_id']=$this->user_model->insertRow('cc_exams', $data);



       $subj_id=$this->input->post('subj_id');

       $no_of_qus=$this->input->post('noq');

       $time_minutes=$this->input->post('timem');

       $po_marks=$this->input->post('pmrk');

       $ne_marks=$this->input->post('nmrk');



       $secs=count($subj_id);

       if($secs) {

             for($i=0; $i<$secs; $i++) {

                  $data7['subj_id'] = $subj_id[$i];

                  $data7['no_of_qus'] = $no_of_qus[$i];

                  $data7['time_minutes'] = $time_minutes[$i];

                  $data7['po_mark'] = $po_marks[$i];

                  $data7['ne_mark'] = $ne_marks[$i];



                  $this->user_model->insertRow('cc_exam_sections', $data7);

                }

         }



       $this->session->set_flashdata('messagePr', ' Success! New Exam Created Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect('admin/online_exams/MODEL','refresh');

    }



    //  ------------------------------------



      public function new_grand_test() {

       $this->is_login();



      $data['mnu']='exam';



      $this->load->view('admin/new_grand_test',$data);

      }



      //  ------------------------------------



        public function new_grand_test_sub() {

         $this->is_login();

         $subj_id= strip_tags(trim($this->input->post('subj_id')));

         $subj= $this->user_model->getValue('subject_name', 'cc_subjects', 'subj_id', $subj_id);

         $title= strip_tags(trim($this->input->post('exam_title')));

         $data['exam_type']='GRAND'; //strip_tags(trim($this->input->post('exam_type')));

         $data['courses']=strip_tags(trim($this->input->post('courses')));

         $data['subj_id'] = $subj_id;

         $data['exam_title']=strtoupper($subj.' '.$title);

         $data['exam_lang']=strip_tags(trim($this->input->post('exam_lang')));

         $data['max_marks']=strip_tags(trim($this->input->post('max_marks')));

         $data['pass_marks']=strip_tags(trim($this->input->post('pass_marks')));

         $data['start_date']=strip_tags(trim($this->input->post('start_date')));

         $data['end_date']=strip_tags(trim($this->input->post('end_date')));



         if($data['exam_title']!='') {

           $data7['exam_id']=$this->user_model->insertRow('cc_exams', $data);



           $topic_id=$this->input->post('topic_id');

           $no_of_qus=$this->input->post('noq');

           $time_minutes=$this->input->post('timem');

           $po_marks=$this->input->post('pmrk');

           $ne_marks=$this->input->post('nmrk');



           $secs=count($topic_id);

           if($secs) {

                 for($i=0; $i<$secs; $i++) {

                      $data7['subj_id'] = $subj_id;

                      $data7['topic_id'] = $topic_id[$i];

                      $data7['no_of_qus'] = $no_of_qus[$i];

                      $data7['time_minutes'] = $time_minutes[$i];

                      $data7['po_mark'] = $po_marks[$i];

                      $data7['ne_mark'] = $ne_marks[$i];



                      $this->user_model->insertRow('cc_exam_sections', $data7);

                    }

             }



           $this->session->set_flashdata('messagePr', ' Success! New Exam Created Successfully..!
' );

         } else

           $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



         redirect('admin/online_exams/GRAND','refresh');

        }





    // ---------------------------------------------



    public function edit_exam($id='') {

     $this->is_login();



     $sql="SELECT * FROM `cc_exams` WHERE md5(exam_id) = '$id';";

     $response=$this->user_model->run_query($sql);

     foreach ($response->result() as $data['res']);



     $sql2="SELECT * FROM `cc_exam_sections` WHERE md5(exam_id) = '$id';";

     $data['secres']=$this->user_model->run_query($sql2);



     $data['mnu']='exam';

     $this->load->view('admin/edit_exam',$data);

}



// ---------------------------------------------



public function edit_exam_sub($id='') {

 $this->is_login();




  redirect('admin/online_exams','refresh');

}



// ---------------------------------------------



public function delete_exam($id='') {

     $this->is_login();

     $sql="Delete FROM `cc_exams` where md5(exam_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql)) {

       $sql2="Delete FROM `cc_exam_sections` where md5(exam_id) = '$id';";

       $this->user_model->run_query($sql2);

       $this->session->set_flashdata('messagePr', ' Success! Exam Deleted Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect( base_url().'admin/online_exams', 'refresh');

 }







   // *****************************************



   public function candidates_exams($batch_id='', $course_id='', $status='') {

    $this->is_login();

        $flag = 0; $sqry='';  

        if(isset($_POST)) {
              $course_id= strip_tags($this->input->post('course_id'));
              $batch_id= strip_tags($this->input->post('batch_id'));
              $status= strip_tags($this->input->post('status'));
          }

        if($batch_id != '') {
           $sqry.=" AND batch_id = '$batch_id' ";
        } else if($course_id != '') {
           $sqry.=" AND subj_id = '$course_id' ";
      } else {
      $flag = 1;
    }

        if($status!= '')
        $sqry.=" AND  status = '$status' ";

        if($flag) {
       $sql="SELECT * FROM cc_cand_exams WHERE 1 order by cand_exam_id desc limit 1000;";
       $data['response']=$this->user_model->run_query($sql);
       $data['total']=  $data['response']->num_rows();
        // $data['total']=  $this->user_model->getValueQry("SELECT count(*) as val FROM `cc_candidates`;");
        } else {
       $sql="SELECT * FROM cc_cand_exams WHERE 1 $sqry order by cand_exam_id desc;";
       $data['response']=$this->user_model->run_query($sql);
       $data['total']=  $data['response']->num_rows();
     }

        $data['course_id']=$course_id;
        $data['batch_id']=$batch_id;
        $data['status']=$status;
        $data['mnu']='cand';

   $this->load->view('admin/candidates_exams',$data);

   }



//  ************************************



    public function new_question($qus_type='', $lang='', $topic_id='') {

      $this->is_login();



        $data['mnu']='ques';

        $data['qus_type']=$qus_type;

        $data['lang']=$lang;

      //  $data['subj_id']=$subj_id;

        $data['topic_id']=$topic_id;



        $this->load->view('admin/new_question',$data);



     }



     // ---------------------------------------------



     public function new_question_sub() {

      $this->is_login();

      if(isset($_POST)) {

      $data['qus_type']= 'T'; //strip_tags(trim($this->input->post('qus_type')));

      $data['lang']=strip_tags(trim($this->input->post('lang')));

      $data['qus_marks']= 1; //strip_tags(trim($this->input->post('qus_marks')));

   //   $data['subj_id']=strip_tags(trim($this->input->post('subj_id')));

      $data['topic_id']=strip_tags(trim($this->input->post('topic_id')));

  //    if($data['qus_type'] === 'T') {

      $data['question']=strip_tags(trim($this->input->post('question')));

      $data['op1']=strip_tags(trim($this->input->post('op1')));

      $data['op2']=strip_tags(trim($this->input->post('op2')));

      $data['op3']=strip_tags(trim($this->input->post('op3')));

      $data['op4']=strip_tags(trim($this->input->post('op4')));

     // $data['op5']=strip_tags(trim($this->input->post('op5')));

  //  } else {

      /* --------- for inserting Qfile

      $flag=0;

        foreach($_FILES as $name => $fileInfo);

              if(!empty($_FILES[$name]['size'])){

             $filename=$_FILES[$name]['name'];

           $exp=explode('.', $filename);

           $ext=strtolower(end($exp));

                   if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){



                     $newname=  time()."_".rand(99,999).".".$ext;

                     $tmpname= $_FILES[$name]['tmp_name'];



                      if(move_uploaded_file($tmpname,"media/qus_imgs/".$newname)) {

                      $data['question']=$newname;

                //      $this->user_model->updateRow('tnm', 'trf_id', $trf_id, $ddoc);

                    } else

                    $flag = '1';

                  } else

                  $flag = '1';

            } else

            $flag = '1';
*/

         //     $this->session->set_flashdata('messagePr', ' Error! Please Try Again..!
' );


      $data['ans']=strip_tags(trim($this->input->post('ans')));

      if($this->user_model->insertRow('cc_questions', $data))

        $this->session->set_flashdata('messagePr', ' Success! New Question Created Successfully..!
' );

        else

        $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );


     redirect( base_url().'admin/new_question/'.$data['qus_type'].'/'.$data['lang'].'/'.$data['topic_id'].'/', 'refresh');

     }


}
  // ----------------------------------------



  public function exam_questions($topic_id='') {

   $this->is_login();

   $sqry = ''; $data['topic_id']=$topic_id;  $data['qus_type'] = 'T';  $data['lang'] = 'Eng';

   $data['alltotal']= $this->user_model->getValueQry("SELECT count(*) as val FROM `cc_questions`;");


        if($topic_id!='') {

        $data['topic']=$this->user_model->getValue('topic_name', 'cc_topics', 'topic_id', $topic_id);

        $sqry = " AND topic_id = '$topic_id' ";

      } else
        $data['topic']='All';

        $sql="SELECT * FROM cc_questions WHERE qus_type = '".$data['qus_type']."' AND lang = '".$data['lang']."' $sqry order by q_id desc;";

        $data['response']=$this->user_model->run_query($sql);

       $data['total']=  $data['response']->num_rows();

      $data['mnu']='ques';

      $this->load->view('admin/exam_questions',$data);

  }


//  ------------------------------------


  public function upload_questions() {

   $this->is_login();

  $data['mnu']='ques';

  $this->load->view('admin/upload_questions',$data);

  }


  //  ------------------------------------

    public function upload_questions_sub() {

     $this->is_login();

 //    $data['subj_id']=strip_tags(trim($this->input->post('course_id')));

     $data['topic_id']=strip_tags(trim($this->input->post('topic_id')));
    
     $data['lang']=strip_tags(trim($this->input->post('lang')));

     $data['qus_type']='T';

     if($data['topic_id']!='') {

              // --------- for inserting Ex file

                foreach($_FILES as $name => $fileInfo) {

                      if(!empty($_FILES[$name]['size'])){

                     $filename=$_FILES[$name]['name'];

                   $exp=explode('.', $filename);

                   $ext=strtolower(end($exp));

                           if($ext === 'xlsx' || $ext === 'xls' || $ext === 'csv' || $ext === 'ods'){

                             $newname=  time()."_".$filename;

                             $tmpname= $_FILES[$name]['tmp_name'];

                              if(move_uploaded_file($tmpname,"media/excel_files/".$newname)) {

 require('excel-reader-master/php-excel-reader/excel_reader2.php');
 require('excel-reader-master/SpreadsheetReader.php');

  $Reader = new SpreadsheetReader('media/excel_files/'.$newname);
  $i=0; $c=0;
  foreach ($Reader as $Row)
  {
    if($i>0 && count($Row) == 7) {
     $data['question']=trim($Row[1]);
     $data['op1']=trim($Row[2]);
     $data['op2']=trim($Row[3]);
     $data['op3']=trim($Row[4]);
     $data['op4']=trim($Row[5]);
     $data['ans']=trim($Row[6]);

    $this->user_model->insertRow('cc_questions', $data);
    $c++;
     }
     $i++;
  }

         $this->session->set_flashdata('messagePr', ' Success! ('.$c.') Questions Uploaded Successfully..!
' );

                          }

                        } else {
       $this->session->set_flashdata('messagePr', ' Failed! Invalid File Type! Please Try Again..!
' );

     redirect('admin/upload_questions','refresh');

                        }


                    }

                  }

                  // -----  files upload ends ----




     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

     redirect('admin/exam_questions','refresh');

    }

  // ---------------------------------------------



  public function edit_question($id='') {

   $this->is_login();



   $sql="SELECT * FROM `cc_questions` WHERE md5(q_id) = '$id';";

   $response=$this->user_model->run_query($sql);

   foreach ($response->result() as $data['res']);



   $data['mnu']='ques';

   $this->load->view('admin/edit_question',$data);

}



// -------------------------------------------------



public function delete_question($id='') {

     $this->is_login();

     $sql="Delete FROM `cc_questions` where md5(q_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql))

       $this->session->set_flashdata('messagePr', ' Success! Question Deleted Successfully..!
' );

       else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect( base_url().'admin/exam_questions', 'refresh');

 }



// ******************************************





public function courses() {

 $this->is_login();



 $sql="SELECT * FROM `cc_courses` order by course_name;";

 $data['response']=$this->user_model->run_query($sql);

$data['total']=  $data['response']->num_rows();



$data['mnu']='cour';



$this->load->view('admin/courses',$data);



}



// ---------------------------------------------



public function new_course_sub() {

 $this->is_login();



 $data['course_name']=strip_tags(ucwords(trim($this->input->post('course_name'))));

 if($this->user_model->insertRow('cc_courses', $data))

   $this->session->set_flashdata('messagePr', ' Success! New Courses Created Successfully..!
' );

   else

   $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



redirect( base_url().'admin/courses', 'refresh');

}



// -------------------------------------------------



public function delete_course($id='') {

     $this->is_login();

     $sql="Delete FROM `cc_courses` where md5(c_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql))

       $this->session->set_flashdata('messagePr', ' Success! Course Deleted Successfully..!
' );

       else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect( base_url().'admin/courses', 'refresh');

 }



// ******************************************



public function edit_subject_sub($subjid='') {

 $this->is_login();

 $data['subject_name']=strip_tags(strtoupper(trim($this->input->post('subject_name'))));
 $data['unm']=strip_tags(trim($this->input->post('cunm')));
 $data['pwd']=strip_tags(trim($this->input->post('cpwd')));
 $data['status']=strip_tags(trim($this->input->post('status')));

 if($this->user_model->updateRow('cc_subjects', 'md5(subj_id)', $subjid, $data))

   $this->session->set_flashdata('messagePr', ' Success! Collage/Institute Updated Successfully..!
' );

   else

   $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



redirect( base_url().'admin/exam_subjects', 'refresh');



}

// ******************************************



public function exam_subjects($id='') {

 $this->is_login();
$data['res']='';
if($id!=''){
 $data['res']=$this->user_model->getDataByid('cc_subjects', 'md5(subj_id)', $id);
}

 $sql="SELECT * FROM `cc_subjects` order by subject_name;";
 $data['response']=$this->user_model->run_query($sql);
$data['total']=  $data['response']->num_rows();



$data['tot_qus']=$this->user_model->getValueQry("SELECT count(*) as val FROM `cc_questions` ");

$data['mnu']='subj';



$this->load->view('admin/exam_subjects',$data);



}



// ---------------------------------------------



public function new_subject_sub() {

 $this->is_login();



 $data['subject_name']=strip_tags(strtoupper(trim($this->input->post('subject_name'))));
 $data['unm']=strip_tags(strtoupper(trim($this->input->post('cunm'))));
 $data['pwd']=strip_tags(strtoupper(trim($this->input->post('cpwd'))));

 if($this->user_model->insertRow('cc_subjects', $data))

   $this->session->set_flashdata('messagePr', ' Success! New Collage/Institute Created Successfully..!
' );

   else

   $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



redirect( base_url().'admin/exam_subjects', 'refresh');

}



// -------------------------------------------------



public function delete_subject($id='') {

     $this->is_login();

     $sql="Delete FROM `cc_subjects` where md5(subj_id) = '$id' limit 1;";

     if($this->user_model->run_query($sql)) {

       $this->user_model->delete_id('cc_topics' , 'md5(subj_id)', $id);

       $this->session->set_flashdata('messagePr', ' Success! Course Deleted Successfully..!
' );

     } else

       $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );



     redirect( base_url().'admin/exam_subjects', 'refresh');

 }



 // ******************************************



 public function subject_topics($id='', $subjnm='') {

      $this->is_login();

      $data['res']='';

      $sqry='';
      if($id!='' && $subjnm=='') {

        $sql2="SELECT * FROM `cc_topics` where md5(topic_id) = '$id';";

        $resp=$this->user_model->run_query($sql2);

        foreach ($resp->result() as $data['res']);

      }


      if($id!=''  && $subjnm!='')
      $sqry=" Where subj_id = '$id' ";


      $sql="SELECT * FROM `cc_topics` $sqry order by subj_id, topic_name asc;";

      $data['response']=$this->user_model->run_query($sql);

     $data['total']=  $data['response']->num_rows();

     $data['mnu']='topi';


     $data['subj_id']=$id;
     $this->load->view('admin/subject_topics',$data);

 }



 // ----------------------------------------------



 public function subject_topic_sub() {

  $this->is_login();



  $data['topic_name']=strip_tags(trim($this->input->post('topic_name')));

 // $data['subj_id']=strip_tags(trim($this->input->post('subj_id')));

  $data['max_marks']=strip_tags(trim($this->input->post('max_marks')));
  $data['exam_ques']=strip_tags(trim($this->input->post('exam_ques')));


         if($data['topic_name'] != '' ){

           if($this->user_model->insertRow('cc_topics', $data))

             $this->session->set_flashdata('messagePr', ' Success! Subject Topic Created Successfully..!
' );

             else

             $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

          }

          redirect( base_url().'admin/subject_topics/', 'refresh');

 }



 // ----------------------------------------------



 public function update_subject_topic($id='') {

  $this->is_login();



  $data['topic_name']=strip_tags(trim($this->input->post('topic_name')));

//  $data['subj_id']=strip_tags(trim($this->input->post('subj_id')));

  $data['max_marks']=strip_tags(trim($this->input->post('max_marks')));
  $data['exam_ques']=strip_tags(trim($this->input->post('exam_ques')));


         if($data['topic_name'] != '' && $id != ''){

           if($this->user_model->updateRow('cc_topics', 'md5(topic_id)', $id, $data))

             $this->session->set_flashdata('messagePr', ' Success! Subject Topic Updated Successfully..!
' );

             else

             $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

          }



          redirect( base_url().'admin/subject_topics', 'refresh');

 }



 // -------------------------------------------



 public function delete_subject_topic($id='') {

   $this->is_login();



      if($id != '') {

       $this->user_model->delete_id('cc_topics' , 'md5(topic_id)', $id);

         $this->session->set_flashdata('messagePr', ' Success! Subject Topic Deleted Successfully..!
' );

     }



     redirect(base_url().'admin/subject_topics/', 'refresh');

 }



 // *********************************************





 public function home_page_slider() {

  $this->is_login();



  $sql="SELECT * FROM `cc_home_slides` order by sort_id;";

  $data['response']=$this->user_model->run_query($sql);

  $data['total']=  $data['response']->num_rows();



 $data['mnu']='slid';



 $this->load->view('admin/home_page_slider',$data);



 }



// ----------------------------------------------



public function home_page_slider_sub() {

 $this->is_login();



// --------- for inserting img

  foreach($_FILES as $name => $fileInfo) {

        if(!empty($_FILES[$name]['size'])){

       $filename=$_FILES[$name]['name'];

     $exp=explode('.', $filename);

     $ext=strtolower(end($exp));

             if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){



               $newname=  rand(1,999).'_'.time().".".$ext;

               $tmpname= $_FILES[$name]['tmp_name'];



                if(move_uploaded_file($tmpname,"media/slides/".$newname)) {

                $data['slide_url']=$newname;

                $this->user_model->insertRow('cc_home_slides', $data);

              }

            }

      }

    }



}



// -------------------------------------------



public function delete_home_page_slider($id='', $nm='') {

  $this->is_login();



     if($id != '' && $nm != '') {

      $this->user_model->delete_id('cc_home_slides' , 'md5(slide_id)', $id);

      $file="media/slides/".$nm;

        unlink($file);

        $this->session->set_flashdata('messagePr', ' Success! Slide Deleted Successfully..!
' );

    }



    redirect(base_url().'admin/home_page_slider', 'refresh');

}



// ******************************************





public function batches($id='', $filter='') {

     $this->is_login();

     $data['res']='';

     if($id!='' && $filter=='') {

       $sql2="SELECT * FROM `cc_batches` where md5(batch_id) = '$id';";

       $resp=$this->user_model->run_query($sql2);

       foreach ($resp->result() as $data['res']);

     }

      $sub_qry = "";
     if($id!='' && $filter!='') 
      $sub_qry = " WHERE course_id = '$id' ";

     $sql="SELECT * FROM `cc_batches` $sub_qry order by post_date desc;";

     $data['response']=$this->user_model->run_query($sql);

    $data['total']=  $data['response']->num_rows();

    $data['mnu']='batc';
    $data['subj_id']=$id;


    $this->load->view('admin/batches',$data);

}



// ----------------------------------------------



public function new_batch_sub() {

 $this->is_login();


 $data['course_id']=strip_tags(trim($this->input->post('course_id')));

 $data['batch_name']=strip_tags(trim($this->input->post('batch_name')));

// $data['test_id']=strip_tags(trim($this->input->post('test_id')));

 // $data['status']=strip_tags(trim($this->input->post('status')));



        if($data['batch_name'] != '' ){

          if($this->user_model->insertRow('cc_batches', $data))

            $this->session->set_flashdata('messagePr', ' Success! New Batch Created Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/batches', 'refresh');

}



// ----------------------------------------------



public function update_batch($id='') {

 $this->is_login();

 $data['course_id']=strip_tags(trim($this->input->post('course_id')));

 $data['batch_name']=strip_tags(trim($this->input->post('batch_name')));

 $data['test_id']=strip_tags(trim($this->input->post('test_id')));

 $data['status']=strip_tags(trim($this->input->post('status')));




        if($data['batch_name'] != '' && $id != ''){

          if($this->user_model->updateRow('cc_batches', 'md5(batch_id)', $id, $data))

            $this->session->set_flashdata('messagePr', ' Success! Batch Details Updated Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/batches', 'refresh');

}



// -------------------------------------------


public function delete_batch($id='') {

  $this->is_login();


     if($id != '') {

      $this->user_model->delete_id('cc_batches' , 'md5(batch_id)', $id);

        $this->session->set_flashdata('messagePr', ' Success! Batch Deleted Successfully..!
' );

    }

    redirect(base_url().'admin/batches', 'refresh');

}



// ******************************************



public function exam_results($id='') {

     $this->is_login();

     $data['res']='';

     if($id!='') {

       $sql2="SELECT * FROM `cc_results` where md5(res_id) = '$id';";

       $resp=$this->user_model->run_query($sql2);

       foreach ($resp->result() as $data['res']);

     }



     $sql="SELECT * FROM `cc_results` order by post_date desc;";

     $data['response']=$this->user_model->run_query($sql);

    $data['total']=  $data['response']->num_rows();



    $data['mnu']='resu';



    $this->load->view('admin/exam_results',$data);

}



// ----------------------------------------------



public function exam_result_sub() {

 $this->is_login();



 $data['result_title']=strip_tags(trim($this->input->post('result_title')));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));

 $data['status']=strip_tags(trim($this->input->post('status')));



        if($data['result_title'] != '' ){

          if($this->user_model->insertRow('cc_results', $data))

            $this->session->set_flashdata('messagePr', ' Success! Result Notification Created Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/exam_results', 'refresh');

}



// ----------------------------------------------



public function update_exam_result($id='') {

 $this->is_login();



 $data['result_title']=strip_tags(trim($this->input->post('result_title')));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));

 $data['status']=strip_tags(trim($this->input->post('status')));



        if($data['result_title'] != '' && $id != ''){

          if($this->user_model->updateRow('cc_results', 'md5(res_id)', $id, $data))

            $this->session->set_flashdata('messagePr', ' Success! Result Notification Updated Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/exam_results', 'refresh');

}



// -------------------------------------------



public function delete_exam_result($id='') {

  $this->is_login();



     if($id != '') {

      $this->user_model->delete_id('cc_results' , 'md5(res_id)', $id);

        $this->session->set_flashdata('messagePr', ' Success! 1 Result Deleted Successfully..!
' );

    }



    redirect(base_url().'admin/exam_results', 'refresh');

}



// *********************************************



public function job_notifications($id='') {

     $this->is_login();

     $data['res']='';

     if($id!='') {

       $sql2="SELECT * FROM `cc_notifications` where md5(noti_id) = '$id';";

       $resp=$this->user_model->run_query($sql2);

       foreach ($resp->result() as $data['res']);

     }



     $sql="SELECT * FROM `cc_notifications` order by post_date desc;";

     $data['response']=$this->user_model->run_query($sql);

    $data['total']=  $data['response']->num_rows();



    $data['mnu']='noti';



    $this->load->view('admin/job_notifications',$data);

}



// ----------------------------------------------



public function job_notification_sub() {

 $this->is_login();



 $data['noti_title']=strip_tags(trim($this->input->post('noti_title')));

 $data['noti_url']=strip_tags(trim($this->input->post('noti_url')));

 $data['status']=strip_tags(trim($this->input->post('status')));

 $data['job_type']=strip_tags(trim($this->input->post('job_type')));



        if($data['noti_title'] != '' ){

          if($this->user_model->insertRow('cc_notifications', $data))

            $this->session->set_flashdata('messagePr', ' Success! Notification Created Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/job_notifications', 'refresh');

}



// ----------------------------------------------



public function update_job_notification($id='') {

 $this->is_login();



 $data['noti_title']=strip_tags(trim($this->input->post('noti_title')));

 $data['noti_url']=strip_tags(trim($this->input->post('noti_url')));

 $data['status']=strip_tags(trim($this->input->post('status')));

 $data['job_type']=strip_tags(trim($this->input->post('job_type')));



        if($data['noti_title'] != '' && $id != ''){

          if($this->user_model->updateRow('cc_notifications', 'md5(noti_id)', $id, $data))

            $this->session->set_flashdata('messagePr', ' Success! Notification Updated Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/job_notifications', 'refresh');

}



// -------------------------------------------



public function delete_job_notification($id='') {

  $this->is_login();



     if($id != '') {

      $this->user_model->delete_id('cc_notifications' , 'md5(noti_id)', $id);

        $this->session->set_flashdata('messagePr', ' Success! Notification Deleted Successfully..!
' );

    }



    redirect(base_url().'admin/job_notifications', 'refresh');

}



// ******************************************



public function flash_news($id='') {

     $this->is_login();

     $data['res']='';

     if($id!='') {

       $sql2="SELECT * FROM `cc_flash_news` where md5(news_id) = '$id';";

       $resp=$this->user_model->run_query($sql2);

       foreach ($resp->result() as $data['res']);

     }



     $sql="SELECT * FROM `cc_flash_news` order by start_date desc;";

     $data['response']=$this->user_model->run_query($sql);

    $data['total']=  $data['response']->num_rows();



    $data['mnu']='flas';



    $this->load->view('admin/flash_news',$data);

}



// ----------------------------------------------



public function new_flash_news_sub() {

 $this->is_login();



 $data['news_title']=strip_tags(strtoupper(trim($this->input->post('news_title'))));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));

 $data['start_date']=strip_tags(trim($this->input->post('start_date')));

 $data['end_date']=strip_tags(trim($this->input->post('end_date')));



        if($data['news_title'] != '' ){

          if($this->user_model->insertRow('cc_flash_news', $data))

            $this->session->set_flashdata('messagePr', ' Success! Flash News Created Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/flash_news', 'refresh');

}



// ----------------------------------------------



public function update_flash_news($id='') {

 $this->is_login();



 $data['news_title']=strip_tags(trim($this->input->post('news_title')));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));

 $data['start_date']=strip_tags(trim($this->input->post('start_date')));

 $data['end_date']=strip_tags(trim($this->input->post('end_date')));



        if($data['news_title'] != '' && $id != ''){

          if($this->user_model->updateRow('cc_flash_news', 'md5(news_id)', $id, $data))

            $this->session->set_flashdata('messagePr', ' Success! Flash News Updated Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/flash_news', 'refresh');

}



// -------------------------------------------



public function delete_flash_news($id='') {

  $this->is_login();



     if($id != '') {

      $this->user_model->delete_id('cc_flash_news' , 'md5(news_id)', $id);

        $this->session->set_flashdata('messagePr', ' Success! Flash News Deleted Successfully..!
' );

    }



    redirect(base_url().'admin/flash_news', 'refresh');

}



// ******************************************



public function useful_links($id='') {

     $this->is_login();

     $data['res']='';

     if($id!='') {

       $sql2="SELECT * FROM `cc_useful_links` where md5(link_id) = '$id';";

       $resp=$this->user_model->run_query($sql2);

       foreach ($resp->result() as $data['res']);

     }



     $sql="SELECT * FROM `cc_useful_links` order by link_id desc;";

     $data['response']=$this->user_model->run_query($sql);

    $data['total']=  $data['response']->num_rows();



    $data['mnu']='usef';



    $this->load->view('admin/useful_links',$data);

}



// ----------------------------------------------



public function new_useful_link_sub() {

 $this->is_login();



 $data['link_title']=strip_tags(trim($this->input->post('link_title')));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));



        if($data['link_title'] != '' ){

          if($this->user_model->insertRow('cc_useful_links', $data))

            $this->session->set_flashdata('messagePr', ' Success! Useful Link Created Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/useful_links', 'refresh');

}



// ----------------------------------------------



public function update_useful_link($id='') {

 $this->is_login();



 $data['link_title']=strip_tags(trim($this->input->post('link_title')));

 $data['link_url']=strip_tags(trim($this->input->post('link_url')));



        if($data['link_title'] != '' && $id != ''){

          if($this->user_model->updateRow('cc_useful_links', 'md5(link_id)', $id, $data))

            $this->session->set_flashdata('messagePr', ' Success! Useful Link Updated Successfully..!
' );

            else

            $this->session->set_flashdata('messagePr', ' Failed! Please Try Again..!
' );

         }



         redirect( base_url().'admin/useful_links', 'refresh');

}



// -------------------------------------------



public function delete_useful_link($id='') {

  $this->is_login();



     if($id != '') {

      $this->user_model->delete_id('cc_useful_links' , 'md5(link_id)', $id);

        $this->session->set_flashdata('messagePr', ' Success! 1 Useful Link Deleted Successfully..!
' );

    }



    redirect(base_url().'admin/useful_links', 'refresh');

}

// ******************************************

public function download_file($filenm='', $exldata='') {

  if($filenm!='' && count($exldata)) {
$export_data=$exldata;
//print_r($export_data);
if ($export_data) {
    function filterData(&$str) {
        $str = preg_replace("/\t/", "\\t", $str);
        $str = preg_replace("/\r?\n/", "\\n", $str);
        if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
    }
 
    // headers for download
    header("Content-Disposition: attachment; filename=\"$filenm\"");
    header("Content-Type: application/vnd.ms-excel");
 
    foreach($export_data as $row) {
        // filter data
        array_walk($row, 'filterData');
        echo implode("\t", array_values($row)) . "\n";
    }
 
 }
}
  return;
}



// ******************************************



public function login() {

    $this->session->unset_userdata('admin_data');

    $data='';

  $this->load->view('admin/index',$data);

}



// *******************************************



   public function login_auth(){

       $return = $this->user_model->auth_admin();



       if(empty($return) || $return == 'not_varified') {

          $this->session->set_flashdata("messagePr", ' Invalid Login Credentials..!
');

          redirect( base_url().'admin/login', 'refresh' );

       }

             $this->session->set_userdata('admin_data',$return);

             $admin_id = $this->session->userdata('admin_data')[0]->a_id;

             $urole = $this->session->userdata('admin_data')[0]->role;

             $dt = date('Y-m-d H:i:s');

             $qry="update cc_admin set visits = (visits+1), last_login = '$dt' WHERE a_id = '$admin_id';";

             $this->user_model->run_query($qry);



           if($urole === 'Admin')

           redirect(base_url().'admin/dashboard', 'refresh');

           else if($urole === 'Employee')

           redirect(base_url().'employee/dashboard', 'refresh');

   }





// *******************************************



     public function is_login(){

            if(!empty($this->session->userdata('admin_data')[0]->a_id)){

                return true;

            } else {

               redirect( base_url().'admin/login', 'refresh');

            }

  }



  // ===========================================================



    /**

     * This function is used to logout user

     */

   public function logout(){

       $this->session->unset_userdata('admin_data');

  //     $this->session->unset_userdata('emp_data');

       redirect( base_url().'admin/login', 'refresh');

   }



  //  ****************==  Jquery ===****************************





}

Jquery and Ajax get post sample method functions

2019-08-30T16:08:00.004+05:30

// =========  ****************  ================

// ============= to set add new qus: txt/img =========



function set_qbox(qt){

  if(qt === 'T') {

    document.getElementById('Tqbox').style.display = 'block';

    document.getElementById('Iqbox').style.display = 'none';

    document.getElementById('t1').value = 'T';

  } else {

    document.getElementById('Iqbox').style.display = 'block';

    document.getElementById('Tqbox').style.display = 'none';

    document.getElementById('t2').value = 'I';

  }

}



// ============= to get topics with subj_id ======



function get_stopics(subj){

$(".tcls").remove();

  $.get(window.site_burl+"jqfunctions/get_topics/",{subj_id:subj},function(response){

                   if(response){

                        $(".tcls").remove();

                        $("#topic").append(response);

                   }

                });

}



// ============= to get topics2 with subj_id =======



function get_stopics2(subj){

$(".tcls").remove();

  $.get(window.site_burl+"jqfunctions/get_topics/",{subj_id:subj},function(response){

                    if(response){

                        $(".tcls").remove();

                        $("#topic2").append(response);

                    }

                });

}



// ============= to update question =======



function updt_ques(qid, col, val){

  $.get(window.site_burl+"jqfunctions/updt_ques/",{qid:qid, col:col, val:val},function(response){

                    if(response){

                      //alert(response);

                    }

                });

}



// ************** to get batches with course_id*******************



function get_cbatches(subj){

$(".tcls").remove();

  $.get(window.site_burl+"jqfunctions/get_cbatches/",{subj_id:subj},function(response){

                   if(response){

                        $(".tcls").remove();

                        $("#batch").append(response);

                   }

                });

}

codeignator model sample method statements

2019-08-30T16:04:00.001+05:30

Calling model user define ganesh funs:::-

****************************************

To load view page:

==================

$data='Array values';

$this->load->view('admin/users', $data);

----------------------------------



To redirect some page:

======================

           redirect(base_url().'admin/dashboard', refresh);

----------------------------------



To Fetch data:

======================

    $sql1="SELECT * FROM `users` WHERE md5(id) = '$id' AND status <> 'DONE';";

     $resp1=$this->user_model->run_query($sql1);

     if($resp1->num_rows()) {

      foreach ($resp1->result() as $row)

  // print row data;

 }

--------------------------



To insert data Row:

===================

            $this->user_model->insertRow('users', $data);



------------------------------



To update data Row:

=================

$this->user_model->updateRow('table_name', 'where_field', $where_value, $array_values);

-----------------------------



To Delete Data Row:

===============

$this->user_model->delete_id('table_name', 'where_field', $where_value, $array_values);



--------------------------------------

To Send Email Message:

=======================

$this->user_model->send_email_msg($fromemail, $toemail, $Subject, $emailmsg);



--------------------------------------



To Get Count:

=============

$data['tot_res']= $this->user_model->getValueQry("SELECT count(*) as val FROM `orders` WHERE status = 'Active'");

---------------------------------



To upload file:

===================

      // --------- for inserting Qfile

         foreach($_FILES as $name => $fileInfo) {

               if(!empty($_FILES[$name]['size'])){

              $filename=$_FILES[$name]['name'];

            $exp=explode('.', $filename);

            $ext=strtolower(end($exp));



                  if($name === 'photo') {

                    if($ext === 'jpeg' || $ext === 'jpg' || $ext === 'png'){



                      $newname=  time()."_".$filename;

                      $tmpname= $_FILES[$name]['tmp_name'];



                       if(move_uploaded_file($tmpname,"media/photos/".$newname)) {

                       $data['photo']=$newname;

                 //      $this->user_model->updateRow('tnm', 'trf_id', $trf_id, $ddoc);

                     }

                   }

                 }

}}

------------------------------------------



To Set Session Data:

====================

             $this->session->set_userdata('admin_data',$return);

-------------------------------



To get/print session value:

=============================

             $admin_id = $this->session->admin_data->id;

-------------------------------



To set onetime session message:

=================================

                 $this->session->set_flashdata("messagePr", '<div class="notification error closeable"><p><i class="fa fa-exclamation-triangle" aria-hidden="true"></i> Login Failed.. Please try again..!</p><a class="close" href="#"></a></div>');

-------------------------------------



To print one time session message:

=================================

echo $this->session->flashdata('messagePr');

--------------------------------------------



To unset session data:

======================

$this->session->unset_userdata('admin_data');

---------------------------------

Java Exceptions & Assertions ( Errors, Exceptions, Assertions)

2014-11-06T15:49:00.001+05:30

Java Exceptions & Assertions ( Errors, Exceptions, Assertions). Java Exception Hierarchy. An Error is a subclass of Throwable that indicates serious problems that a reasonable application should not try to catch. Using try and catch examples.

Visit and Watch More:

YouTube: http://goo.gl/kkUqxd

2014-09-03T21:09:00.004+05:30

Why to learn the basic HTML CSS JS PHP MySql XML Ajax are the main Web Scripting to Develop Static or Dynamic Web Applications/websites.

YouTube: http://goo.gl/kkUqxd

WebSite: www.helpmeboss.com