<?php require_once('header.php'); ?>
<?php
if(isset($_POST['form1'])) {
$valid = 1;
if(empty($_POST['name'])) {
$valid = 0;
$error_message .= 'Name can not be empty<br />';
}
if(empty($_POST['designation_id'])) {
$valid = 0;
$error_message .= 'Вы должны выбрать должность<br />';
}
$path = $_FILES['photo']['name'];
$path_tmp = $_FILES['photo']['tmp_name'];
if($path!='') {
$ext = pathinfo( $path, PATHINFO_EXTENSION );
$file_name = basename( $path, '.' . $ext );
if( $ext!='jpg' && $ext!='png' && $ext!='jpeg' && $ext!='gif' ) {
$valid = 0;
$error_message .= 'Вы должны загрузить файл jpg, jpeg, gif или png для фотографии<br />';
}
} else {
$valid = 0;
$error_message .= 'Вы должны выбрать фото<br />';
}
$path1 = $_FILES['banner']['name'];
$path_tmp1 = $_FILES['banner']['tmp_name'];
if($path1!='') {
$ext1 = pathinfo( $path1, PATHINFO_EXTENSION );
$file_name1 = basename( $path1, '.' . $ext1 );
if( $ext1!='jpg' && $ext1!='png' && $ext1!='jpeg' && $ext1!='gif' ) {
$valid = 0;
$error_message .= 'Для баннера необходимо загрузить файл jpg, jpeg, gif или png.<br />';
}
} else {
$valid = 0;
$error_message .= 'Вы должны выбрать фото для баннера<br />';
}
if($valid == 1) {
// getting auto increment id
$statement = $pdo->prepare("SHOW TABLE STATUS LIKE 'nrd_team_member'");
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row) {
$ai_id=$row[10];
}
if($_POST['slug'] == '') {
// generate slug
$temp_string = strtolower($_POST['name']);
$slug = preg_replace('/^[а-яА-ЯёЁa-zA-Z0-9]+$/', '-', $temp_string);
} else {
$temp_string = strtolower($_POST['slug']);
$slug = preg_replace('/[^A-Za-z0-9-]+/', '-', $temp_string);
}
// if slug already exists, then rename it
$statement = $pdo->prepare("SELECT * FROM nrd_team_member WHERE slug=?");
$statement->execute(array($slug));
$total = $statement->rowCount();
if($total) {
$slug = $slug.'-1';
}
$final_name = 'team-member-'.$ai_id.'.'.$ext;
move_uploaded_file( $path_tmp, '../assets/uploads/'.$final_name );
$final_name1 = 'team-member-banner-'.$ai_id.'.'.$ext1;
move_uploaded_file( $path_tmp1, '../assets/uploads/'.$final_name1 );
$statement = $pdo->prepare("INSERT INTO nrd_team_member (name,slug,designation_id,photo,banner,degree,detail,facebook,twitter,linkedin,youtube,google_plus,instagram,flickr,address,practice_location,phone,email,website,status,meta_title,meta_keyword,meta_description) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
$statement->execute(array($_POST['name'],$slug,$_POST['designation_id'],$final_name,$final_name1,$_POST['degree'],$_POST['detail'],$_POST['facebook'],$_POST['twitter'],$_POST['linkedin'],$_POST['youtube'],$_POST['google_plus'],$_POST['instagram'],$_POST['flickr'],$_POST['address'],$_POST['practice_location'],$_POST['phone'],$_POST['email'],$_POST['website'],$_POST['status'],$_POST['meta_title'],$_POST['meta_keyword'],$_POST['meta_description']));
$success_message = 'Команда успешно обновлена!';
unset($_POST['name']);
unset($_POST['slug']);
unset($_POST['degree']);
unset($_POST['detail']);
unset($_POST['facebook']);
unset($_POST['twitter']);
unset($_POST['linkedin']);
unset($_POST['youtube']);
unset($_POST['google_plus']);
unset($_POST['instagram']);
unset($_POST['flickr']);
unset($_POST['address']);
unset($_POST['practice_location']);
unset($_POST['phone']);
unset($_POST['email']);
unset($_POST['website']);
unset($_POST['meta_title']);
unset($_POST['meta_keyword']);
unset($_POST['meta_description']);
}
}
?>
<section class="content-header">
<div class="content-header-left">
<h1>Добавление в команду</h1>
</div>
<div class="content-header-right">
<a href="team-member.php" class="btn btn-primary btn-sm">Вся команда</a>
</div>
</section>
<section class="content">
<div class="row">
<div class="col-md-12">
<?php if($error_message): ?>
<div class="callout callout-danger">
<p>
<?php echo $error_message; ?>
</p>
</div>
<?php endif; ?>
<?php if($success_message): ?>
<div class="callout callout-success">
<p><?php echo $success_message; ?></p>
</div>
<?php endif; ?>
<form class="form-horizontal" action="" method="post" enctype="multipart/form-data">
<div class="box box-info">
<div class="box-body">
<div class="form-group">
<label for="" class="col-sm-2 control-label">Имя <span>*</span></label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="name" value="<?php if(isset($_POST['name'])){echo $_POST['name'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">URL </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="slug" value="<?php if(isset($_POST['slug'])){echo $_POST['slug'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Должность <span>*</span></label>
<div class="col-sm-3">
<select class="form-control select2" name="designation_id" style="width:300px;">
<option value="">Выберите должность</option>
<?php
$i=0;
$statement = $pdo->prepare("SELECT * FROM nrd_designation ORDER BY designation_name ASC");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
?>
<option value="<?php echo $row['designation_id']; ?>"><?php echo $row['designation_name']; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Фото <span>*</span></label>
<div class="col-sm-9" style="padding-top:5px">
<input type="file" name="photo">(Разрешены только jpg, jpeg, gif и png.)
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Баннер <span>*</span></label>
<div class="col-sm-9" style="padding-top:5px">
<input type="file" name="banner">(Разрешены только jpg, jpeg, gif и png.)
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Уровень </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="degree" value="<?php if(isset($_POST['degree'])){echo $_POST['degree'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Детали </label>
<div class="col-sm-9">
<textarea class="form-control" name="detail" id="editor1"><?php if(isset($_POST['detail'])){echo $_POST['detail'];} ?></textarea>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Facebook </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="facebook" value="<?php if(isset($_POST['facebook'])){echo $_POST['facebook'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Twitter </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="twitter" value="<?php if(isset($_POST['twitter'])){echo $_POST['twitter'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">LinkedIn </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="linkedin" value="<?php if(isset($_POST['linkedin'])){echo $_POST['linkedin'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">YouTube </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="youtube" value="<?php if(isset($_POST['youtube'])){echo $_POST['youtube'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Google Plus </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="google_plus" value="<?php if(isset($_POST['google_plus'])){echo $_POST['google_plus'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Instagram </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="instagram" value="<?php if(isset($_POST['instagram'])){echo $_POST['instagram'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Flickr </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="flickr" value="<?php if(isset($_POST['flickr'])){echo $_POST['flickr'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Адрес </label>
<div class="col-sm-6">
<textarea class="form-control" name="address" style="height: 140px"><?php if(isset($_POST['address'])){echo $_POST['address'];} ?></textarea>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Место практики </label>
<div class="col-sm-6">
<textarea class="form-control" name="practice_location" style="height: 140px"><?php if(isset($_POST['practice_location'])){echo $_POST['practice_location'];} ?></textarea>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Телефон </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="phone" value="<?php if(isset($_POST['phone'])){echo $_POST['phone'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Email</label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="email" value="<?php if(isset($_POST['email'])){echo $_POST['email'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Website </label>
<div class="col-sm-6">
<input type="text" autocomplete="off" class="form-control" name="website" value="<?php if(isset($_POST['website'])){echo $_POST['website'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Активность? </label>
<div class="col-sm-6">
<label class="radio-inline">
<input type="radio" name="status" value="Active" checked>Да
</label>
<label class="radio-inline">
<input type="radio" name="status" value="Inactive">Нет
</label>
</div>
</div>
<h3 class="seo-info">SEO информация</h3>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Заголовок Title </label>
<div class="col-sm-9">
<input type="text" autocomplete="off" class="form-control" name="meta_title" value="<?php if(isset($_POST['meta_title'])){echo $_POST['meta_title'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Ключевые слова Keywords </label>
<div class="col-sm-9">
<input type="text" autocomplete="off" class="form-control" name="meta_keyword" value="<?php if(isset($_POST['meta_keyword'])){echo $_POST['meta_keyword'];} ?>">
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label">Описание Description </label>
<div class="col-sm-9">
<textarea class="form-control" name="meta_description" style="height:140px;"><?php if(isset($_POST['meta_description'])){echo $_POST['meta_description'];} ?></textarea>
</div>
</div>
<div class="form-group">
<label for="" class="col-sm-2 control-label"></label>
<div class="col-sm-6">
<button type="submit" class="btn btn-success pull-left" name="form1">Добавить</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</section>
<?php require_once('footer.php'); ?>