ajustaTiempos(grafo, cp, max coste, coste, coste total, c alternativos, costDVFS)

Descripción del simulador E STE cap´ıtulo abordará la descripción en detalle de los módulos implementados y fases que forman el

Algoritmo 3.8 ajustaTiempos(grafo, cp, max coste, coste, coste total, c alternativos, costDVFS)

Page - 64

Coding for Department.php

<?php

include_once("../includes/db_connect.php");

include_once("../includes/functions.php");

if($_REQUEST[act]=="save_department")

{

save_department();

exit;

}

if($_REQUEST[act]=="delete_department")

{

delete_department();

exit;

}

Page - 65

function save_department()

{

$R=$_REQUEST;

if($R[department_id])

{

$statement = "UPDATE `department` SET";

$cond = "WHERE `department_id` = '$R[department_id]'";

$msg = "Data Updated Successfully.";

}

else

{

$statement = "INSERT INTO `department` SET";

$cond = "";

$msg="Data saved successfully.";

}

Page - 66

$SQL= $statement."

`department_title` = '$R[department_title]',

`department_description` = '$R[department_description]'".

$cond;

$rs = mysql_query($SQL) or die(mysql_error());

header("Location:../department-report.php?msg=$msg");

}

#########Function for delete department##########3

function delete_department()

{

/////////Delete the record//////////

$SQL="DELETE FROM department WHERE department_id = $_REQUEST[department_id]";

mysql_query($SQL) or die(mysql_error());

header("Location:../department-report.php?msg=Deleted Successfully.");

}

Page - 67

<?php

include_once("../includes/db_connect.php");

include_once("../includes/functions.php");

if($_REQUEST[act]=="save_designation")

{

save_designation();

exit;

}

if($_REQUEST[act]=="delete_designation")

{

delete_designation();

exit;

}

Page - 68

###Code for save designation#####

function save_designation()

{

$R=$_REQUEST;

if($R[designation_id])

{

$statement = "UPDATE `designation` SET";

$cond = "WHERE `designation_id` = '$R[designation_id]'";

$msg = "Data Updated Successfully.";

}

else

{

$statement = "INSERT INTO `designation` SET";

$cond = "";

$msg="Data saved successfully.";

}

Page - 69

$SQL= $statement."

`designation_title` = '$R[designation_title]',

`designation_description` = '$R[designation_description]'".

$cond;

$rs = mysql_query($SQL) or die(mysql_error());

header("Location:../designation-report.php?msg=$msg");

}

#########Function for delete designation##########3

function delete_designation()

{

/////////Delete the record//////////

$SQL="DELETE FROM designation WHERE designation_id = $_REQUEST[designation_id]";

mysql_query($SQL) or die(mysql_error());

header("Location:../designation-report.php?msg=Deleted Successfully.");

}

Page - 70

Coding for Login.php

<?php

session_start();

include_once("../includes/db_connect.php");

if($_REQUEST[act]=="check_login")

{

check_login();

}

if($_REQUEST[act]=="logout")

{

logout();

}

if($_REQUEST[act] == "change_password")

{

Page - 71

}

####Function check user#######

function check_login()

{

$user_user=$_REQUEST[user_user];

$user_password=$_REQUEST[user_password];

$SQL="SELECT * FROM user WHERE user_username = '$user_user' AND user_password = '$user_password'";

$rs = mysql_query($SQL) or die(mysql_error());

if(mysql_num_rows($rs))

{

$_SESSION[login]=1;

$_SESSION['user_details'] = mysql_fetch_assoc($rs);

///Redirect to booking page ////

if($_SESSION['route_id']) {

Page - 72

$route_id = $_SESSION['route_id'];

header("Location:../book.php?route_id=".$route_id);

exit;

}

header("Location:../index.php");

}

else

{

header("Location:../login.php?msg=Invalid User and Password.");

}

####Function logout####

function logout()

{

$_SESSION[login]=0;

$_SESSION['user_details'] = 0;

Page - 73

}

#####Function for changing the password ####

function change_password() {

$R = $_REQUEST;

if($R['user_confirm_password'] != $R['user_new_password']) {

header("Location:../change-password.php?msg=Your new passsword and confirm password does not match!!!");

exit;

}

$SQL = "UPDATE `user` SET user_password = '$R[user_new_password]' WHERE `user_id` =

".$_SESSION['user_details']['user_id'];

$rs = mysql_query($SQL) or die(mysql_error());

header("Location:../change-password.php?msg=Your Password Changed Successfully !!!");

print $SQL;

die;

Page - 74

Coding for Record.php

<?php

include_once("../includes/db_connect.php");

include_once("../includes/functions.php");

if($_REQUEST[act]=="save_record")

{

save_record();

exit;

}

if($_REQUEST[act]=="delete_record")

{

delete_record();

exit;

}

Page - 75

function save_record()

{

$R=$_REQUEST;

if($R[record_id])

{

$statement = "UPDATE `record` SET";

$cond = "WHERE `record_id` = '$R[record_id]'";

$msg = "Data Updated Successfully.";

}

else

{

$statement = "INSERT INTO `record` SET";

$cond = "";

$msg="Data saved successfully.";

}

Page - 76

$SQL= $statement."

`record_user_id` = '$R[record_user_id]',

`record_department` = '$R[record_department]',

`record_designation` = '$R[record_designation]',

`record_doj` = '$R[record_doj]',

`record_pf_account_no` = '$R[record_pf_account_no]',

`record_salary_account_no` = '$R[record_salary_account_no]',

`record_insurance` = '$R[record_insurance]'

$cond;

$rs = mysql_query($SQL) or die(mysql_error());

header("Location:../user-report.php?type=2&msg=$msg");

}

#########Function for delete record##########3

function delete_record()

Page - 77

/////////Delete the record//////////

$SQL="DELETE FROM record WHERE record_id = $_REQUEST[record_id]";

mysql_query($SQL) or die(mysql_error());

header("Location:../record-report.php?msg=Deleted Successfully.");

}

Page - 78

Coding for Salary.php

<?php

include_once("../includes/db_connect.php");

include_once("../includes/functions.php");

if($_REQUEST[act]=="save_salary")

{

save_salary();

exit;

}

if($_REQUEST[act]=="delete_salary")

{

delete_salary();

exit;

}

Page - 79

function save_salary()

{

$R=$_REQUEST;

if($R[salary_id])

{

$statement = "UPDATE `salary` SET";

$cond = "WHERE `salary_id` = '$R[salary_id]'";

$msg = "Data Updated Successfully.";

}

else

{

$statement = "INSERT INTO `salary` SET";

$cond = "";

$msg="Data saved successfully.";

}

Page - 80

$totalPay = $R[salary_basic] + $R[salary_hra] + $R[salary_mediclaim] + $R[salary_ta] +

$R[salary_da] + $R[salary_reimbursement] + $R[salary_ca] + $R[salary_others];

$totalDedc = $R[salary_dpf] + $R[salary_dtax];

$SQL= $statement."

`salary_user_id` = '$R[salary_user_id]',

`salary_month` = '$R[salary_month]',

`salary_working_days` = '$R[salary_working_days]',

`salary_basic` = '$R[salary_basic]',

`salary_hra` = '$R[salary_hra]',

`salary_mediclaim` = '$R[salary_mediclaim]',

`salary_ta` = '$R[salary_ta]',

`salary_da` = '$R[salary_da]',

`salary_reimbursement` = '$R[salary_reimbursement]',

`salary_ca` = '$R[salary_ca]',

`salary_others` = '$R[salary_others]',

Page - 81

`salary_desc` = '$R[salary_desc]',

`salary_total` = '$totalPay',

`salary_dedc` = '$totalDedc',

`salary_dtax` = '$R[salary_dtax]'".

$cond;

$rs = mysql_query($SQL) or die(mysql_error());

header("Location:../salary-report.php?msg=$msg");

}

#########Function for delete salary##########3

function delete_salary()

{

/////////Delete the record//////////

$SQL="DELETE FROM salary WHERE salary_id = $_REQUEST[salary_id]";

mysql_query($SQL) or die(mysql_error());

header("Location:../salary-report.php?msg=Deleted Successfully

Page - 82

Coding for User.php

<?php

session_start();

include_once("../includes/db_connect.php");

include_once("../includes/functions.php");

if($_REQUEST[act]=="save_user")

{

save_user();

exit;

}

if($_REQUEST[act]=="delete_user")

{

delete_user();

exit;

}

Page - 83

{

get_report();

exit;

}

###Code for save user#####

function save_user()

{

$R=$_REQUEST;

///Checking Username Exits or not ////

$SQL="SELECT * FROM user WHERE user_username = '$_REQUEST[user_username]'";

$rs=mysql_query($SQL);

$data=mysql_fetch_assoc($rs);

if($data['user_username'] && $R['user_id'] != $_SESSION['user_details']['user_id']) {

header("Location:../user.php?msg=Username Already Exits. Kindly choose another....");

Page - 84

return;

}

/////////////////////////////////////

$image_name = $_FILES[user_image][name];

$location = $_FILES[user_image][tmp_name];

if($image_name!="")

{

move_uploaded_file($location,"../uploads/".$image_name);

}

else

{

$image_name = $R[avail_image];

}

if($R[user_level_id] == "" || !isset($R[user_level_id]))

{

$R[user_level_id] = 2;

Page - 85

if($R[user_id])

{

$statement = "UPDATE `user` SET";

$cond = "WHERE `user_id` = '$R[user_id]'";

$msg = "Data Updated Successfully.";

$condQuery = "";

}

else

{

$statement = "INSERT INTO `user` SET";

$condQuery = "`user_username` = '$R[user_username]',

`user_password` = '$R[user_password]',";

$cond = "";

$msg="Data saved successfully.";

}

Page - 86

$SQL= $statement."

`user_level_id` = '$R[user_level_id]',

$condQuery

`user_name` = '$R[user_name]',

`user_add1` = '$R[user_add1]',

`user_add2` = '$R[user_add2]',

`user_city` = '$R[user_city]',

`user_state` = '$R[user_state]',

`user_country` = '$R[user_country]',

`user_email` = '$R[user_email]',

`user_mobile` = '$R[user_mobile]',

`user_gender` = '$R[user_gender]',

`user_dob` = '$R[user_dob]',

`user_image` = '$image_name'".

Page - 87

$rs = mysql_query($SQL) or die(mysql_error());

if($_SESSION['login']!=1)

{

header("Location:../login.php?msg=You are registered successfully. Login with your credential !!!");

exit;

}

else if($_SESSION['user_details']['user_level_id'] == 3) {

header("Location:../user.php?user_id=".$_SESSION['user_details']['user_id']."&msg=Your account updated successfully !!!");

exit;

}

header("Location:../user-report.php?msg=$msg&type=$R[user_level_id]");

}

#########Function for delete user##########3

Page - 88

function delete_user()

{

$SQL="SELECT * FROM user WHERE user_id = $_REQUEST[user_id]";

$rs=mysql_query($SQL);

$data=mysql_fetch_assoc($rs);

/////////Delete the record//////////

$SQL="DELETE FROM user WHERE user_id = $_REQUEST[user_id]";

mysql_query($SQL) or die(mysql_error());

//////////Delete the image///////////

if($data[user_image])

{

unlink("../uploads/".$data[user_image]);

}

header("Location:../user-report.php?msg=Deleted Successfully.&type=$data[user_level_id]");

Page - 89

<?php include_once("includes/header.php"); ?>

</div>

<h4 class="heading colr">Change Your Account Password</h4>

<li class="txt">New Password</li>

</ul>

Page - 90

<li class="txt">Confirm Password</li>

</ul>

<li class="textfield"><input type="submit"

value="Change Password" class="simplebtn"></li>

<li class="textfield"><input type="reset"

value="Reset" class="resetbtn"></li>

</ul>

<input type="hidden" name="act"

value="change_password">

</form>

</div>

Page - 91

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 92

Coding for Contact.php

<?php include_once("includes/header.php"); ?>

<ul>

<li><a href="#">About Us</a></li>

</ul>

</div>

<h4 class="heading colr">Contact Us</h4>

Page - 93

<li class="inputfield"><input name="in" type="text"

class="bar" required/></li>

</ul>

<li class="txt">Company</li>

<li class="inputfield"><input name="in" type="text"

class="bar" required/></li>

</ul>

<li class="txt">Email</li>

<li class="inputfield"><input name="in" type="text"

class="bar" required/></li>

</ul>

<li class="txt">Phone</li>

Page - 94

<li class="inputfield"><input name="in" type="text"

class="bar" required/></li>

</ul>

<li class="txt">Message</li>

<li class="textfield"><textarea name="in" cols=""

rows="6" required></textarea></li>

</ul>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

<li class="textfield"><input type="reset" value="Reset"

class="resetbtn"></li>

</ul>

</form>

</div>

Page - 95

<h4 class="heading colr">Where to find us.</h4>

<a href="#" class="mapcont"><img src="./images/map.gif" alt=""

style="width:250px;"/></a>

<h4>Get in touch</h4>

<p>

You’ll find us offices sitting right in <br />

the town centre in the middle of Guildford, Surrey.<br />

<br />

171 abc Street<br />

Lipsum<br />

Lorem<br />

GU5 3AB<br />

Page - 96

+44 (0)2563 586215<br />

<a href="">[email protected]</a><br />

</p>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 97

<?php include_once("includes/header.php"); ?>

<ul>

<li><a href="#">About Us</a></li>

</ul>

</div>

<h4 class="heading colr">Contact Us</h4>

<div>Thank you for contacting us. We will get back to you soon

!!!!</div>

Page - 98

</div>

<h4 class="heading colr">Where to find us.</h4>

<a href="#" class="mapcont"><img src="./images/map.gif" alt=""

style="width:250px;"/></a>

<h4>Get in touch</h4>

<p>

You’ll find us offices sitting right in <br />

the town centre in the middle of Guildford, Surrey.<br />

<br />

171 abc Street<br />

Lipsum<br />

Lorem<br />

GU5 3AB<br />

Page - 99

+44 (0)2563 586215<br />

<a href="">[email protected]</a><br />

</p>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 100

Coding for Deprtment.php

<?php

include_once("includes/header.php");

if($_REQUEST[department_id])

{

$SQL="SELECT * FROM department WHERE department_id =

$_REQUEST[department_id]";

$rs=mysql_query($SQL) or die(mysql_error());

$data=mysql_fetch_assoc($rs);

}

<style>

ul.forms li.txt {

width:150px;

}

</style>

Page - 101

</div>

<h4 class="heading colr">Add Employee Department</h4>

<?php

if($_REQUEST['msg']) {

<?php

}

<form action="lib/department.php" enctype="multipart/form-data"

method="post" name="frm_department">

Page - 102

<li class="txt">Title</li>

<li class="inputfield"><input name="department_title"

id="department_title" type="text" class="bar" required value="<?=$data[department_title]?>"/></li>

</ul>

<li class="txt">Description</li>

<textarea name="department_description"

class="bar" required style="height:100px;

width:250px;"><?=$data[department_description]?></textarea>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

Page - 103

</ul>

<input type="hidden" name="department_id"

value="<?=$data[department_id]?>">

</form>

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 104

Coding for Department-Report.php

<?php

include_once("includes/header.php");

include_once("includes/db_connect.php");

$SQL="SELECT * FROM `department`";

$rs=mysql_query($SQL) or die(mysql_error());

function delete_department(department_id)

{

if(confirm("Do you want to delete the department?"))

{

this.frm_department.department_id.value=department_id;

this.frm_department.act.value="delete_department";

this.frm_department.submit();

Page - 105

}

</script>

</div>

<h4 class="heading colr">Department Report</h4>

<?php

if($_REQUEST['msg']) {

<?php

}

Page - 106

<tbody>

<td scope="col">Description</td>

<td scope="col">Action</td>

</tr>

<?php

$sr_no=1;

while($data = mysql_fetch_assoc($rs))

{

Page - 107

href="department.php?department_id=<?php echo $data[department_id] ?>">Edit</a> | <a href="Javascript:delete_department(<?=$data[department_id]?>)">Delete</a>

</td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

Page - 108

</form>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 109

<?php

include_once("includes/header.php");

if($_REQUEST[designation_id])

{

$SQL="SELECT * FROM designation WHERE designation_id =

$_REQUEST[designation_id]";

$rs=mysql_query($SQL) or die(mysql_error());

$data=mysql_fetch_assoc($rs);

}

<style>

ul.forms li.txt {

width:150px;

}

</style>

Page - 110

</div>

<h4 class="heading colr">Add Employee Designation</h4>

<?php

if($_REQUEST['msg']) {

<?php

}

<form action="lib/designation.php" enctype="multipart/form-data"

method="post" name="frm_designation">

Page - 111

<li class="txt">Title</li>

<li class="inputfield"><input name="designation_title"

id="designation_title" type="text" class="bar" required value="<?=$data[designation_title]?>"/></li>

</ul>

<li class="txt">Description</li>

<textarea name="designation_description"

class="bar" required style="height:100px;

width:250px;"><?=$data[designation_description]?></textarea>

</li>

</ul>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

Page - 112

<li class="textfield"><input type="reset" value="Reset"

class="resetbtn"></li>

</ul>

<input type="hidden" name="designation_id"

value="<?=$data[designation_id]?>">

</form>

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Page - 113

<?php

include_once("includes/header.php");

include_once("includes/db_connect.php");

$SQL="SELECT * FROM `designation`";

$rs=mysql_query($SQL) or die(mysql_error());

function delete_designation(designation_id)

{

if(confirm("Do you want to delete the designation?"))

{

this.frm_designation.designation_id.value=designation_id;

this.frm_designation.act.value="delete_designation";

this.frm_designation.submit();

Page - 114

}

</script>

</div>

<h4 class="heading colr">Designation Report</h4>

<?php

if($_REQUEST['msg']) {

<?php

}

Page - 115

<tbody>

<td scope="col">Description</td>

<td scope="col">Action</td>

</tr>

<?php

$sr_no=1;

while($data = mysql_fetch_assoc($rs))

{

Page - 116

<tr>

href="designation.php?designation_id=<?php echo $data[designation_id] ?>">Edit</a> | <a href="Javascript:delete_designation(<?=$data[designation_id]?>)">Delete</a>

</td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

Page - 117

</div>

<?php include_once("includes/footer.php"); ?>

Page - 118

Coding for Index.php

<?php

</ul>

Page - 119

<h4 class="heading colr">Payroll Management System</h4>

<div class="news"> warned or notified on the calendar)</p>

<div class="news_links"> offices. Ability to display balance in hours or in days

</p>

Page - 120

permissions. Single Sign-On, LDAP, Active Directory support thru OneLogin.comNew

</p> company logo to personalize the interface. Ability to set time-off, pending request and holiday

reminders

Page - 121

<?php include_once("includes/sidebar.php"); ?>

In document Planificación consciente del consumo en algoritmos de álgebra lineal densa sobre procesadores multinúcleo (página 42-48)