<?
session_start();
/***********************************
 opsDEV

Copyrighted by OPS Corporation, Japan
  (c) 2005

**************************************/
define ('ocDevPath', (dirname(__FILE__)));
 
define ('ocUserTemplatePath',ocDevPath."/templates/default/en");

define ('ocLanguage','en');
define ('ocLanguageCode','ja');
define ('ocMBLanguage','Japanese'); 
define ('ocCharSet','utf-8');
 

$_oc_form_hidden_variables = array("system" => "opsDev");


require_once ocDevPath ."/libs/functions/ocCommon.php"; 
require_once ocDevPath ."/libs/classes/ocTemplate.php";
require_once ocDevPath ."/libs/classes/ocDatabase.php"; 
require_once ocDevPath ."/libs/classes/ocPaging.php";

 
$ocAT = new ocTemplate();
$ocAT->template_folder = ocUserTemplatePath;
require_safe( ocUserTemplatePath ."/codes/lang.codes.php");
 

/*
The page specific functions goes here....
*/
$stage = $_GET['stage'];
if ($_POST['stage']) {$stage = $_POST['stage'];}
$stage *= 1;
$ocAT->ocSetTopLevelTemplate('register.layout');
          $company=$_POST['company']; 
          $email=$_POST['email'];
          $address=$_POST['address'];
          $city=$_POST['city'];
          $state=$_POST['state'];
          $zip=$_POST['zip'];
          $country=$_POST['country'];
          $phone=$_POST['phone'];
          $url=$_POST['url'];
          $description=$_POST['description'];
           
          $project_name=$_POST['project_name']; 
          $proj_url=$_POST['proj_url'];
          $proj_summery=$_POST['proj_summery'];
          $tools=$_POST['tools'];
          $ctools=$_POST['ctools'];
          $prj_due=$_POST['prj_due'];
          $proj_compsites=$_POST['proj_compsites'];


          $feature=$_POST['txtfeature'];
          $ocd = new ocDatabase();
          
           
switch($stage)
{
     case 0: //"company_register":
           ocAddHiddenVar("project_name" ,$_POST['project_name']); 
           ocAddHiddenVar("proj_url" , $_POST['proj_url']); 
           ocAddHiddenVar("proj_summery" , $_POST['proj_summery']); 
           ocAddHiddenVar("tools" , $_POST['tools']); 
           ocAddHiddenVar("ctools" , $_POST['ctools']); 
           ocAddHiddenVar("prj_due" , $_POST['prj_due']); 
           ocAddHiddenVar("proj_compsites" , $_POST['proj_compsites']); 
     
          $ocAT->ocLoadDynamicTemplate("register.company");
          break;
     case 1: //"project_register":
          //he already entered comapny info 
           ocAddHiddenVar("company" ,$_POST['company']); 
           ocAddHiddenVar("password_1" , $_POST['password_1']); 
           ocAddHiddenVar("email" , $_POST['email']); 
           ocAddHiddenVar("address" , $_POST['address']); 
           ocAddHiddenVar("city" , $_POST['city']); 
           ocAddHiddenVar("state" , $_POST['state']); 
           ocAddHiddenVar("zip" , $_POST['zip']); 
           ocAddHiddenVar("country" , $_POST['country']); 
           ocAddHiddenVar("phone" , $_POST['phone']); 
           ocAddHiddenVar("url" , $_POST['url']); 
           ocAddHiddenVar("description" , $_POST['description']); 
            
            
          $sql="SELECT `company` from `company` where `company`='$company'";
          
          $ocd->dbQuery($sql);
          if($ocd->numberOfRows()>0)
          {
            $_oc_form_hidden_variables = array("system" => "opsDev");//reset
            // $ocAT->ocLoadDynamicTemplate("register.msg"); 
            $error_code = 1;
            $ocAT->ocLoadDynamicTemplate("register.error"); 
            $ocAT->ocLoadDynamicTemplate("register.company");
          }
         
          else
          {
            //check email
            $sql="SELECT `email` from `company` where `email`='$email'";
            $ocd->dbQuery($sql);
            if($ocd->numberOfRows()>0)
            {
                  $_oc_form_hidden_variables = array("system" => "opsDev");//reset
                  $error_code = 2;//email exist
                  $ocAT->ocLoadDynamicTemplate("register.error"); 
                  $ocAT->ocLoadDynamicTemplate("register.company");
            }
         
            else
            {
                   $date=date('Y-m-d H:i:s');
                      //company
                      $sql="INSERT INTO `company` (`company` , `password` , `email` , `address` , `city` , `state` , `zip` , `country` , `phone` , `url` , `date_reg` , `description` )
                            VALUES ( '$company','$password_1','$email','$address','$city','$state','$zip','$country','$phone','$url','$date','$description')";
                      $ocd->dbQuery($sql);
                      $comp_id=$ocd->insertId();
                  ocAddHiddenVar("comp_id" , $comp_id); 
                  $ocAT->ocLoadDynamicTemplate("register.project");
            }
          }
   
          
          break;
     case 2://"project_features":
           ocAddHiddenVar("company" ,$_POST['company']); 
           ocAddHiddenVar("password_1" , $_POST['password_1']); 
           ocAddHiddenVar("email" , $_POST['email']); 
           ocAddHiddenVar("address" , $_POST['address']); 
           ocAddHiddenVar("city" , $_POST['city']); 
           ocAddHiddenVar("state" , $_POST['state']); 
           ocAddHiddenVar("zip" , $_POST['zip']); 
           ocAddHiddenVar("country" , $_POST['country']); 
           ocAddHiddenVar("phone" , $_POST['phone']); 
           ocAddHiddenVar("url" , $_POST['url']); 
           ocAddHiddenVar("description" , $_POST['description']); 
           ocAddHiddenVar("project_name" ,$_POST['project_name']); 
           ocAddHiddenVar("proj_url" , $_POST['proj_url']); 
           ocAddHiddenVar("proj_summery" , $_POST['proj_summery']); 
           ocAddHiddenVar("tools" , $_POST['tools']); 
           ocAddHiddenVar("ctools" , $_POST['ctools']); 
           ocAddHiddenVar("prj_due" , $_POST['prj_due']); 
           ocAddHiddenVar("proj_compsites" , $_POST['proj_compsites']); 
            ocAddHiddenVar("comp_id" , $_POST['comp_id']); 
            $ocAT->ocLoadDynamicTemplate("register.estimates");
          break;
     case 3://"success":

      $date=date('Y-m-d H:i:s');
          //project
          //tools
          $tools_str='';
          if ($tools==1){$tools_str='0';}
          else
           {
            for($i=0;$i<count($ctools);$i++)
            {
             $tools_str=$tools_str.$ctools[$i]."\n";
            }
            
           }
          $sql="INSERT INTO `project` (`company` , `name` , `url` , `summery` , `languages` , `phase` , `project_due` , `comp_sites` )
                VALUES ( '$comp_id','$project_name','$proj_url','$proj_summery','$tools_str','0','$prj_due','$proj_compsites')";
          $ocd->dbQuery($sql);
          $prj_id=$ocd->insertId();
              //update project log
              $date=date("Y-m-d H:i:s");
              $sql="INSERT INTO `project_log`(`project`,`date`,`notes`) values('$prj_id','$date','New project placed for estimation')";
          $ocd->dbQuery($sql);
          //features
          # $str_feature='';
          # for($i=0;$i<count($feature);$i++)
          # {
            # $str_feature=$str_feature.$feature[$i]."\n";
          # }
          # $sql="INSERT INTO `project_features`(`project`,`feature`) VALUES('$prj_id','$str_feature')";
          # $ocd->dbQuery($sql);
          # $str="project 	business_nature 	project_type 	users 	application_type 	what_app_does 	user_top3 	front_end 	site_model 	technical_requirements_type 	technical_requirements 	search_engine_placement 	comments 	top_3_web_requirements 	budget 	how_serious 	timeframe 	found_taoti_by";
          if (count($business_nature)<1)  {
            $business_nature ="";
          }
          else  {
            $business_nature = join ($business_nature," ");
          }
          
          if (count($application_type)<1)  {
            $application_type = "";
          }
          else {
            $application_type = join ($application_type," ");
          }
          
          if (count($how_serious)<1)  {
            $how_serious = "";
          }
          else  {
            $how_serious = join ($how_serious," ");
          }
          mail("support@ops.net","OPS Estimate submission","Hi\n\nThere is an estimate request placed in OPS.net estimate request form .\n\n Please login to view more detauls.\n direct link is http://www.ops.net/estimate/admin/index.php?prj_id={$prj_id}&stage=6\n\nEsimate System");
          mail("hari@ops.net","OPS Estimate submission","Hi\n\nThere is an estimate request placed in OPS.net estimate request form .\n\n Please login to view more detauls.\n direct link is http://www.ops.net/estimate/admin/index.php?prj_id={$prj_id}&stage=6\n\nEsimate System");
          $sql="INSERT INTO `project_adv_settings` (`project`, `business_nature`, `project_type`, 
          `users`, `application_type`, `what_app_does`, `user_top3`, `front_end`, `site_model`,  `search_engine_placement`, 
          `comments`, `top_3_web_requirements`, `budget`, `how_serious`, `timeframe`,`questions`,
          `other_comments`, `found_taoti_by`)
                VALUES ( '$prj_id','$business_nature', '$project_type', '$users', '$application_type', 
                '$what_app_does', '$user_top3', '$front_end', '$site_model', '$search_engine_placement', '$comments', '$top_3_web_requirements',
                '$budget', '$how_serious', '$timeframe', '$questions', '$other_comments', '$found_taoti_by')";

          $ocd->dbQuery($sql);
          $ocAT->ocLoadDynamicTemplate("register.thank");
         // header("location:login.php");
          break;
     default: 
          $ocAT->ocLoadDynamicTemplate("company.register");
          break;
}
  
$ocAT->ocLoadTemplate("footer");
$ocAT->show();

exit;
?>