File manager

File manager - Edit - /home/autoph/public_html/portal/includes/menu/masterfile/cv_views.php

Back
<?php $compCode = $user_data['company_assignment']; $checkAccess = mysql_result(mysql_query("SELECT `access_module` FROM `user_access` WHERE `uname`='$user' AND `module_code`='pRec'"),0); $id=$_GET['id']; $profilePic = mysql_result(mysql_query("SELECT `file_code` FROM `tb_images` WHERE `talent_id`='$id'"),0); $fName = mysql_result(mysql_query("SELECT `fname` FROM `talents_profile` WHERE `id`='$id'"),0); $lName = mysql_result(mysql_query("SELECT `lname` FROM `talents_profile` WHERE `id`='$id'"),0); $mName = mysql_result(mysql_query("SELECT `mname` FROM `talents_profile` WHERE `id`='$id'"),0); $alias = mysql_result(mysql_query("SELECT `alias` FROM `talents_profile` WHERE `id`='$id'"),0); $myGender = mysql_result(mysql_query("SELECT `gender` FROM `talents_profile` WHERE `id`='$id'"),0); $vheight = mysql_result(mysql_query("SELECT `height` FROM `talents_profile` WHERE `id`='$id'"),0); $vweight = mysql_result(mysql_query("SELECT `weight` FROM `talents_profile` WHERE `id`='$id'"),0); $veyes = mysql_result(mysql_query("SELECT `eyes` FROM `talents_profile` WHERE `id`='$id'"),0); $vhair = mysql_result(mysql_query("SELECT `hair` FROM `talents_profile` WHERE `id`='$id'"),0); $vbody = mysql_result(mysql_query("SELECT `body_built` FROM `talents_profile` WHERE `id`='$id'"),0); $nationality= mysql_result(mysql_query("SELECT `nationality` FROM `talents_profile` WHERE `id`='$id'"),0); $bday = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$id'"),0); $ratings= mysql_result(mysql_query("SELECT `scores` FROM `talents_profile` WHERE `id`='$id'"),0); $dateOfBirth = $bday; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); //SEND TO CLIENT WITH LINK // mail($email, 'FORD AFTERSALES SURVEY', $message, 'From: service@fordglobalcity.com'); if(isset($_POST['sendToEmail'])){ $pin =rand(62215, 91101); $myPin = (rand($pin,10241977)); $tID = $_POST['tID']; $eFNAME = $_POST['tFName']; $eLNAME = $_POST['tLName']; $eGENDER = $_POST['talentGender']; $eAGE = $_POST['talentAge']; $eHEIGHT = $_POST['talentHeight']; $eWEIghT = $_POST['talentWeight']; $passKey=$myPin; $eKEY = md5($passKey); $einOut = $_POST['inOut']; $email = $_POST['eMailAddress']; $elastName = $_POST['efirstName']; $efirstName = $_POST['slastName']; $eexpireDate = $_POST['expireDate']; $eTOKEN = md5($tID); //CHECK IF EMAIL IS VALID $link = "http://www.jason-quibilan.com/cportal/portal.php?id=".$tID."&token=".$eTOKEN; $pattern = '/^(?!(?:(?:\\x22?\\x5C[\\x00-\\x7E]\\x22?)\|(?:\\x22?[^\\x5C\\x22]\\x22?)){255,})(?!(?:(?:\\x22?\\x5C[\\x00-\\x7E]\\x22?)\|(?:\\x22?[^\\x5C\\x22]\\x22?)){65,}@)(?:(?:[\\x21\\x23-\\x27\\x2A\\x2B\\x2D\\x2F-\\x39\\x3D\\x3F\\x5E-\\x7E]+)\|(?:\\x22(?:[\\x01-\\x08\\x0B\\x0C\\x0E-\\x1F\\x21\\x23-\\x5B\\x5D-\\x7F]\|(?:\\x5C[\\x00-\\x7F]))\\x22))(?:\\.(?:(?:[\\x21\\x23-\\x27\\x2A\\x2B\\x2D\\x2F-\\x39\\x3D\\x3F\\x5E-\\x7E]+)\|(?:\\x22(?:[\\x01-\\x08\\x0B\\x0C\\x0E-\\x1F\\x21\\x23-\\x5B\\x5D-\\x7F]\|(?:\\x5C[\\x00-\\x7F]))\\x22)))@(?:(?:(?!.[^.]{64,})(?:(?:(?:xn--)?[a-z0-9]+(?:-+[a-z0-9]+)\\.){1,126}){1,}(?:(?:[a-z][a-z0-9])\|(?:(?:xn--)[a-z0-9]+))(?:-+[a-z0-9]+))\|(?:\\[(?:(?:IPv6:(?:(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){7})\|(?:(?!(?:.[a-f0-9][:\\]]){7,})(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){0,5})?::(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){0,5})?)))\|(?:(?:IPv6:(?:(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){5}:)\|(?:(?!(?:.[a-f0-9]:){5,})(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){0,3})?::(?:[a-f0-9]{1,4}(?::[a-f0-9]{1,4}){0,3}:)?)))?(?:(?:25[0-5])\|(?:2[0-4][0-9])\|(?:1[0-9]{2})\|(?:[1-9]?[0-9]))(?:\\.(?:(?:25[0-5])\|(?:2[0-4][0-9])\|(?:1[0-9]{2})\|(?:[1-9]?[0-9]))){3}))\\]))$/iD'; if (preg_match($pattern, $email) === 1) { $checkEmailIfExist = mysql_result(mysql_query("SELECT COUNT(`u_id`) FROM `c_users` WHERE `u_name`='$email'"),0); if($checkEmailIfExist > 0){ mysql_query("DELETE FROM `c_users` WHERE `u_name`='$email' AND `u_position`='client'"); } $sql="INSERT INTO `c_users` (`u_id`,`u_name`,`email`,`token`,`u_password`,`u_password2`,`expired_date`,`link`,`u_fname`,`u_lname`,`date_sent`,`created_by`,`talent_id`,`u_status`,`view_x`,`u_position`) VALUES ('','$email','$email','$eTOKEN','$eKEY','$eKEY','$eexpireDate','$link','$eFNAME','$eLNAME','$toDate','$user','$tID','1','0','client')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ //format email header //================================== $subject = "TALENTS PROFILE"; $htmlContent = ' <html> <head> <title>Welcome to CodexWorld</title> </head> <body bgcolor="white"> <h1>TALENTS INFORMATION</h1> <center><table cellspacing="0" style="border: 0px dashed gray; width: 100%;max-width:800px; height: 200px;"> <tr> <th align="center"> <div style="border:1px solid gray;background:lightgray;width:100%;padding:5px"> <img src="http://www.jason-quibilan.com/test/talentImages/'.$profilePic.'"><img> <p style="font-familty:Calibri;font-size:12px;padding:5px;">FIRST NAME: '.$eFNAME.'<br>LAST NAME: '.$eLNAME.'<br>AGE: '.$eAGE.'<br>GENDER: '.$eGENDER.'</p> <br><br>Video Profile can be viewed <a href="http://www.jason-quibilan.com/cportal/client_view.php?uname='.$emal.'&toke='.$eTOKEN.'">here</a>... </div> </td> </tr> </table></center> </body> </html> <p style="font-size:12px;color:blue;padding:5px"> Username: '.$email.'<br> Your PIN CODE: '.$myPin.'<br><br> Thank you and we hope to do more business with you in the future. You access will expire on '.$eexpireDate.' FACE-TIME INC Search & Talent Section Tel. 124-4567</p>'; //================================== // Set content-type header for sending HTML email $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; // Additional headers $headers .= 'From: aendaya@autohubgroup.com>' . "\r\n"; $headers .= 'Cc: ae.endaya@gmail.com' . "\r\n"; // Send email if(mail($email,$subject,$htmlContent,$headers)){ $sysMessage = 'Email has sent successfully.'; }else{ $sysMessage = 'Email sending fail.'; } echo "<div id='dragme' style='position:absolute;width:300px;height:150px;border:1px solid gray;z-index:999999999;background:#f6d4a5;padding:0px;text-align:left;font-family:Calibri;color:red'> <h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>E-mail Sender Status</h3>"; echo "<div style='top:2px;left:93%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div> <center><br> <p style='font-familty:Calibri;font-size:12px;'>".$sysMessage."</p> <br><a href='main_new.php?view=100&sview=911&&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0'><input type='button' value='Close' class='button'></a> </center> </div>"; } }else { echo "<div id='dragme' style='position:absolute;width:300px;height:150px;border:1px solid gray;z-index:999999999;background:#f6d4a5;padding:0px;text-align:left;font-family:Calibri;color:red'> <h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>Invalid E-mail Address</h3>"; echo "<div style='top:2px;left:93%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&mail=&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div> <center><br> <p style='font-familty:Calibri;font-size:12px;'>INValid E-mail Found...</p> </center> </div>"; } } //SEND TO EMAIL INFO if($myGender==='F'){ $gender='FEMALE'; }else{ $gender='MALE'; } if(isset($_GET['mail'])){ $tID = $_GET['id']; $filePath = mysql_result(mysql_query("SELECT `file_code` FROM `vtr` WHERE `status`='1' AND `talent_id`='$tID'"),0); $myVideoPath = 'myvtr/'.$filePath; echo "<div style='position:absolute;top:10px;left:10px;border:1px solid black;width:600px;height:500px;background:#fff;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>SEND TO E-MAIL: ".$fName." ".$lName." - VTR</h3>"; echo "<div style='top:2px;left:96%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<input type='hidden' name='tID' value='".$_GET['id']."'>"; echo "<input type='hidden' name='tFName' value='".$fName."'>"; echo "<input type='hidden' name='tLName' value='".$lName."'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>NAME OF TALENT:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='talentName' value='".$lName.", ".$fName."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' style='width:10%;background:#f4f4f4;height:25px;padding:2px;border:1px solid white;font-family:Calibri;font-size:12px;'> <table style='width:100%;border-collapse:collapse;border:1px solid white'>"; echo "<tr>"; echo "<td align='right' style='width:10%;background:#fff;height:25px;padding:2px;border:1px solid white;font-family:Calibri;font-size:12px;'>GENDER:</td>"; echo "<td style='width:20%;background:#fff;height:25px;padding:3px;border:1px solid white'> <input type='text' REQUIRED name='talentGender' value='".$gender."' style='width:100%'></td>"; echo "<td align='right' style='width:10%;background:#fff;height:25px;padding:2px;border:1px solid white;font-family:Calibri;font-size:12px;'>AGE:</td>"; echo "<td style='width:10%;background:#fff;height:25px;padding:3px;border:1px solid white'> <input type='text' REQUIRED name='talentAge' value='".$newAge."' style='width:100%'></td>"; echo "<td align='right' style='width:15%;background:#fff;height:25px;padding:2px;border:1px solid white;font-family:Calibri;font-size:12px;'>HEIGHT: (cm)</td>"; echo "<td style='width:10%;background:#fff;height:25px;padding:3px;border:1px solid white'> <input type='text' REQUIRED name='talentHeight' value='".$vheight."' style='width:100%'></td>"; echo "<td align='right' style='width:15%;background:#fff;height:25px;padding:2px;border:1px solid white;font-family:Calibri;font-size:12px;'>WEIGHT: (lbs)</td>"; echo "<td style='width:10%;background:#fff;height:25px;padding:3px;border:1px solid white'> <input type='text' REQUIRED name='talentWeight' value='".$vweight."' style='width:100%'></td>"; echo "</tr>"; echo "</table> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>NOTES:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea name='reasons' rows='1' style='width:100%'></textarea></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:14px;font-weight:bold'>RECIPIENT'S INFORMATION</td>"; echo "</tr>"; //RECEIVERS INFORMATION echo "<tr>"; echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>SELECT TYPE OF RECIPTINET</td>"; echo "<td style='width:70%;background:#fff;height:25px;padding:3px;border:none'> <select name='inOut' style='width:100%'> <option>INTERNAL</option> <option>EXTERNAL</option> </select> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>RECEIVER's E-EMAIL ADDRESS:</td>"; echo "<td style='width:70%;background:#fff;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='eMailAddress' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>RECEIVER's LAST NAME:</td>"; echo "<td style='width:0%;background:#fff;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='slastName' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>RECEIVER's FIRST NAME:</td>"; echo "<td style='width:0%;background:#fff;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='sfirstName' value='' style='width:100%'></td>"; echo "</tr>"; //echo "<tr>"; // echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>ASSIGN PASSWORD</td>"; // echo "<td style='width:0%;background:#fff;height:25px;padding:3px;border:none'> // <input type='text' REQUIRED name='passKey' value='".$myPin."' style='width:100%'></td>"; //echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#fff;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE EXPIRE</td>"; echo "<td style='width:0%;background:#fff;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='expireDate' id='datepicker' placeholder='Access Expiration Date' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#fff;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='sendToEmail' class='submit' value='SEND VIA E-MAIL' style='width:150px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; echo "</div>"; } //PLAY VTR if(isset($_GET['vtr'])){ $tID = $_GET['id']; $filePath = mysql_result(mysql_query("SELECT `file_code` FROM `vtr` WHERE `status`='1' AND `talent_id`='$tID'"),0); $myVideoPath = 'myvtr/'.$filePath; echo "<div style='position:absolute;top:10px;left:0px;border:1px solid black;width:600px;height:400px;background:#000;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>".$fName." ".$lName." - VTR</h3>"; echo "<div style='top:2px;left:96%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; ?> <video id="myVideo" width="600" height="370" controls autoplay poster="image/poster.png"> <source src="" type="video/mp4/avi/mpeg/vob/mob/vlc" /> <em>Sorry, your browser doesn't support HTML5 video.</em> </video> <?php //$videos="test.mp4"; //$videos[1]="http://somedomain2.com/video2.mp4"; //put your code here to convert $vid to $url of the video, e.g. $url=$videos; ?> <script> var vid=document.getElementById('myVideo'); vid.src='<?php echo $myVideoPath;?>'; </script> <?php echo "<div style='position:relative;width:581px;height:70px;background:white;border:1px solid black;left:-2px;padding:10px;'>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>NAME: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $fName ." ".$lName ."</b></p>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>AGE: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $newAge ."</b>      HEIGHT: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vheight."</b> cm     WEIGHT:<b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vweight." </b>lbs</p>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>NATIONALITY: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $nationality ."</b>     BUILT: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $vbody ."</b> type      EYES: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$veyes."</b> color      HAIR:<b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vhair." </b> color </p>"; echo "</div>"; echo "</div>"; } //================================= if(isset($_GET['xskilss'])){ $recID=$_GET['recID']; $xAction =$_GET['xskilss']; switch($xAction){ case 'skills': mysql_query("DELETE FROM `skills` WHERE `id`='$recID'"); break; case 'educ': mysql_query("DELETE FROM `education` WHERE `id`='$recID'"); break; case 'proj': mysql_query("DELETE FROM `projects` WHERE `id`='$recID'"); break; case 'ws': mysql_query("DELETE FROM `workshops` WHERE `id`='$recID'"); break; } echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<br><br><center><p style='font-family:Calibri;font-size:12px;'> RECORD HAS BEEN DELETED...</p> <br><br><a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center>"; echo "</div>"; } if(isset($_GET['delete'])){ $delType = $_GET['delete']; $accessType = $user_data['account_type']; if($accessType != 'ADMIN'){ secalert_new(); exit(); } switch($delType){ case 'skills': echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; $recID = $_GET['recID']; $sTitle=mysql_result(mysql_query("SELECT `title` FROM `skills` WHERE `id`='$recID'"),0); $sDesc=mysql_result(mysql_query("SELECT `description` FROM `skills` WHERE `id`='$recID'"),0); echo "<br><p style='font-family:Calibri;font-size:12px;'>Type: ".$sTitle." <br><br>Details:".$sDesc."<br><br><center>Are you sure you want to delete this record? <br><br> <a href='main_new.php?view=100&sview=911&sid=UR&xskilss=skills&view=plist&id=".$_GET['id']."&recID=".$_GET['recID']."&tab=0#id-0#'>YES </a> \| <a href=''>NO </a> </p>"; echo "</div>"; break; case 'educ': echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; $recID = $_GET['recID']; $sTitle=mysql_result(mysql_query("SELECT `level` FROM `education` WHERE `id`='$recID'"),0); $sDesc=mysql_result(mysql_query("SELECT `school` FROM `education` WHERE `id`='$recID'"),0); echo "<br><p style='font-family:Calibri;font-size:12px;'>LEVEL: ".$sTitle." <br><br>SCHOOL:".$sDesc."<br><br><center>Are you sure you want to delete this record? <br><br> <a href='main_new.php?view=100&sview=911&sid=UR&xskilss=educ&view=plist&id=".$_GET['id']."&recID=".$_GET['recID']."&tab=0#id-0#'>YES </a> \| <a href=''>NO </a> </p>"; echo "</div>"; break; case 'jobhis': echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; $recID = $_GET['recID']; $sTitle=mysql_result(mysql_query("SELECT `position` FROM `job_history` WHERE `id`='$recID'"),0); $sCompany=mysql_result(mysql_query("SELECT `company` FROM `job_history` WHERE `id`='$recID'"),0); echo "<br><p style='font-family:Calibri;font-size:12px;'>POSITION: ".$sTitle." <br><br>COMPANY:".$sCompany."<br><br><center>Are you sure you want to delete this record? <br><br> <a href='main_new.php?view=100&sview=911&sid=UR&xskilss=educ&view=plist&id=".$_GET['id']."&recID=".$_GET['recID']."&tab=0#id-0#'>YES </a> \| <a href=''>NO </a> </p>"; echo "</div>"; break; case 'proj': echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; $recID = $_GET['recID']; $sTitle=mysql_result(mysql_query("SELECT `project_code` FROM `projects` WHERE `id`='$recID'"),0); $sCompany=mysql_result(mysql_query("SELECT `product` FROM `projects` WHERE `id`='$recID'"),0); echo "<br><p style='font-family:Calibri;font-size:16px;'>PROJECT CODE: ".$sTitle." <br><br>PRODUCT: ".$sCompany."<br><center>Are you sure you want to delete this record? <br><br> <br><a href='main_new.php?view=100&sview=911&sid=UR&xskilss=proj&view=plist&id=".$_GET['id']."&recID=".$_GET['recID']."&tab=0#id-0#'>YES </a> \| <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0'>NO </a> </p>"; echo "</div>"; break; case 'ws': echo "<div class='ContinueMSG' style='position:absolute;top:200px;left:250px'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:12px;font-weight:bold;padding-left:5px;padding-top:3px;'>CONFIRM DELETE</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; $recID = $_GET['recID']; $sTitle=mysql_result(mysql_query("SELECT `title` FROM `workshops` WHERE `id`='$recID'"),0); $sCompany=mysql_result(mysql_query("SELECT `product` FROM `projects` WHERE `id`='$recID'"),0); echo "<br><p style='font-family:Calibri;font-size:16px;'>WORKSHOP TITLE: ".$sTitle." <br><br><center>Are you sure you want to delete this record? <br><br> <br><a href='main_new.php?view=100&sview=911&sid=UR&xskilss=ws&view=plist&id=".$_GET['id']."&recID=".$_GET['recID']."&tab=0#id-0#'>YES </a> \| <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0'>NO </a> </p>"; echo "</div>"; break; } } //================================= $gender = mysql_result(mysql_query("SELECT `gender` FROM `talents_profile` WHERE `id`='$id'"),0); $height = mysql_result(mysql_query("SELECT `height` FROM `talents_profile` WHERE `id`='$id'"),0); $weight = mysql_result(mysql_query("SELECT `weight` FROM `talents_profile` WHERE `id`='$id'"),0); $status = mysql_result(mysql_query("SELECT `status` FROM `talents_profile` WHERE `id`='$id'"),0); $eyes = mysql_result(mysql_query("SELECT `eyes` FROM `talents_profile` WHERE `id`='$id'"),0); $hair = mysql_result(mysql_query("SELECT `hair` FROM `talents_profile` WHERE `id`='$id'"),0); $shoeSize = mysql_result(mysql_query("SELECT `shoes` FROM `talents_profile` WHERE `id`='$id'"),0); $birthplace = mysql_result(mysql_query("SELECT `birth_place` FROM `talents_profile` WHERE `id`='$id'"),0); $nationality = mysql_result(mysql_query("SELECT `nationality` FROM `talents_profile` WHERE `id`='$id'"),0); $datehired = mysql_result(mysql_query("SELECT `date_hired` FROM `talents_profile` WHERE `id`='$id'"),0); $tin = mysql_result(mysql_query("SELECT `tin` FROM `talents_profile` WHERE `id`='$id'"),0); $religion = mysql_result(mysql_query("SELECT `religion` FROM `talents_profile` WHERE `id`='$id'"),0); $contractStart = mysql_result(mysql_query("SELECT `contract_start` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $contractEnd = mysql_result(mysql_query("SELECT `contract_end` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); //================================= $mobile = mysql_result(mysql_query("SELECT `mobile` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $landline = mysql_result(mysql_query("SELECT `landline` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $email = mysql_result(mysql_query("SELECT `pemail` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $fb = mysql_result(mysql_query("SELECT `fb` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $tw = mysql_result(mysql_query("SELECT `tw` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $ig = mysql_result(mysql_query("SELECT `ig` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $vb = mysql_result(mysql_query("SELECT `vb` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $othersocial = mysql_result(mysql_query("SELECT `vb` FROM `other_social` WHERE `id`='$id' AND `status`='1'"),0); $street = mysql_result(mysql_query("SELECT `street` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $city = mysql_result(mysql_query("SELECT `city` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $permanent_address = mysql_result(mysql_query("SELECT `permanent_address` FROM `talents_profile` WHERE `id`='$id'"),0); $permanent_city = mysql_result(mysql_query("SELECT `permanent_city` FROM `talents_profile` WHERE `id`='$id' AND `status`='1'"),0); $provincial_address = mysql_result(mysql_query("SELECT `provincial_address` FROM `talents_profile` WHERE `id`='$id'"),0); $provincial_city = mysql_result(mysql_query("SELECT `provincial_city` FROM `talents_profile` WHERE `id`='$id'"),0); //================================= echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px'>TALENTS RECORDS - ACTIVE</h3>"; echo "<div style='top:110px;left:97.5%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sid=M1&sview=100&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; //ADD ASSIGNED Projects if(isset($_GET['proj'])){ //LOAD PROJECT ENTRY FORM if(isset($_POST['updateProj'])){ $id = $_GET['id']; $dateOfBirth = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$id'"),0); $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `talents_profile` SET `age`='$newAge' WHERE `id` = '$id'"); //echo "My Age is:". $newAge; $shootdate = $_POST['shootdate']; $ratings = $_POST['ratings']; $projectCode = $_POST['projectCode']; $product = $_POST['product']; $production = $_POST['production']; $agency = $_POST['agency']; $role = $_POST['role']; $tfFee = $_POST['tfFee']; $lockOut = $_POST['tfFee']; $gComments = $_POST['gComments']; $booker = $_POST['booker']; $gComments = mysql_real_escape_string($gComments); $projectCode = mysql_real_escape_string($projectCode); $product = mysql_real_escape_string($product); $agency = mysql_real_escape_string($agency); $sql="INSERT INTO `tb_comments` (`id`,`talent_id`,`rate`,`date`,`time`,`from`,`comments`) VALUES('','$id','$ratings','$toDate','$currentTime','$user','$gComments')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } $getProfileTalent = mysql_result(mysql_query("SELECT `talent_skills` FROM `talents_profile` WHERE `id`='$id'"),0); $AddNewRole = $getProfileTalent ."".$role.","; $AddNewRole = mysql_real_escape_string($AddNewRole); mysql_query("UPDATE `talents_profile` SET `talent_skills`='$AddNewRole' WHERE `id`='$id'"); $sql="INSERT INTO `projects` (`id`,`talent_id`,`project_code`,`product`,`shoot_date`,`production`,`agency`,`tf_amount`,`lockout`,`booker`,`date`,`time`,`added_by`,`gnotes`,`role`,`ratings`) VALUES('','$id','$projectCode','$product','$shootdate','$production','$agency','$tfFee','$lockOut','$booker','$toDate','$currentTime','$user','$gComments','$role','$ratings')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div class='ContinueMSG' style='top:100px;left:150px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:5px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br>New Record Saved. ".$newAge." <br><br><a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0'><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center></div>"; } } $getAction=$_GET['proj']; switch($getAction){ case 'true': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:600px;height:480px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>ADD ASSIGNED PROJECTS</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>SHOOT DATE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED id='datepickerA' name='shootdate' value='$toDate' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>PROJECT CODE:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='projectCode' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>PRODUCTS:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='product' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>PRODUCTION:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='production' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>AGENCY:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='agency' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>T.F:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='tfFee' value='' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>LOCKOUT PERIOD:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='lockOut' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>ASSIGNED ROLE:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='role' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>BOOKER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='booker' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>PERFORMANCE RATING:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none;font-size:10px;color:gray'><input type='text' REQUIRED name='ratings' style='width:30%'> 1= Lowest, 10 Highest</td>"; echo "</tr>"; echo "<tr>"; echo "<td valign='top' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>GENERAL COMMMENT / REMARKS / NOTES</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea required name='gComments' rows='1' style='width:100%'></textarea></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='updateProj' class='submit' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; } } //ADD WORKSHOPS ENTRY if(isset($_GET['ws'])){ //LOAD PROJECT ENTRY FORM if(isset($_POST['updateWS'])){ $id = $_POST['id']; $wDate= $_POST['wDate']; $wPlace= $_POST['wPlace']; $wTitle = $_POST['wTitle']; $wFacilitator = $_POST['wFacilitator']; $wStatus = $_POST['wStatus']; $sql="INSERT INTO `workshops` (`id`,`talent_id`,`date`,`title`,`place`,`facilitator`,`completed`) VALUES('','$id','$wDate','$wTitle','$wPlace','$wFacilitator','$wStatus')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } mysql_query("UPDATE `talents_profile` SET `workshop`='YES' WHERE `id`='$id'"); } $getWS=$_GET['ws']; switch($getWS){ case 'true': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:600px;height:300px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>WORKSHOP ATTENDED</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<input type='hidden' name='id' value='".$_GET['id']."'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED id='datepickerA' name='wDate' value='$toDate' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>WORKSHOP TITLE:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='wTitle' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>FACILITATOR:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='wFacilitator' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>PLACE CONDUCTED:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='wPlace' value='' style='width:100%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>STATUS:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'> <select REQUIRED name='wStatus' style='width:100%'> <option>COMPLETED</option> <option>INCOMPLETE</option> </select> </td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='updateWS' class='submit' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; } } //ADD / UPDATE WORK HISTORY //=================================================================================================================== if(isset($_GET['jobhis'])){ if(isset($_POST['updateJobHis'])){ $id = $_GET['id']; $dates = $_POST['dates']; $datee = $_POST['datee']; $position = $_POST['position']; $company = $_POST['company']; $reasons = $_POST['reasons']; $reasons = mysql_real_escape_string($reasons); $company = mysql_real_escape_string($company); $position = mysql_real_escape_string($position); $id=$_GET['id']; $sql="INSERT INTO `job_history` (`id`,`talent_id`,`date_start`,`date_end`,`position`,`company`,`reasons`,`date_added`,`time_added`,`added_by`) VALUES('','$id','$dates','$datee','$position','$company','$reasons','$toDate','$currentTime','$user')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div class='ContinueMSG' style='top:100px;left:150px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:5px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br>New Record Saved. <br><br><a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0'><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center></div>"; } } //LOAD UPDATE FORM $getAction=$_GET['jobhis']; switch($getAction){ case 'true': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:600px;height:300px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>ADD JOB HISTORY</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>START DATE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED id='datepickerA' name='dates' value='$toDate' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE END:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='datee' id='datepicker' value='$toDate' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>POSITION:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='position' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>NAME OF COMPANY:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='company' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>REASON FOR LEAVING:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea name='reasons' style='width:100%'></textarea></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='updateJobHis' class='submit' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; } } //ADD / UPDATE SKILLS AND TALENTS //=================================================================================================================== if(isset($_GET['skills'])){ if(isset($_POST['updateSkills'])){ $id=$_GET['id']; $level = $_POST['level']; $title = $_POST['title']; $description = $_POST['description']; $date = $_POST['date']; $description = mysql_real_escape_string($description); $title = mysql_real_escape_string($title); $ptitle = mysql_result(mysql_query("SELECT `talent_skills` FROM `talents_profile` WHERE `id`='$id'"),0); $uptitle=$title.':'.$description .','.$ptitle; mysql_query("UPDATE `talents_profile` SET `update_skills`='$toDate', `talent_skills`='$uptitle' WHERE `id`='$id'"); $sql="INSERT INTO `skills` (`id`,`talent_id`,`level`,`title`,`description`,`date_added`) VALUES('','$id','$level','$title','$description','$date')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div class='ContinueMSG' style='top:100px;left:150px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:5px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br>New Record Saved. <br><br><a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0'><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> <a href='main_new.php?skills=true&view=100&sview=911&sid=UR&search=new&view=plist&id=".$_GET['id']."&tab=0#id-0'><input type='button' name='addNew' value='AddNew' style='width:80px;border-radius:5px;height:30px;'></a> </center></div>"; } } //LOAD UPDATE FORM $getAction=$_GET['skills']; switch($getAction){ case 'true': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:600px;height:300px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>TALENT PERSONAL PROFILE</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>SKILLS/TALENT/INFORMATION:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='title' value='' style='width:70%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DESCRIPTION:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea name='description' style='width:100%'></textarea></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>LEVEL:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <select name='level' style='width:70%;padding:2px;'> <Option>LOW</Option> <Option>MEDIUM</Option> <Option>HIGH</Option> </select> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='date' id='datepickerA' value='$toDate' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='updateSkills' class='submit' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; } } //EDIT/UPDATE EDUCATIONAL BACKGORUND//=================================================================================================================== if(isset($_GET['educ'])){ //SAVE EDITED EDUCATIONAL INFORMATION if(isset($_POST['updateEducation'])){ $level = $_POST['level']; $school = $_POST['school']; $course = $_POST['course']; $major = $_POST['major']; $remarks = $_POST['remarks']; $date = $_POST['date']; $remarks = mysql_real_escape_string($remarks); $school = mysql_real_escape_string($school); $course = mysql_real_escape_string($course); $major = mysql_real_escape_string($major); $id=$_GET['id']; mysql_query("UPDATE `talents_profile` SET `update_education`='$toDate` WHERE `id`='$id'"); $sql="INSERT INTO `education` (`id`,`talent_id`,`level`,`school`,`course`,`major`,`date_graduated`,`remarks`) VALUES('','$id','$level','$school','$course','$major','$date','$remarks')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div class='ContinueMSG' style='top:100px;left:150px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:5px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br>New Record Saved. <br><br><br><br><a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0'><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center></div>"; } } //LOAD UPDATE FORM $getAction=$_GET['educ']; switch($getAction){ case 'true': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:600px;height:400px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>ADD EDUCATIONAL INFO</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>LEVEL:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <select name='level' style='width:70%;padding:2px;'> <Option>ELEMENTARY</Option> <Option>HIGH SCHOOL</Option> <Option>COLLEGE</Option> <Option>MASTERAL</Option> </select> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>NAME OF SCHOOL:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='school' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>COURSE TITLE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='course' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>MAJOR / SPECIALIZATION:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='major' value='' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td valign='top' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>COURSE TITLE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea name='remarks' style='width:100%'></textarea></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE COMPLETED:</td>"; echo "<td style='width:0%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='date' id='datepickerA' value='' style='width:30%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='updateEducation' class='submit' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</table>"; echo "</div>"; } } //UPDATE CONTACT INFORMATION//=================================================================================================================== if(isset($_GET['update'])){ //SAVE EDITED DATA AFTER UPDATE IS SUBMITTED if(isset($_POST['UpdateProfile'])){ $recID = $_GET['id']; $dateOfBirth = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$recID'"),0); $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `talents_profile` SET `age`='$newAge',`update_profile`='$toDate' WHERE `id` = '$recID'"); $body = $_POST['body']; $fname = $_POST['ufname']; $lname = $_POST['ulname']; $mname = $_POST['umname']; $uhired= $_POST['uhired']; $ucontracts= $_POST['ucontracts']; $ucontracte= $_POST['ucontracte']; $nname = $_POST['ualias']; $bday= $_POST['ubday']; $ubplace = $_POST['ubplace']; $gender = $_POST['ugender']; $nationality = $_POST['unationality']; $height = $_POST['uheight']; $weight = $_POST['uweight']; $religion = $_POST['ureligion']; $tin = $_POST['utin']; $hair = $_POST['uhair']; $eyes = $_POST['ueyes']; $shoes = $_POST['ushoes']; mysql_query("UPDATE `talents_profile` SET `body_built`='$body', `date_hired`='$uhired',`contract_start`='$ucontracts',`contract_end`='$ucontracte',`fname`='$fname', `mname`='$mname',`lname`='$lname',`alias`='$nname',`gender`='$gender',`birthdate`='$bday',`birth_place`='$ubplace',`nationality`='$nationality',`religion`='$religion',`hair`='$hair',`eyes`='$eyes',`shoes`='$shoes',`height`='$uheight',`weight`='$uweight',`tin`='$tin',`update_profile`='$toDate' WHERE `id`='$recID'"); echo "<div class='ContinueMSG' style='position:absolute;top:50px;left:50px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:2px;'>RECORD UPDATE COMPLETE..</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br><br><p style='font-family:Calibri Light;font-size:12px;color:black;padding:5px;'>Records Update has been saved....</p> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' ><br><br><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center>"; echo "</div>"; } //LOAD UPDATE FORM $getAction=$_GET['update']; switch($getAction){ case 'ginfo': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:400px;height:600px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>UPDATE PERSONAL INFORMATION</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>LAST NAME:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ulname' value='".$lName."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>FIRST NAME:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ufname' value='".$fName."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>MIDDLE NAME:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='umname' value='".$mName."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>ALIAS / GENDER</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='ualias' value='".$alias."' placeholder='ALIAS' style='width:45%'> <input type='text' REQUIRED name='ugender' value='".$gender."' placeholder='GENDER' style='width:45%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>BIRTH DATE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ubday' value='".$bday."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>DATE HIRED:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='uhired' value='".$datehired."' placeholder='HIRED DATE' id='datepickerA' style='width:40%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>BIRTH PLACE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='ubplace' value='".$birthplace."' style='width:100%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>NATIONALITY:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='unationality' value='".$nationality."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>RELIGION:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ureligion' value='".$religion."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>WEIGHT / HEIGHT:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='uweight' value='".$weight."' placeholder='WEIGHT' style='width:40%'>    <input type='text' REQUIRED name='uheight' value='".$height."' placeholder='HEIGHT' style='width:40%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>CONTRACT:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='ucontracts' value='".$ucontracts."' placeholder='START' id='datepickerB' style='width:40%'>    <input type='text' REQUIRED name='ucontracte' value='".$ucontracte."' placeholder='END' id='datepickerPOS' style='width:40%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>HAIR / EYS COLOR:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='uhair' value='".$hair."' style='width:40%'>    <input type='text' REQUIRED name='ueyes' value='".$eyes."' style='width:40%'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>BODY</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <select name='body' style='width:50%;'> <option>SMALL</option> <option>MEDIUM</option> <option>LARGE</option> </select> </td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>SHOE SIZE:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'> <input type='text' REQUIRED name='ushoes' value='".$shoeSize."' style='width:50%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;'>T.I.N NUMBER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='utin' value='".$tin."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='UpdateProfile' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</tr>"; echo "</table>"; echo "</form>"; echo "</div>"; break; } } //UPDATE CONTACT INFORMATION//=================================================================================================================== if(isset($_GET['contact'])){ //SAVE EDITED DATA AFTER UPDATE IS SUBMITTED if(isset($_POST['UpdateContact'])){ $recID = $_GET['id']; $dateOfBirth = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$recID'"),0); $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `talents_profile` SET `age`='$newAge',`update_contact`='$toDate' WHERE `id` = '$recID'"); $fb = $_POST['ufb']; $ig = $_POST['uig']; $tw= $_POST['utw']; $vb= $_POST['uvb']; $othersocial= $_POST['uothersocial']; $mobile = $_POST['umobile']; $landline= $_POST['ulandline']; $homeaddress = $_POST['uhomeaddress']; $homecity = $_POST['uhomecity']; $permanentaddress = $_POST['upermanentaddress']; $permanentcity= $_POST['upermanentcity']; $provincialaddress = $_POST['uprovincialaddress']; $uprovincecity = $_POST['uprovincecity']; mysql_query("UPDATE `talents_profile` SET `street`='$homeaddress',`city`='$homecity',`permanent_address`='$permanentaddress',`permanent_city`='$permanentcity',`provincial_address`='$provincialaddress',`provincial_city`='$uprovincecity', `fb`='$fb',`tw`='$tw',`ig`='$ig',`vb`='$vb',`other_social`='$othersocial',`mobile`='$mobile',`landline`='$landline',`pemail`='$email' WHERE `id`='$recID'"); echo "<div class='ContinueMSG' style='position:absolute;top:50px;left:50px;'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:2px;'>RECORD UPDATE COMPLETE..</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' > <center>X</center> </a> </div>"; echo "<center><br><br><br><p style='font-family:Calibri Light;font-size:12px;color:black;padding:5px;'>Records Update has been saved....</p> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' ><br><br><input type='button' name='close' value='Close' style='width:80px;border-radius:5px;height:30px;'></a> </center>"; echo "</div>"; } //LOAD UPDATE FORM $getAction=$_GET['contact']; switch($getAction){ case 'gcon': echo "<div style='position:absolute;top:10px;left:100px;border:1px solid black;width:400px;height:600px;background:#f4f4f4;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>UPDATE PERSONAL INFORMATION</h3>"; echo "<div style='top:2px;left:95%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$_GET['id']."&tab=0#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<form action='' method='POST'>"; echo "<table style='width:98%;background:transparent;margin-top:5px;margin-left:5px'>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>MOBILE NUMBER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='umobile' value='".$mobile."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>LANDLINE NUMBER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ulandline' value='".$landline."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>FACEBOOK:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='ufb' value='".$fb."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>INSTAGRAM:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='uig' value='".$ig."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>TWITTER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='utw' value='".$tw."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>VIBER NUMBER:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='uvb' value='".$vb."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>OTHER SOCIAL MEDIA:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><input type='text' REQUIRED name='uothersocial' value='".$othersocial."' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>HOME ADDRESS:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea placeholder='HOME ADDRESS' REQUIRED name='uhomeaddress' style='width:100%' rows='1' style='font-family:Calibri;font-size:12px;'>".$street."</textarea> <br><input type='text' REQUIRED name='uhomecity' value='".$city."' placeholder='REGION / CITY' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>PERMANENT ADDRESS:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea placeholder='PERMANENT ADDRESS' REQUIRED name='upermanentaddress' style='width:100%' rows='1' style='font-family:Calibri;font-size:12px;'>".$permanent_address."</textarea> <br><input type='text' REQUIRED name='upermanentcity' value='".$permanent_city."' placeholder='REGION / CITY' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none;font-family:Calibri;font-size:12px;' valign='top'>PROVINCIAL ADDRESS:</td>"; echo "<td style='width:70%;background:#f4f4f4;height:25px;padding:3px;border:none'><textarea placeholder='PROVINCIAL ADDRESS' REQUIRED name='uprovincialaddress' style='width:100%' rows='1' style='font-family:Calibri;font-size:12px;'>".$provicial_address."</textarea> <br><input type='text' REQUIRED name='uprovincecity' value='".$provincial_city."' placeholder='REGION / CITY' style='width:100%'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2' align='center' style='width:30%;background:#f4f4f4;height:25px;padding:2px;border:none'><br><hr><br> <input type='submit' name='UpdateContact' value='Submit' style='width:80px;padding:10px;border-radius:5px'> </td>"; echo "</tr>"; echo "</table>"; echo "</form>"; echo "</div>"; break; } } echo "<div style='width:99.8%;border:0px solid gray;height:450px;background:#f4f4f4'>"; ?> <div style='width:98.9%;height:40px;border:1px solid lightgray;background:#f2f2f2;padding-left:10px;padding-top:3px'> <a href='main_new.php?view=100&sview=100&sid=M1&action=new&tab=0#id-0'><ABBR title='Add New Record'><img src='./images/new.png' onmouseover="this.src='images/new_.png';" onmouseout="this.src='images/new.png';" /></ABBR></a> <a href='main_new.php?view=100&sview=721&sid=ADV&action=edit&tab=0#id-0'><ABBR title='Advance Search Module'><img src='./images/filter_a.png' onmouseover="this.src='images/filter_b.png';" onmouseout="this.src='images/filter_a.png';" /></ABBR></a> <a href='face_cv_view.php?id=<?php echo $_GET['id'];?>' target='_Blank'><ABBR title='Advance Search Module'><img src='./images/cv_a.png' onmouseover="this.src='images/cv_b.png';" onmouseout="this.src='images/cv_a.png';" /></ABBR></a> <div style='position:relative;height:30px;width:600px;border:1px solid #f2f2f2;background:#f2f2f2;top:-40px;left:150px;padding-top:4px;border-left:1px solid lightgray;padding-left:30px'> <form action='' method='GET'> <input type='hidden' name='view' value='100'> <input type='hidden' name='sview' value='100'> <input type='hidden' name='tab' value='0'> <input type='hidden' name='sid' value='MS'> Search : <input type='text' name='searchBox' value='' style='padding-left:10px;width:300px;border:1px solid gray;background:white;height:30px;border-radius:5px 0px 0px 5px'> <input type='submit' name='goSearch' value='Search' style='width:70px;border:1px solid gray;height:30px;border-radius:0px 5px 5px 0px'> </form> </div> </div> <div style='width:99.3%;height:409px;border:1px solid lightgray;background:#fff;padding:2px;overflow:auto'> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> Personal Information <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'><a href='main_new.php?update=ginfo&view=100&sview=911&sid=UR&search=&view=plist&id=<?php echo $_GET['id'];?>&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Update</a></div> </div> <div style='padding:10px;height:150px;border:1px solid white;margin:0px'> <div style='float:left;position:relative;width:15%;max-width:130px;height:150px;border:1px solid gray;background:white;background-image:url("talentImages/<?php echo $profilePic;?>");background-size:100%;background-repeat:no-repeat; background-position: 50% 50%;'> <center><br><br><br><br><br><br><br><br> <a href='main_new.php?vtr=true&view=100&sview=911&sid=UR&search=&view=plist&id=<?php echo $_GET['id'];?>&tab=0#id-0' style='text-shadow:2px 2px 5px white;font-size:10px;color:black;border:1px solid lightgray;border-radius:5px;padding:2px;padding-left:5px;padding-right:5px' class='lightGradient'>Play VTR</a></center> </div> <div style='float:left;position:relative;width:80%;height:150px;border:1px solid white;margin-left:20px'> <table style='width:100%;border-collapse:collapse;'> <tr style='background:white;border:1px solid white'> <td colspan='2' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:18px;font-weight:bold;color: #65656a ;line-height:150%'>".$lName .", ". $fName ." ".$mName.".</b>";?> </td> <td colspan='2' style='width:20%;background:white;border:1px solid white;text-align:right;vertical-align:top;font-size:20px;font-family:Calibri Light'> </td> <td colspan='2' rowspan='7' style='border-radius:10px;width:15%;border:1px solid white;text-align:center;padding:5px;vertical-align:top;font-size:25px;font-family:Calibri Light;font-family:Calibri;font-weight:bold;color:red;text-shadow:3px 3px 5px yellow' class='darkGradient'> RATINGS <br><br><b style='font-size:60px;font-family:Calibri Light;color:blue;text-shadow:3px 3px 5px gray'><?php echo number_format($ratings,1,'.',',');?></b> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> GENDER: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$gender."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> BIRTH PLACE: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$birthplace."</b>";?> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> AGE: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$newAge."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> COLOR OF EYES: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$eyes."</b>";?> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> NATIONALITY: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$nationality."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> COLOR OF HAIR: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$hair."</b>";?> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> RELIGION: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$religion."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> HEIGHT: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$height." cm</b>";?> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> DATE HIRED: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$datehired."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> WEIGHT: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$weight." lbs</b>";?> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> CONTRACT: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$contractStart. " - ".$contractEnd."</b>";?> </td> <td colspan='1' style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> SIZE OF SHOES: </td> <td colspan='1' style='width:20%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <?php echo "<b style='font-family:Calibri; font-size:11px;font-weight:bold;color:black ;line-height:150%'>".$shoeSize."</b>";?> </td> </tr> </table> </div> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> Contact Information <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?contact=gcon&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Update</a></div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <table style='width:100%;border-collapse:collapse;'> <tr style='background:white;border:1px solid white'> <td style='width:30%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <table style='width:100%;border-collapse:collapse;'> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> E-MAIL ADDRSS: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $email;?> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> MODILE NUMBER: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $mobile;?> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> LANDLINE: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $landline;?> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:7%;background:white;border:1px solid white;font-size:11px;color: #65656a '> FACEBOOK: </td> <td style='padding:5px;width:23%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $fb;?> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> INSTAGRAM: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $ig;?>: </td> </tr> <tr style='background:white;border:1px solid white'> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> TWITTER: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $tw;?>: </td> </tr> <td style='padding:5px;width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> VIBER NUMBER: </td> <td style='padding:5px;width:20%;background:white;border:1px solid white;font-size:11px;color: #000 '> <?php echo $vb;?> </td> </tr> </table> </td> <td valign='top' style='width:60%;background:white;border:1px solid white;font-size:11px;color: #65656a '> <table style='width:100%;border-collapse:collapse;'> <tr style='background:white;border:1px solid white'> <td style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a'> HOME ADDRESS <p style='font-family:Calibri;font-size:12px;color:black'> <?php echo $street.", ". $city;?> </p> <br> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> PERMANENT ADDRESS <p style='font-family:Calibri;font-size:12px;color:black'> <?php echo $permanent_address.", ". $permanent_city;?> </p><br> </td> </tr> <tr style='background:white;border:1px solid white'> <td style='width:10%;background:white;border:1px solid white;font-size:11px;color: #65656a '> PROVINCIAL ADDRESS <p style='font-family:Calibri;font-size:12px;color:black'> <?php echo $provincial_address.", ". $provincial_city;?> </p><br> </td> </tr> </table> </td> </tr> </table> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> Educational Information <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?educ=true&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Add Record</a></div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <?php $edu = mysql_query("SELECT FROM `education` WHERE `talent_id`='$id' AND `status`='1'"); echo "<div style='position:relative;border:1px solid white;width:100%;height:197px;overflow:auto'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>LEVEL</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>NAME OF SCHOOL</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>COURSE TAKEN / MAJOR</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>MAJOR</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:5%;height:20px;padding:3px;border:1px solid lightgray'>YEAR</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:40%;height:20px;padding:3px;border:1px solid lightgray'>REMARKS</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:3%;height:20px;padding:3px;border:1px solid lightgray'></td>"; echo "</tr>"; while($row=mysql_fetch_array($edu)){ echo "<tr style=''>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['level']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['school']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['course']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['major']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['date_graduated']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>".$row['remarks']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'> <a href='main_new.php?view=100&sview=911&sid=UR&delete=educ&view=plist&id=".$_GET['id']."&recID=".$row['id']."&tab=0#id-0#'><ABBR title='DELETE RECORD'><img src='images/rica/delete_b.png'></img></ABBR></a> </td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> PROFILING SECTION <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?skills=true&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Add New Info</a></div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <?php $edu = mysql_query("SELECT * FROM `skills` WHERE `talent_id`='$id' AND `status`='1'"); echo "<div style='position:relative;border:1px solid white;width:100%;height:197px;overflow:auto'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:5%;height:20px;padding:3px;border:1px solid lightgray'>NO</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:25%;height:20px;padding:3px;border:1px solid lightgray'>TITLE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:40%;height:20px;padding:3px;border:1px solid lightgray'>SKILLS / TALENT DESCRIPTION </td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>LEVEL</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:10%;height:20px;padding:3px;border:1px solid lightgray'>DATE ADDED</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:3%;height:20px;padding:3px;border:1px solid lightgray'></td>"; echo "</tr>"; while($row=mysql_fetch_array($edu)){ $count = $count + 1; echo "<tr style=''>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$count."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['title']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['description']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['level']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['date_added']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;border:1px solid lightgray' align='center'> <a href='main_new.php?view=100&sview=911&sid=UR&delete=skills&view=plist&id=".$_GET['id']."&recID=".$row['id']."&tab=0#id-0#'><ABBR title='DELETE RECORD'><img src='images/rica/delete_b.png'></img></ABBR></a> </td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> WORK HISTORY <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?jobhis=true&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Add Work History</a></div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <?php $edu = mysql_query("SELECT * FROM `job_history` WHERE `talent_id`='$id' AND `status`='1'"); echo "<div style='position:relative;border:1px solid white;width:100%;height:197px;overflow:auto'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:5%;height:20px;padding:3px;border:1px solid lightgray'>NO</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>DATE START</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>DATE END</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>POSITION </td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>COMPANY</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:30%;height:20px;padding:3px;border:1px solid lightgray'>REASONS FOR LEAVING</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:3%;height:20px;padding:3px;border:1px solid lightgray'></td>"; echo "</tr>"; while($row=mysql_fetch_array($edu)){ $xcount = $xcount + 1; echo "<tr style=''>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$xcount."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['date_start']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['date_end']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['position']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['company']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['reasons']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;border:1px solid lightgray' align='center'> <a href='main_new.php?view=100&sview=911&sid=UR&delete=jobhis&view=plist&id=".$_GET['id']."&recID=".$row['id']."&tab=0#id-0#'><ABBR title='DELETE RECORD'><img src='images/rica/delete_b.png'></img></ABBR></a> </td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> PROJECT HISTORY <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?proj=true&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Add Projects</a> </div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <?php $edu = mysql_query("SELECT * FROM `projects` WHERE `talent_id`='$id' AND `status`='1'"); echo "<div style='position:relative;border:1px solid white;width:100%;height:197px;overflow:auto'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:5%;height:20px;padding:3px;border:1px solid lightgray'>NO</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>PROJECT CODE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>PRODUCT</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>PRODUCTION</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>AGENCY</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:10%;height:20px;padding:3px;border:1px solid lightgray'>SHOOT DATE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:10%;height:20px;padding:3px;border:1px solid lightgray'>T.F AMOUNT</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:1 %;height:20px;padding:3px;border:1px solid lightgray'>RATINGS</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:1 %;height:20px;padding:3px;border:1px solid lightgray'>LOCKOUT</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:10%;height:20px;padding:3px;border:1px solid lightgray'>BOOKER</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:3%;height:20px;padding:3px;border:1px solid lightgray'></td>"; echo "</tr>"; while($row=mysql_fetch_array($edu)){ $xcount = $xcount + 1; echo "<tr style=''>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$xcount."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['project_code']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['product']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['production']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['agency']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['shoot_date']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".number_format($row['tf_amount'],2,'.',',')."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['ratings']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['lockout']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['booker']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;border:1px solid lightgray' align='center'> <a href='main_new.php?view=100&sview=911&sid=UR&delete=proj&view=plist&id=".$_GET['id']."&recID=".$row['id']."&tab=0#id-0#'><ABBR title='DELETE RECORD'><img src='images/rica/delete_b.png'></img></ABBR></a> </td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <div class="lightGradient" style='height:25px;border:1px solid white;margin:0px;font-family:Calibri Light;font-size:16px '> <img src='images/bullet.gif' width='10px' height='10px'> </img> WORKSHOP ATTENDED <div style='positon:relative;float:right;padding-top:5px;padding-right:10px'> <a href='main_new.php?ws=true&view=100&sview=911&sid=UR&search=&view=plist&id=13&tab=0#id-0' style='font-size:12px;font-weight:normal;color:blue'>Add Workshop</a> </div> </div> <div style='height:200px;border:1px solid white;margin:0px'> <?php $edu = mysql_query("SELECT * FROM `workshops` WHERE `talent_id`='$id' AND `status`='1'"); echo "<div style='position:relative;border:1px solid white;width:100%;height:197px;overflow:auto'>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr style=''>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:5%;height:20px;padding:3px;border:1px solid lightgray'>NO</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>TITLE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>FACILITATOR</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:20%;height:20px;padding:3px;border:1px solid lightgray'>PLACE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:15%;height:20px;padding:3px;border:1px solid lightgray'>DATE</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:10%;height:20px;padding:3px;border:1px solid lightgray'>STATUS</td>"; echo "<td class='lightGradient' style='font-family:Calibri;font-size:10px;width:3%;height:20px;padding:3px;border:1px solid lightgray'></td>"; echo "</tr>"; while($row=mysql_fetch_array($edu)){ $xcount = $xcount + 1; echo "<tr style=''>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$xcount."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['title']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['facilitator']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['place']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['date']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;padding:3px;border:1px solid lightgray'>".$row['completed']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;height:20px;border:1px solid lightgray' align='center'> <a href='main_new.php?view=100&sview=911&sid=UR&delete=ws&view=plist&id=".$_GET['id']."&recID=".$row['id']."&tab=0#id-0#'><ABBR title='DELETE RECORD'><img src='images/rica/delete_b.png'></img></ABBR></a> </td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?> </div> <!-- ////////////////////////////////////////////////////////////////////////////////////////////////////////--> <?php echo "</div>"; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.02 | proxy | phpinfo | Settings