insert, update 쿼리 병합 채택완료

</p>

<p><?php</p>

<p>$conn = mysqli_connect("localhost", "****", "****", "****");</p>

<p> </p>

<p>$zzzz = $_GET['cccc'];</p>

<p>$action = isset($_GET['action']) ? $_GET['action'] : 'in';</p>

<p>$time = date("Y-m-d H:i:s"); // 현재시간 저장</p>

<p>$today = date("Y-m-d");</p>

<p> </p>

<p>if ($action !== 'in' && $action !== 'out') {</p>

<p>    echo "잘못된 action 값입니다.";</p>

<p>    exit;</p>

<p>}</p>

<p>

 </p>

<p>if ($action === 'in') {</p>

<p>    // 출근 처리 (중복 체크 후 insert)</p>

<p>    $check_sql = "SELECT COUNT(*) FROM very_work_time WHERE work_total = '$zzzz' AND DATE(work_datetime) = '$today'";</p>

<p>    $check_result = mysqli_query($conn, $check_sql);</p>

<p>    $check_row = mysqli_fetch_row($check_result);</p>

<p>    if ($check_row[0] == 0) {</p>

<p>        $sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total)</p>

<p>                SELECT id, work_name, work_group, '$time', '', '$time', '{$_SERVER['REMOTE_ADDR']}', '$zzzz'</p>

<p>                FROM very_work_list</p>

<p>                WHERE work_hp = '$zzzz'";</p>

<p>       </p>

<p>        if (!mysqli_query($conn, $sql)) {</p>

<p>            echo "에러: " . $sql . "
" . mysqli_error($conn);</p>

<p>            exit;</p>

<p>        }</p>

<p>    }</p>

<p>} else {</p>

<p>    // 퇴근 처리 (update)</p>

<p>    $sql  = "UPDATE very_work_time</p>

<p>             SET work_outtime = '$time'</p>

<p>             WHERE id IN (</p>

<p>                 SELECT a.id FROM (</p>

<p>                     SELECT id FROM very_work_time WHERE work_total = '$zzzz' ORDER BY work_datetime DESC LIMIT 1</p>

<p>                 ) a</p>

<p>             )";</p>

<p>    if (!mysqli_query($conn, $sql)) {</p>

<p>        echo "에러: " . $sql . "
" . mysqli_error($conn);</p>

<p>        exit;</p>

<p>    }</p>

<p>}</p>

<p> </p>

<p>    if($action === 'in'){</p>

<p>        echo '<img src="<a href="https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png"" target="_blank" rel="noopener noreferrer">https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png"</a> alt="Google Logo">';</p>

<p>    }else{</p>

<p>        echo '<img src="<a href="https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png"" target="_blank" rel="noopener noreferrer">https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png"</a> alt="Google Logo">';</p>

<p>    }</p>

<p> </p>

<p>?></p>

<p>