function addUserDetails() { //$companyId = $_REQUEST['companyId']; $userFname = trim($_REQUEST['userFname']); $userLname = trim($_REQUEST['userLname']); $age = trim($_REQUEST['age']); $sex = trim($_REQUEST['sex']); $emailId = trim($_REQUEST['emailId']); $address = trim($_REQUEST['address']); $userType = trim($_REQUEST['userType']); $companyID = trim($_REQUEST['companyID']); /* $userImage = trim($_REQUEST['image']); $userImage = trim($_REQUEST['image']['name']); */ $adminId = $_REQUEST['adminId']; //$adminId='e-002';// need to be send in request..for time being using hardcoded values. $fullName = $userFname . ' ' . $userLname; //$Mobile = $_REQUEST['Phone']; $rm = new Response_Methods(); if ($userFname == "" || $userLname == "" || $age == "" || $sex == "" || $emailId == "" || $address == "" || $userType == "") { //$sendMail=$rm->sendMailPasswordDetails($adminEmail,'test14521','sdfwd45487','Asif Anwar'); $result = $rm->fields_validation(); return $result; } else { $status = 0; date_default_timezone_set('Asia/Calcutta'); $createdDate = date('Y-m-d H:i:s'); //$max_login_id=$rm->getMaxID('login_t','login_user_id'); $passWord_Ran = substr(md5(rand(0, 1000000)), 0, 8); //$ENCRYPTEDPWD = base64_encode($passWord_Ran); $ENCRYPTEDPWD = $passWord_Ran; $getList = array(); //$getFieldValue['emp_id']=$userName; $getInsertFieldValue['password'] = $ENCRYPTEDPWD; $getInsertFieldValue['usertype'] = $userType; $lastInserted_login_user_id = $rm->insert_record($getInsertFieldValue, 'login_t'); if (!empty($lastInserted_login_user_id)) { $threeDigitID = str_pad($lastInserted_login_user_id, 3, "0", STR_PAD_LEFT); $userName = "******" . $threeDigitID; $sqlUpdate = "update login_t set emp_id='{$userName}' where login_user_id={$lastInserted_login_user_id}"; mysql_query($sqlUpdate, $GLOBALS['link']); //$PROFILE_PICTURE = $userData['profilePicture']['name']; /* $filTemLoc = $_FILES['image']['tmp_name']; $moveresult = move_uploaded_file($filTemLoc,"userPics/".$userImage); $getRegisterFieldValue['user_image']=$userImage; user image code commented */ $getRegisterFieldValue['user_fname'] = $userFname; $getRegisterFieldValue['user_lname'] = $userLname; $getRegisterFieldValue['user_age'] = $age; $getRegisterFieldValue['user_sex'] = $sex; $getRegisterFieldValue['user_email_id'] = $emailId; $getRegisterFieldValue['user_address'] = $address; $getRegisterFieldValue['login_user_id'] = $lastInserted_login_user_id; $getRegisterFieldValue['company_id'] = $companyID; $getRegisterFieldValue['user_created_date'] = $createdDate; $lastInserted_user_id = $rm->insert_record($getRegisterFieldValue, 'user_details_t'); if (!empty($lastInserted_user_id)) { if ($adminId) { $adminEmail = $rm->getAdminEmailID($adminId); //$adminEmail="*****@*****.**"; //die(); $sendMail = $rm->sendMailPasswordDetails($adminEmail, $userName, $passWord_Ran, $fullName); } $result = $rm->userRegisterSuccessJson($lastInserted_user_id); return $result; } else { $result = $rm->userRegisterFailJson(); return $result; } } else { $result = $rm->userRegisterFailJson(); return $result; } } }
function addPaymentDetails() { //$companyId = $_REQUEST['companyId']; $companyID = trim($_REQUEST['companyID']); $fromBankID = trim($_REQUEST['fromBankID']); $toBankID = trim($_REQUEST['toBankID']); //$paymentDate = trim($_REQUEST['paymentDate']); $paymentReason = trim($_REQUEST['paymentReason']); $amount = trim($_REQUEST['amount']); $paymentType = trim($_REQUEST['paymentType']); $userType = trim($_REQUEST['userType']); $userID = trim($_REQUEST['userID']); $user_request_id = trim($_REQUEST['user_request_id']); $payment_id = trim($_REQUEST['payment_id']); // in case of user $affectedRowsPayment = -1; $rm = new Response_Methods(); if ($companyID == "" || $fromBankID == "" || $paymentReason == "" || $amount == "" || $paymentType == "") { $result = $rm->fields_validation(); return $result; } else { date_default_timezone_set('Asia/Calcutta'); $createdDate = date('Y-m-d H:i:s'); $getList = array(); $mailData["paymentDetails"] = array(); //inserting payment details $getInsertFieldValue['company_id'] = $companyID; $getInsertFieldValue['payment_from_bank_id'] = $fromBankID; $getInsertFieldValue['payment_to_bank_id'] = $toBankID; //$getInsertFieldValue['payment_date']=$paymentDate; $getInsertFieldValue['payment_reason'] = $paymentReason; $getInsertFieldValue['login_user_id'] = $userID; $getInsertFieldValue['amount'] = $amount; $getInsertFieldValue['payment_type'] = $paymentType; $getInsertFieldValue['payment_created_date'] = $createdDate; $checkRecords = mysql_query("SELECT user_request_id FROM user_requests_t WHERE user_request_id='{$user_request_id}'"); $checkRecords = mysql_num_rows($checkRecords); if ($userType == 'Admin') { $checkRecords = 1; } if ($checkRecords > 0) { if (strtolower($userType) == "user") { $affectedRowsPayment = $rm->update_record($getInsertFieldValue, 'payment_details_t', 'payment_id', $payment_id); } else { if (strtolower($userType) == "admin") { $lastInserted_payment_id = $rm->insert_record($getInsertFieldValue, 'payment_details_t'); } } $mailData = $getInsertFieldValue; $mailData['userID'] = $userID; //array_push($mailData["paymentDetails"], $getInsertFieldValue); if (!empty($lastInserted_payment_id)) { //Do Transactions by updating banks current balance $fromBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $fromBankID); $toBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $toBankID); if ($fromBankBalance < $amount) { $result = $rm->insufficient_balance(); return $result; } if ($fromBankID != $toBankID) { $fromBankBalance = $fromBankBalance - $amount; $toBankBalance = $toBankBalance + $amount; } $updateFromBankBalance['initial_bank_balance'] = $fromBankBalance; $affectedRowsFrom = $rm->update_record($updateFromBankBalance, 'bank_details_t', 'bank_id', $fromBankID); $updateToBankBalance['initial_bank_balance'] = $toBankBalance; $affectedRowsTo = $rm->update_record($updateToBankBalance, 'bank_details_t', 'bank_id', $toBankID); } //check payment type and insert details accordingly(cheque/net) if (strtolower($paymentType) == "cheque") { //insert cheque details $mailData["chequeDetails"] = array(); if (!empty($lastInserted_payment_id)) { $payment_id_inserted = $lastInserted_payment_id; } else { $payment_id_inserted = $payment_id; } $getChequeDetails['payment_id'] = $payment_id_inserted; $getChequeDetails['cheque_number'] = trim($_REQUEST['chequeNo']); $getChequeDetails['cheque_date'] = trim($_REQUEST['chequeDate']); $getChequeDetails['to_whom_issued'] = trim($_REQUEST['chequeIssued']); //$getChequeDetails['cheque_amount']=trim($_REQUEST['chequeAmount']); $getChequeDetails['cheque_amount'] = $amount; $getChequeDetails['cheque_created_date'] = $createdDate; $lastInserted_cheque_id = $rm->insert_record($getChequeDetails, 'cheque_details_t'); array_push($mailData["chequeDetails"], $getChequeDetails); } else { if (strtolower($paymentType) == "net") { //insert NET Banking Details $mailData["netDetails"] = array(); if (!empty($lastInserted_payment_id)) { $payment_id_inserted = $lastInserted_payment_id; } else { $payment_id_inserted = $payment_id; } $getNetBankingDetails['payment_id'] = $payment_id_inserted; //$getNetBankingDetails['type']=trim($_REQUEST['netBankingType']); $getNetBankingDetails['nbd_created_date'] = $createdDate; $lastInserted_cheque_id = $rm->insert_record($getNetBankingDetails, 'net_banking_details_t'); array_push($mailData["netDetails"], $getNetBankingDetails); //print_r($getNetBankingDetails); } } if (strtolower($userType) == "user") { $adminId = 1; if ($adminId != 0) { $adminEmail = $rm->getAdminEmailID($adminId); //print_r($mailData);; $sendMail = $rm->sendTransactionDetails($adminEmail, $mailData); } } if (strtolower($userType) == "user" && $affectedRowsPayment >= 0) { $result = $rm->paymentRegisterSuccessJson($payment_id); $sqlUpdate = "update user_requests_t set status='Paid' where user_request_id={$user_request_id}"; mysql_query($sqlUpdate, $GLOBALS['link']); return $result; } else { if (strtolower($userType) == "admin" && !empty($lastInserted_payment_id)) { $result = $rm->paymentRegisterSuccessJson($lastInserted_payment_id); $sqlUpdate = "update user_requests_t set status='Paid' where user_request_id={$user_request_id}"; mysql_query($sqlUpdate, $GLOBALS['link']); return $result; } } if (empty($lastInserted_payment_id) && strtolower($userType) == "admin") { $result = $rm->paymentRegisterFailJson(); return $result; } if ($affectedRowsPayment < 0 && strtolower($userType) == "user") { $result = $rm->paymentRegisterFailJson(); return $result; } } else { $errorCode = "2"; $errorMsg = "User Request Not Exist"; $newData = "{\"data\":{\"Error_Code\":\"" . $errorCode . "\",\"Error_Msg\":\"" . $errorMsg . "\"}}"; //Json Format Response return $newData; } } }